Solved

SBS 2003 Sharepoint 2.0 restore old site to New Server

Posted on 2009-04-13
11
733 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
  • 6
  • 5
11 Comments
 
LVL 38

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 38

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
 

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 38

Accepted Solution

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

Philip
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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 38

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 38

Expert Comment

by:Philip Elder
ID: 24286912
Thanks for that!

Philip
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now