cancel
Showing results for 
Search instead for 
Did you mean: 

relocate database files on Windows

Former Member
0 Kudos

Hello Admins,

How can I relocate database files from D, where I have sapexe, to F, where I should have sapdata files. Its a NW7.31, only Java stack with Ms Sql DB.

Thank you

Accepted Solutions (1)

Accepted Solutions (1)

former_member185239
Active Contributor
0 Kudos

Hi Chris,

You can follow the below document as well but before moving the files , you need to put the database offline.

http://msdn.microsoft.com/en-us/library/ms345483.aspx

With Regards

Ashutosh Chaturvedi

Sriram2009
Active Contributor
0 Kudos

Hi Ashutosh

Its very easy task follows the steps, before that take backup in tape or disk

1. Stop the SAP system and then restart the MS Sql server

2. Go to MS Sql management studio

3. Select <MS Sql server name> - select the database '(SID)' then right click of mouse
Select the 'Tasks' click ‘Detach’

4. Stop the MS Sql server and then move or copy the database
files (file name extraction are .MDF, NDF & .LDF)  from 😧 to F: drive
 

5. After completed the copy or move the DB to F: start the MS Sql server, go to database select right click of mouse
and the press 'Attach' select the path in the new location (in your case drive letter F:)

6. Check the new location files

7. Start the Sap system and check the all the table information
are correct.

Thanks

Sriram

Answers (1)

Answers (1)

AtulKumarJain
Active Contributor
0 Kudos