cancel
Showing results for 
Search instead for 
Did you mean: 

Moving SAP Database into another Hardisk

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks for your information this will help

Former Member
0 Kudos

Hi Expert

Thanks for your help , I moved the database to another location successfully

regards

Answers (1)

Answers (1)

rolfc_weber
Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Rolf

Thanks for your help it was really successfull