on 07-01-2013 6:59 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Chris,
PLease check
http://help.sap.com/saphelp_nwpi711/helpdata/en/f2/31adad810c11d288ec0000e8200722/content.htm
BR
Atul
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 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.