Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Restore wss site from portal backup

  Asked By: Abhishek    Date: Feb 03    Category: Sharepoint    Views: 934

We just did mistake of deleting a site
But we have previous day portal back up ,the one taken from Sharepoint Restore
and Backup page
Is there any way we can restore a single site from that portal backup.



3 Answers Found

Answer #1    Answered By: Makayla Lewis     Answered On: Feb 03

Restore your portal  backup to a separate server or virtual server and
then use stsadm to backup/restore the individual site.

Or try and pull out the sites database from your backup  and attach it to
a separate virtual server and then use stsadm from there.

Answer #2    Answered By: Miranda Scott     Answered On: Feb 03

The first option is not possibe .
Can you elaborate the second option more
Still clueless on this .

Answer #3    Answered By: Deirdre Macias     Answered On: Feb 03

An spsbackup effectively just calls SQL client tools to backup  each of
the individual databases. In your backup folder you will see a file for
the _Sites, _Prof & _SERV dbs. These are just SQL backups of the
original databases and can be restored to any SQL server.

So I'm suggesting that you could take the _Sites backup and restore  it
to a SQL instance somewhere. Once this is done you would then have a
couple of options. First there are some community tools out there that
allow you to navigate databases without even attaching them to a WSS/SPS
The second option is to attach the database to an IIS virtual server
that has been extended with WSS. However this would HAVE to be on a
separate physical server (standalone or different farm) to the one where
the backup was taken. The reason here is that if you import a content
database that has the same entries in the Sites table as an existing
database that is already attached then the existing sites will be
repointed at the newly attached database. This happens due to the fact
that there is a master Sites table held in the configuration database
that lets SharePoint know which content database to go to to get the
site content. Once the database is connected to a WSS instance then you
can use stsadm to backup the desired site  and then restore it into your
operational portal  site.

Hopefully the above explains enough for you to move forwards. Note the
above is all theory on my part since I have never actually tried

Didn't find what you were looking for? Find more on Restore wss site from portal backup Or get search suggestion and latest updates.