How to
Migrate SharePoint content databases
This is the task that every SharePoint administrator
that should perform on regular. In this article I am providing the detailed
steps how to do that.
Steps:
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.
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
“drive name:\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 “drive name:\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.
Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!
SQL Server 2014