Learn how to a build a cloud-first strategyRegister Now

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

Restore SBSMONITORING

I had to do a manual erase of SQL Server 2000 from ACT in windows 2003 SBS R2 Premium(was upgraded from previous version of 2003 sbs in january).  We no longer use ACT.  What happened is when I uninstalled SQL Server 2000 did not uninstall 100% so I had to use a Microsoft KB article to go through and wipe out keys in the registry to get rid of the instances.  What happened and they said it would is that it would wipe out any MSDE instances as well.  It wiped out my Sharepoint and my SBSmonitoring instances.  They are still listed in Services but they cannot start.  All the data is still listed in the C:\Program Files\MS Sql Server\MSSQL$SBSMONITORING.  Is there anyway to restore this database?
0
nxpsupport
Asked:
nxpsupport
  • 5
  • 3
1 Solution
 
aces4allCommented:
For Sharepoint and SBS Monitoring

Reinstall MSDE and attach the databases in the C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Data folder if they stilll exist.  To attach the database after reinstalling MSDE:

1.  Go to the command-line (Start>Run>CMD)
2.  Execute the following from the command-line

         Osql -E -S ServerName\SBSMonitoring -Q "sp_attach_db 'SBSMonitoring', 'C:\Program Files\Microsoft SQL Server\MSSQL$SBSMonitoring\Data\SBSMonitoring.mdf', 'C:\Program Files\Microsoft SQL Server\MSSQL$SBSMonitoring\Data\SBSMonitoring_Log.ldf'"
         Osql -E -S ServerName\SharePoint -Q "sp_attach_db 'STS_Config', 'C:\Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data\STS_Config.mdf', 'C:\Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data\STS_Config_Log.ldf'"
         Osql -E -S ServerName\SharePoint -Q "sp_attach_db 'STS_ServerName_1', 'C:\Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data\STS_ServerName_1.mdf', 'C:\Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data\STS_ServerName_1_Log.ldf'"

4.  Exit the command-line and restart the IIS Admin and MSSQL$SBSMONITORING services

Also, download and review http://download.microsoft.com/download/1/1/6/11671e4d-fb21-489c-870f-db36fd21a7d2/SBS_MoveDataFolders.DOC for information on moving SBS data.


0
 
nxpsupportAuthor Commented:
MSDE is installed because I have WSUS running on it.  I also have SQL Server 2005.  Is there anyway to integrate it into that easier or should I keep the MSDE?

When I type the first line you said I get the following:

C:\Documents and Settings\Administrator>Osql -E -S ServerName\SBSMonitoring -Q "
sp_attach_db 'SBSMonitoring', 'C:\Program Files\Microsoft SQL Server\MSSQL$SBSMo
nitoring\Data\SBSMonitoring.mdf', 'C:\Program Files\Microsoft SQL Server\MSSQL$S
BSMonitoring\Data\SBSMonitoring_Log.ldf'"

[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
0
 
nxpsupportAuthor Commented:
hold on let me look I just noticed the generic servername login I'm an idiot
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.

 
nxpsupportAuthor Commented:
same error when I put the correct server name in and I still get the same error there is no server\sbsmonitoring instance is this supposed to create it?
0
 
nxpsupportAuthor Commented:
In Services the service just hangs on starting, it never fails or anything just always says starting.

MSSQL$SBSMONITORING --- starting
0
 
aces4allCommented:
Each service (MSSQL$SBSMONITORING and MSSQL$SHAREPOINT ) are named instances of SQL/MSDE.  For SharePoint you may need to stope the Microsoft SharePoint Administration, SharePoint Administration and Companyweb websites from the IIS MMC before starting the MSSQL$SHAREPOINT service.  For SBS Monitoring you may need to stop the Performance Logs and Alerts service before starting MSSQL$SBSMONITORING.  Just be sure to restart these websites and service after starting MSSQL$SBSMONITORING and MSSQL$SHAREPOINT
0
 
nxpsupportAuthor Commented:
I still cannot get them to start.  The processes you mentioned are stopped and I still cannot start those MSDE Instances.
0
 
aces4allCommented:
Are any errors showing up in the event or SQL logs?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now