03 April, 2009

Move the SharePoint data from c:\ drive to d:\ drive

=Opened Central administration page and checked for no of web applications & system account (administrator) which is used for those web applications.

=Stopped all SharePoint related IIS web sites

=The following Services had set to Manual:
-Windows SharePoint Services Administration
-Windows SharePoint Services Timer
-Windows SharePoint Services Search
-Windows SharePoint Services Tracing
-Office Document Conversions Launcher Service
-Office Document Conversions Load Balancer Service
-Office SharePoint Server Search
-Indexing services
-IIS Admin Service

= Opened SQL Server Management Studio
= Expanded the Databases section
= For each SharePoint database we need to move, we must perform the following:
-Right clicked on the database
-Clicked on Properties
- Selected Files from the left hand pane
-Make note of the Path
-Clicked on Cancel
-Right clicked again on the database
-Selected Tasks -> Detach..
-Clicked the checkbox for Drop Connections. By default, the checkbox for keep Full Text Catalogs should be checked. Make sure that is true.
-Clicked OK
-For each additional database we need to move, perform the detach method for each
= Once we have detached all the databases, opened a Explorer window, and browse to the database location that was noted in the Properties task
= Selected the databases to be moved
= Right clicked, and selected Copy
= Browse to the new location for the databases
= Right clicked, and selected paste
= Go back to SQL Server Management Studio
= Right clicked on Database and selected Attach
= Clicked on Add..
= Browse to the new location for the databases and selected a database
= We have added each database one at a time
= reset all the services you set to manual in Step 2 to Automatic and started services.
= Turned on all IIS websites that we have stopped
= Browse to your central administration site; we were able to browse all sites correctly.
I hope the above steps will helps you to move your sharePoint databases from one drive to another drive. Thanks!

No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge