Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How Can I restore the site from Content Database?

  Asked By: Colin    Date: Jan 17    Category: Sharepoint    Views: 5610

Is this Possible to restore the site from Content Database. If Yes, how
Can I do that? Could Please someone tell me step by step?



7 Answers Found

Answer #1    Answered By: Adrienne Greene     Answered On: Jan 17

There's no way to do this besides restoring the Content Database to
another SharePoint farm and using STSADM -o backup to back up the Site
Collection you are looking for.

Answer #2    Answered By: Joshuah Huber     Answered On: Jan 17

Step/step instructions are available @ Technet:


Backup/Resrote site  using DPM : -->

Answer #3    Answered By: Ciara Collier     Answered On: Jan 17

I think this is not totally accurate.

The issue is whether you want to replace everything that was in the
content database  with the version in the backup, or whether you want
to selectively restore  some parts of the content  data.

Selective restore requires your method.

But if the entire content database need to be rolled back, just
detach the old content database and attach the backup version.

Your instructions are also for the situation where you are trying to
create a second copy of some site. The reason you can't just attach a
second copy of some content database to a SharePoint site  is because
the sites in the duplicate content database would have the same GUID
as the original sites. That's the reason to restore it to another
farm and use STSADM to copy it back to the original site. STSADM -o
restore creates a new GUID.

Answer #4    Answered By: Andy Yu     Answered On: May 01

Ciara Collier,

I believe I need to do what you have wrote previously:

"Selective restore requires your method."

My Situation: I have a SharePoint site collection (hosted via WSS 3.0) that needs to be deleted and created for changes we made to it via its site definitions file (*.wsp) to take effect. However, all site users and their group assignments and possibly all lists items, etc are wiped out.

My Question: How do I back up my Sharepoint site collection users and groups as well as all existing lists before I delete and recreate the site collection in WSS 3.0 and at the end restore all backed-up site collection users and group and all lists into the new site collection?


Didn't find what you were looking for? Find more on How Can I restore the site from Content Database? Or get search suggestion and latest updates.