Home > Sharepoint > Moving SharePoint 2007 SQL database from one to another drive on same server

Moving SharePoint 2007 SQL database from one to another drive on same server

I’ve moved SharePoint 2007 database from ‘C’ drive to another due to low space on ‘C’ drive. The process is straightforward and pretty simple.
Here are the steps to move all content databases to another drive.
1- Stop IIS on SharePoint Server
2- Stop the SharePoint services
3- From SQL Server Studio Management, right click on the SharePoint database and select “Detach”
4-There are number of database related to SharePoint. All databases are ‘Detach’ one by one from SQL studio management.
4- Copy the .mdl and .ldf files to the new location. After Copied delete files from existing location
5- Attach the database from the new location to SQL Server from the studio management
6-Start IIS & SharePoint Service.
7-Verified Database and Site is working

Advertisements
Categories: Sharepoint Tags:
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: