Hey,

 

My SBS Reporting wasn't working, and so I found this post:

[url]http://forums.techarena.in/showthread.php?t=733930[/url]

 

I followed the instructions up to uninstalling Monitoring (Step 11) and then reinstalling it, but the reinstall failed on, initially, both Monitoring and MSDE SP4 and, on a retry, only MSDE SP4. 

 

I downloaded and installed SQL Server 200 SP4, SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, and ran it with the command:

 And it seemed to complete (I have the log file), but I now have the symptoms:

- Monitoring still doesn't work - it is unconfigured, but an attempt to start the monitoring wizard produces:

Which I'm not keen to do. 

- My Kaspersky Administration Server has also stopped working

- WSUS 3.0 SP1 Admin console stopped working

 

And here I'm stuck.

 

I obviously need to figure out what instances of SQL I have running and where, and what versions, and I need to learn how to back up the databased and upgrade to the correct version of SQL, but I really don't know where to start.  Can someone help please!

I have a script which backs up all the databases in a SQL Server instance. Run this script on each of your instances

declare @IDENT INT, @sql varchar(1000), @DBNAME VARCHAR(200)

select @IDENT=min(DBID) from SYSDATABASES WHERE [DBID] > 0 AND NAME NOT IN ('PUBS', 'NORTHWIND', 'TEMPDB')
while @IDENT is not null
begin
SELECT @DBNAME = NAME FROM SYSDATABASES WHERE DBID = @IDENT
/*Change disk location here as required*/
SELECT @SQL = 'BACKUP DATABASE '+@DBNAME+' TO DISK = ''C:\DBBackup\'+@DBNAME+'.BAK'' WITH INIT'
PRINT "==========================================="
EXEC (@SQL)
PRINT "Backup for database " + @DBNAME + " has been created"
select @IDENT=min(DBID) from SYSDATABASES WHERE [DBID] > 0 and DBID>@IDENT AND NAME NOT IN ('PUBS', 'NORTHWIND', 'TEMPDB')
end

To find out the version of your SQL Server instance, you can run this query

SELECT @@VERSION

 

Check out this KB article for more details