Jesoba.com is launched, Click below image to access it

Jesoba.com is launched, Click below image to access it
Technology and Entertainment Blog

How to move sharepoint database from one drive to another

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

Google+ Badge

About Author

My photo

I am Senior Server Expert and Professional Blogger.