asked on

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?

ASKER CERTIFIED SOLUTION

aces4all

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nxpsupport

ASKER

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()).

nxpsupport

ASKER

hold on let me look I just noticed the generic servername login I'm an idiot

nxpsupport

ASKER

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?

nxpsupport

ASKER

In Services the service just hangs on starting, it never fails or anything just always says starting.

MSSQL$SBSMONITORING --- starting

aces4all

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

nxpsupport

ASKER

I still cannot get them to start. The processes you mentioned are stopped and I still cannot start those MSDE Instances.

aces4all

Are any errors showing up in the event or SQL logs?