Solved

SBS 2003 Sharepoint 2.0 restore old site to New Server

Posted on 2009-04-13
11
740 Views
Last Modified: 2012-05-06
I had an SBS 2003 R2 Server crash . I set up a new server with a new name. I was able to slave the drive and retrieve the mdf files server2005 and the config files  (old server) and copy them to a new sub directory in the new server (server2009) . I followed the instructions per Microsofts document "Moving Data Folders for Windows Small Business Server 2003" see attached. I substituted the OLD server names when doing the attach. It appeared to go ok at the command prompt. Now when I go to Companyweb I get an "unable to connect to database"
Old server is SERVER2005 . New server is SERVER2009. Am I able to do this without exactly duplicating the old servers credentials ?
To attach the databases to the SharePoint instance of WMSDE
You must attach the databases you moved to the destination partition back to the SharePoint instance of WMSDE.
1.	Click Start, click Run, and then type Cmd.
2.	Type the following command, considering the following bullet points, and then press ENTER.
"	The -E, -S, and -Q command line parameters must be typed as capital letters as they are case sensitive.
"	ServerName is the name of the computer running Windows Small Business Server 2003
"	D is the drive letter for the new location of the database.
Osql -E -S ServerName\SharePoint -Q sp_attach_db 'STS_Config', 'D:\MSDEDatabases\SharePoint\STS_Config.mdf', 'D:\MSDEDatabases\SharePoint\STS_Config_Log.ldf'
3.	Repeat the command from Step 2 for the STS_ServerName_1 database, where ServerName is the name of the computer running Windows Small Business Server 2003.
Osql -E -S ServerName\SharePoint -Q sp_attach_db 'STS_ServerName_1', 'D:\MSDEDatabases\SharePoint\STS_ServerName_1.mdf', 'D:\MSDEDatabases\SharePoint\STS_ServerName_1_Log.ldf'

Open in new window

SBS-MoveDataFolders.DOC
0
Comment
Question by:gmathesonjr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 39

Expert Comment

by:Philip Elder
ID: 24134661
Check the permissions on the folder and files in the directory itself. They may surprise you and show Read Only.

Open the database with SQL Management Studio Express and verify that the correct permissions are set within the database. The old server will have had a user/group setup that is different than the new server.

IIRC, a connection issue is primarily due to permissions when it comes to moving databases.

Check the logs as well.

Philip
0
 

Author Comment

by:gmathesonjr
ID: 24139614
"The virtual server that is referenced here is not in the config database." is the error I am getting . I DL'ed the SQL Management Studio and I can SEE the the DB . I have
System Databases
STS_Config
STS_Infoserver_3 (name of new Server ie SERVER2009)
STS_SERVER2005_1

The files have Read Write priveledges.

Thank you in advance for your help.

Gordon
0
 
LVL 39

Expert Comment

by:Philip Elder
ID: 24141651
Gordon,

Try running the SQL Surface Area manager and reset the admin account on the databases. This may allow you to connect via the SQL Manager.

Philip
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

Author Comment

by:gmathesonjr
ID: 24142729
I am unfamiliar with the Surface Area manager . The SQL tool you suggested allowed me to see the SERVER2005 database in the object explorer. My experience with DB's stopped back with Visual Foxpro 7.0 .
Using MS SQL Server Management Studio Express....
I have in Object explorer INFOSERVER\SHAREPOINT (SQL Server 8.0.2055
Databases
     System Databases
     STS_Config
     STS_infoserver_3
     STS_SERVER2005_1
Security
Server Objects
Replication
Management

I want to use SERVER2005 as the DB . company web continues to give the error "The virtual server that is referenced here is not in the config database."

Thanks
Gordon

0
 
LVL 39

Accepted Solution

by:
Philip Elder earned 500 total points
ID: 24143178
This should do it:
http://support.microsoft.com/kb/829113

Philip
0
 

Author Comment

by:gmathesonjr
ID: 24170708
I am sorry for the delay . I tried the first part of the KB from Microsoft and apparently removed some of the Sharepoint config files as per the directions and got configuration files missing error. I put them back and now I am still at the "The virtual server that is referenced here is not in the config database.
Thank you
Gordon
0
 
LVL 39

Expert Comment

by:Philip Elder
ID: 24170766
Did you do the remove and extend (steps 11 and 12)?

Philip
0
 

Author Comment

by:gmathesonjr
ID: 24177217
I did the remove and extend and am now getting  "Unable to connect to database. Check database connection information and make sure the database server is running. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com."

Does the Database have to be the name of the server ? The old Server and Database were named SERVER2005. This new server has a different name.
0
 

Author Comment

by:gmathesonjr
ID: 24286886
I did all of the above steps and tried different ways to retrieve the data from my Old Servers MDF. THe steps above were helpful but I was never able to replace the content database. The real reason for doing this was to access the old CALENDAR that were in the old Sharepoint Data file. Using SQL 2005 Express I was able to see the data file. I had trouble browsing the actual Data file.  Using a utility called SharePoint Database Explorer  Copyright 2004, James Edelen I was able to browse the actual data file and I didnt see any calendar information. I would like to credit Philip with the assistance he has provided . Although I havent actually restored the old Sharepoint Content Database , I believe he helped me with the original question. I will open up a new question now that I know a little bit more about what i Truly am trying to accomplish here. Any suggestions in the wording of the new question would be greatly appreciated.

Thank you
Gordon
0
 

Author Closing Comment

by:gmathesonjr
ID: 31569502
Thank you Philip . Please see my final comment.
0
 
LVL 39

Expert Comment

by:Philip Elder
ID: 24286912
Thanks for that!

Philip
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question