Title: How to move sharepoint database from one drive to another
Description:
Following are the shortest and best steps.
Run net stop sptimerv4.
Run IISRESET /stop.
Deattach all SharePoint databases.
Copy both mdf, ldf from original location to new location.
Attach SharePoint databases
Verify databases property from SSMS (SQL Server Management Studio) Console.
Run net start sptimerv4
Run IISRESET/start
Note:
====
I have tried this steps on SP 2010 server, should work for SP 2007 server and WSS3 server.
Please take downtime before proceeding with this activity.
The time it take to complete this activity depends on the size of the database.
Keyword: move sharepoint database, shift sharepoint database, steps to move sharepoint database
Description:
Following are the shortest and best steps.
Run net stop sptimerv4.
Run IISRESET /stop.
Deattach all SharePoint databases.
Copy both mdf, ldf from original location to new location.
Attach SharePoint databases
Verify databases property from SSMS (SQL Server Management Studio) Console.
Run net start sptimerv4
Run IISRESET/start
Note:
====
I have tried this steps on SP 2010 server, should work for SP 2007 server and WSS3 server.
Please take downtime before proceeding with this activity.
The time it take to complete this activity depends on the size of the database.
Keyword: move sharepoint database, shift sharepoint database, steps to move sharepoint database