Solved

SBS 2003 Sharepoint 2.0 restore old site to New Server

Posted on 2009-04-13
11
735 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 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

25 Experts available now in Live!

Get 1:1 Help Now