How to move content database to new disk
Posted by Michał Juśkowiak | Posted in SharePoint | Posted on 04:31
0
Prerequisite
The URL of the application will be the same after content moving
There is no infrastructure changes during the backup and restore process
The essential steps of the content db moving
1.Site collection backup
The stsadm command which make the backup is the following:
stsadm -o backup -url <site collection url> -filename <backup filename>
2.Delete site collection
Delete site collection in Central Administration.
Note: it is recommended to create backup of site collection before starting that action (step 1). It should be touch DB and web-front ends also.
3.New content database creation
The stsadm command is the following:
stsadm -o addcontentdb -url <web application url> -databasename <name of database> -databaseserver <server or server\instance>
4.Change the SQL database files to new drive.
Detach created content database from MOSS. Detach it from SQL server. Copy the database files (*.lgf and *.mdf) to drive X. Re-attach the content database to MOSS.
5.Set other Content databases to "Offline"
Go to Central Admin site -> Application management -> Content databases. Set all other databases Offline, except the newly created content database. This way we can be certain that the site collection will be restored to the new content database.
6.Restore site collection
The following stsadm command does the action:
stsadm -o restore -url <site collection url>-filename <backup file name> -overwrite
Restore content databases to "Online"
Go to Central Admin site -> Application management -> Content databases. Set all other databases Online.
Comments Posted (0)
Post a Comment