Migrating/Moving Sharepoint content database

In some cases you want to increase the size of the SharePoint DB. So we will be adding extra disk, detach the Db & move it to the newly added  drive. Following are the steps followed.

  1. Take backup of the DB which the site is using from SQL server management studio.
  2. Now go to Central Admin Website -> Application Management ->SharePoint Web Application Management -> Content Databases.
  3. Select the appropriate web application. It will display the content DB(s) used by that application.
  4. Now click on the content DB which opens Manage Content Database Settings page.
  5. Note down all the details in this page, since we require this later. (A screen shot will be a better option).
  6. Select Remove content Database & click OK & again OK.
  7. Now we have to detach our database. To do so go to SQL Management studio & right click on the database and select Take Offline. Once the process is done again right click & select Detach.
  8. Now go to “drivename:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data” and files where the DB is already located.
  9. Copy the mdf & ldf file and place it in a new drive in same location “drivename:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data”
  10. Now go to SQL Management studio right click on the “Databases” in object explorer and click Attach.
  11. Click on Add, browse to the mdf file you copied & click OK.
  12. Now do follow step 2 & 3. In this case we will not see any content DB’s associated with the application.
  13. Click on Attach Content Database & fill in the details which we got in step 5.
  14. Note the DB name should be same as the previous one we detached.
  15. That’s all & your DB is migrated.

3 thoughts on “Migrating/Moving Sharepoint content database

Add yours

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: