We help IT Professionals succeed at work.

WSS 3.0 Restore

DJMohr
DJMohr asked
on
Medium Priority
870 Views
Last Modified: 2012-08-16
Had a problem over the weekend that IIS/WSS 3.0 crashed and was unable to get it up and running again.
I made a backup on the WSS 3.0 databases and uninstalled it. Reinstalled and everything is fine except now I need to try retrieve my old site collect.
Is this possible from the DB backups I made?
Comment
Watch Question

SharePoint SME
CERTIFIED EXPERT
Commented:
try this

Assuming you have a backup..

Best way will be doing it like this.

Install WSS same version as before.

Attached your old content database.

Createa new Web App. Same url as before.

Remove the database from this Web App.

Add the old database.

reset iis.

All Site collection should appears.
Justin SmithSr. System Engineer
Top Expert 2012
Commented:
No, it's not possible to pull individual sites out of a content database backup.  As the user above was trying to tell you, you must first restore the database to SQL.  Then create your web application in SharePoint.  When you create this web app, use a dummy name for the database (ex. add _DELETE to the end of the name).  Once the web app is created, go in Central Admin - App Management - Content Databases.  Choose to remove the dummy database from the web app.  Now add a content database, and specify the name of the restored database.  This will attach your restored database to the web app, and if all is good, your sites will be available.

Author

Commented:
Ok, so I need to recreate my site more or less like it was then do what you said from there?
Justin SmithSr. System Engineer
Top Expert 2012

Commented:
You need to create the web application only.

Author

Commented:
Ok, sounds easy enough.
Uttam (Kukdai) DhakalSharePoint SME
CERTIFIED EXPERT
Commented:
attach your old content database here means attach it to your sql server( or restore from the present backup) which is attached to your current web farm.

Obviously it won't work if your backup Content Db is stored in desktop it has to be attached to SQL Server DB..which can be accessed with in your network....

Author

Commented:
I have done as stated above, have restored the old DB to SQL and try to add the content DB and get this:

The specified SPContentDatabase Name=WSS_Content_old Parent=SPDatabaseServiceInstance Name=Microsoft##SSEE has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object.

SP3 wit WSS 3.0 has been installed and no other version of Sharepoint has ever been run on this server.

Author

Commented:
now i get this:

Attaching this database requires upgrade, which could time out the browser session.  You must use the STSADM command 'addcontentdb' to attach this database

Author

Commented:
Thanks, got it working

Explore More ContentExplore courses, solutions, and other research materials related to this topic.