RE: Restore a WSS 3.0 site from a raw SQL backup

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

David Goebel,

You can restore your sites from raw SQL back-up. The raw SQL restore way
restores all the site-collections, sites and subsites within the content
database (SQL Database).


After looking at list of databases you had provided, here's my reply below

WSS_Config = is the global configuration database. It's one per farm. You
don't need to bother about this as long as your farm is not broken

WSS_Search_Server1 & WSS_Search_Server2 = are Search Databases.
WSS_Site1_Content = content database for site 1
WSS_Site3_Content = content database for site 3

Since you are saying 'site1' i'd recommend you to restore WSS_Site1_Content
and attach it to the farm.
Please refer the following url that talks about how to restore sites from
raw SQL DB.
http://dotnetbuzz.spaces.live.com/Blog/cns!F3599E60D988EEB0!279.entry

Please let me know whether this helps !


--
----
Thanks,
Sundar Narasiman,
Blog: http://dotnetbuzz.spaces.live.com/
My Request: Please rate posts in Microsoft Newsgroups and Forums genuinely.
This would encourage helpful volunteers.



"David Goebel" wrote:

I need to restore one of my WSS sites, however I only have raw SQL backups as
SharePoint’s built-in backup routine was not running at the time. I have
looked at Microsoft’s documentation on restoring from a SQL backup, but it
does not provide any specific answers in regards to how to restore a single
WSS site. It also does not say which databases you should restore. In
fact, I can't find anything at all regarding how to restore from SQL only.

Here are the databases as they appear in SQL and what I need is "Site1".

SharePoint_AdminContent_xxxxx-xxxxxx-….
WSS_Search_Server1
WSS_Search_Server2
WSS_Site1_Content
WSS_Site1_Content
WSS_Site3_Content
WSS3_Config

So do I only need to restore “WSS_Site1_Content” from within SQL Server and
everything will work just fine? Or is this going to be a nightmare?
.

Relevant Pages

  • Re: Migration ?
    ... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)
  • Re: Restore leaves DB in Loading state
    ... state of loading after the database restore - rather than in read only. ... > leave SQL restore hanging until it could write to that file. ... > I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Problem causing me to have to restore tlogs WITH MOVE
    ... I have a database i am m oving to another server, ... am moving the data and log files to another drive.(Which I have done ... The problem I am having is after I restore the database using the ... TO ?D:\Program Files\Microsoft SQL ...
    (comp.databases.ms-sqlserver)
  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... >want to run sp_updatestats after the restore or attach ... >> SQL Server Databases ... >> Database Copy Wizard in SQL ... >> diagram in the new ...
    (microsoft.public.sqlserver.setup)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)