To restore a site on the same or different machine using the content db backup follow the steps given below:
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
2 comments:
Hi Nilesh,
This procedure will actually restore ALL sites in a content db, not only the site you need. Also, it would not bring the site back to its original location so users would have to update their links, etc.
What I typically see customers are using is:
1. a procedure similar to what you described to retrieve the content db from backup and attach it to a test SharePoint environment, followed by
2. STSADM export and import or SharePoint Designer site backup and restore to bring the deleted site back to its original location
Also, there are some 3rd party tools that can help with this task. The product I am involved with is Quest Recovery Manager for SharePoint. It allows exactly what your post is about: granular restore of any SharePoint data (from single document/item up to entire site collection) from content database backup. The product works with various backup formats such as SQL native, TSM, LiteSpeed, NetBackup, etc. so you don't have to change your backup tools to achieve granular SharePoint recovery.
Thanks,
Ilia
Hi Ilia,
For updating links, I am agree with you,Thanks for your additional information. This would definitely help everyone.
Thanks,
Nilesh
Post a Comment