Restore Question

[OregonSteve]

Greetings-

Here's the 4-1-1:

SharePoint server with default web site using SQL Server 2000. There are 10 subsites.

Backed up subsite #1 using Smigrate on Friday. User accessed server and modified document on Tuesday. Deleted subsite #1, document libraries and all on Thursday. Nightly SQL Server backups in place.

I need to restore this site and documents to export this one document. However, using the restore function with SMIGRATE requires me to create a blank web site to restore to. I can do that and then restore the web site from the backup I did on Friday. But then would I be able to access this document from the SQL Server restore seeing as how it's a new web site? I know: messy!





Thanx
OregonSteve

"..You should never, never doubt what nobody is sure about." -Willy Wonka

 

[Thomas2000]

Hello,

If I am not totally wrong, when you want to restore a site and you create a blank site you should not create a toplevel website, you should extend the virtual server and then you can restore the site to that new location. If you extend and create a toplevel website I think that you will receive an error trying to restore the site.

I have done similar things like this, and what I did was to create a new virtual server, new content database. I extended the virtual server and created a blank toplevel site which I then removed (since I could not restore the site to an existing toplevel site). Then I used the smigrate or stsadm to restore my site to the new location.

Regards,
Thomas

 

[OregonSteve]

Greetings-

I discovered (since I'm new at this, everything is a discovery) that ALL the data (sites, site content) is contained in the SQL server backup. So I just did a restore and it brought back EVERYTHING. Very nice!

Thanx
OregonSteve

"..You should never, never doubt what nobody is sure about." -Willy Wonka

 

[ThomasLiss]

All you need for completely restoring a portal with all the content (any subsites etc) is the three databases _PROF, _SITE and _SERV. You can restore a portal after reinstalling SPS (happened to me) by choosing "restore a portal site" and manually giving the names of these databases. Before that, you have to create a virtual server, but it can be any name. So, as long as you have any kind of backup of these three databases, you are fine.

Best,

Thomas Liss