Restore sharepoint

Hi, here is the scenario: My clients server was stolen. SBS 2003 Std. We were running sharepoint on it and i now need to restore the site to my new server installed. The new server is SBS 2011. What is the process to do this? I have a backup of the stolen server using NTBackup and need to know what to restore. I have a "restore" server installed as i am trying to recoved the exchange if this is required for the sharepoint also.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Use following steps
Restore the backup of your PROF, SITES and SERV databases to your SQL server, creating a new name for them in the process. *Note: Do not restore the configuration database.
 1.Install SharePoint 2003 on your test server.
 2.On the "Specify Configuration Database Settings" page, choose Create Configuration Database.
 3.Enter your SQL Server name and instance.
 4.Create a unique Configuration database name, and click OK.
 5.Complete the SharePoint 2003 installation.
 6.Install any SharePoint service packs or security updates that were in place in the initial environment. This is very important. If you do not have the new environment on the same patch level as the old, you may run into problems getting SharePoint to attach to the database.
 7.Re-associate the restored SQL database with your new SharePoint test environment: 8a. In Central Administration, click on SharePoint Portal Server. 8b. In the Portal Site and Virtual Server Configuration section, go to List and manage Portal Sites. 8c. Click on Restore Portal Site 8d. Choose the "Restore a Portal" radio button. 8e. Enter the SQL server and instance name, and then the name of the restored databases.
 8.Click Ok, and OK again to confirm the Portal Site creation.
 9.Hopefully at this point you get an "Operation Successful" message.
 10.Reboot the server, and verify that your sites are being served.


Check this below link
SharePoint Site Backup and Restore

Let me know
sentinelsystemsAuthor Commented:
Hi, I do not have a sql backup of the database. How else can we do this. Where is the db located by default?
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Andrew OakeleyConsultantCommented:
sentinelsystemsAuthor Commented:
I have managed to get the db attached on sql and have added a new site in WSS but when i try and associate the site i get the following error msg: The specified SPContentdatabase Name=WSS_Content_ Parent=SPDatabaseSericeInstance has been upgraded to a newer version of Sharepoint. Please upgrade this sharepoint application server before attempting to access this object.

how can i check what is missing on the new server install?
sentinelsystemsAuthor Commented:
I also get this is event viewer, any idea what i can do to correct the problem?
Databaswe WSS_Content on SQL Server instance "instancename" is not empty and does not match the current database schema.
Andrew OakeleyConsultantCommented:
Just to be clear you are restoring this into a new WSS3 instance aren't you? or are you trying to directly restore into sbs2011 sharpoint.

Assuming that you are restoring into your recovery WSS3 environment run this


In particular try this resolution

    Click Start, click Run, type cmd, and then click OK.
    Locate the "Program Files\Common Files\Microsoft Shared\Web server extensions\12\BIN" folder.
    At the command prompt, type the following commands, and then press ENTER after each command:
    stsadm -o provisionservice -action stop -servicetype spwebservice -servicename ""
    stsadm -o provisionservice -action start -servicetype spwebservice -servicename ""
    After the SPWebService service is started, type the following command at the command prompt, and then press ENTER:
    psconfig -cmd upgrade -inplace b2b -wait -force


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sentinelsystemsAuthor Commented:
I am restoring first to WSS3.
I have worked through the above and have managed to get he database added under content databse now but am unable to see any of the data when i open the website? How do i get all documents, links etc available again?

sentinelsystemsAuthor Commented:
I have worked through this: but it fails to bring up the website with any content. I just get error 404 file not found.
Andrew OakeleyConsultantCommented:
Did you have any additional features/plugins/etc installed on the old server such as "windows Search Server express" etc. If you did have you re-installed all these in your new WSS farm?
sentinelsystemsAuthor Commented:
None that i am aware of, so none have been installed on the new WSS.
sentinelsystemsAuthor Commented:
The following error is seen in event viewer:

SQL Database 'WSS_Content' on SQL Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found. Additional error information from SQL Server is included below.

Cannot open database "WSS_Content" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Andrew OakeleyConsultantCommented:
Amazing what you find in the event viewer. Equally amazing how many people never look...

If you remove and re-add the content database you can specify what credentials to use to connect to it. If you do this through the web interface (Central Admin - Application Management - Content Databases) thre is an option for credentials when you add the database.

If you use the commandline for the syntax to add credentials.

As this is jut a restore environment, use the administrator credentials or other credentials will full rights to the SQL Server.

Alternatively you could try giving Network Service rights in the database using SQL management studio
sentinelsystemsAuthor Commented:
Ok, an update on this, i have been unable to get the database up so have resorted to purchasing software. This has partially worked but will still continue to attempt to get the db loaded. Will upload details if i get it right.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.