on 08-02-2007 9:10 AM
Hi Expert
I want to move all WG55 database into another free space hardisk under MMSQL 2000 enterprise edition , I have 3 database to move on Eg R:\WG55DATA1,WG55DATA2,WG55DATA3 and K:\tempdb.mdf
All the above database are in D:\WG55DATA1,WG55DATA2,WG55DATA2,tempdb.mdf so what is the best option to move all WG55 database to R and K respectively It is live Production system so i would be thankful if any expert person in MMSQL to guide me please
and I am using another server for application (Instance)
regards
the sap note above is well explained.
but, you may use SQL Enterprise manager.
1. stop sap.
2. detach Database (Enterprise manager, on DB Name -> All Tasks->Detach Database
3. Move Data and log files to new location
4. Database -> All Tasks -> Attach Database and find the MDF file (the first data file) from the new location. (you may have to find each of the data and log files)
5. verifiy it is correctly attached.
6. Start sap
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Moving the SQL files is independent of SAP, so there are no configuration changes in SAP, only in SQL server.
But SAP system has to be shut down while moving.
The steps to perform are described in SAP note <a href="https://service.sap.com/sap/support/notes/363018">363018</a>
Regards
Rolf
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.