Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 860
  • Last Modified:

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.
0
sentinelsystems
Asked:
sentinelsystems
  • 8
  • 4
  • 2
2 Solutions
 
mvsnaniouCommented:
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.

Or

Check this below link
SharePoint Site Backup and Restore
http://rehmangul.sauftveyr.com/2009/04/18/sharepoint-site-backup-and-restore/

Let me know
0
 
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?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
aoakeleyCommented:
0
 
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?
0
 
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.
0
 
aoakeleyCommented:
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

REVIEW: http://support.microsoft.com/kb/944267

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

0
 
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?

0
 
sentinelsystemsAuthor Commented:
I have worked through this: http://geekswithblogs.net/WorldofTray/archive/2010/02/23/how-to-connect-to-a-restored-content-database-in-sharepoint.aspx but it fails to bring up the website with any content. I just get error 404 file not found.
0
 
aoakeleyCommented:
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?
0
 
sentinelsystemsAuthor Commented:
None that i am aware of, so none have been installed on the new WSS.
0
 
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'.

0
 
aoakeleyCommented:
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 http://technet.microsoft.com/en-us/library/cc263422%28office.12%29.aspx 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
0
 
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.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 8
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now