I forgot to detach SUSDB.mdf and SUSDB_log.ldf from... fuck, i don't even know exactly... from the sql process? or something. Anyway, forgot to detach them before trying to move them. Realised my error during the move and promptly locked up explorer somehow. Now the database is apparently corrupted and wsus is really screwed up.
Is it worth my while to continue explaining the problem? Does anyone here have any WSUS or SQL expertise?
I tried the partially scorched earth option, but I can't even uninstall WSUS (to reinstall and start from scratch).
-The console snap-in shows no "servers administered from this console" and I can't connect to the server.
-when I enter osql -E -S sbssvr\MICROSOFT##SSEE -Q "exec sp_attach_db etc. etc. I get error in database, try dbcc checkdb
-when I try to dbcc checkdb (SUSDB) I get that there's no SUSDB.
I'm frightened.
Is it worth my while to continue explaining the problem? Does anyone here have any WSUS or SQL expertise?
I tried the partially scorched earth option, but I can't even uninstall WSUS (to reinstall and start from scratch).
-The console snap-in shows no "servers administered from this console" and I can't connect to the server.
-when I enter osql -E -S sbssvr\MICROSOFT##SSEE -Q "exec sp_attach_db etc. etc. I get error in database, try dbcc checkdb
-when I try to dbcc checkdb (SUSDB) I get that there's no SUSDB.
I'm frightened.