- Create a new Web application on the destination server.
- Go to central admin --> content database . Click on the new web app content db.
- Remove the content db.
- Go to SQL server mgmt studio and create a new db with the same name as the content db backup you are having.
- After creation right click restore. Choose the backup file location. From the options tab choose 'overwrite'.
- Restore this db backup.
- Go to central admin --> content database again and select ' add a content db ' to the web application.
- specify the name of the restored db.
- Done
Saturday, May 31, 2008
How to restore site using content db only
To restore a site on the same or different machine using the content db backup follow the steps given below:
Subscribe to:
Post Comments (Atom)
3 comments:
I'm having deployment issuse trying to refresh a dev site from production and needed to do it without Deploying
This sounds like exactly what I am looking for. Thanks! One question though; in your description you mention creating the restored content db with the same name as the backup... Does that mean it has to have the same name as the original on the production site? Both sites are on the same SQL server so that can't happen.
Thanks for this. It was pretty straight forward. Though I had to do some extra steps when restoring the backup to a new server in a new domain. In central admin > site collection administrators, set a user (local or domain) as the Primary or Secondary Site collection administrator. This allowed me access to the site and content.
This was only for the purpose of restoring and gaining access to the content.
Thanks T-Mak (Yeung Ming),
you are correct. we need to set user.
Thanks,
Sharepoint Kings Team
Post a Comment