SQL 2000 w/ SP4
Need help with recovering a corrupt msdb database in SQL 2000. We had a hard disk failure and now I've been trying to recover the msdb database. The good news is that we have backups of the database however when I start sql server using the -C -T3608 flags, I'm not able to move the msdb data and log files AND in single user mode, I'm not able to access Query Analyzer as 'sa'...says only one connection at a time which makes sense but I'm the only one connecting!!! Can someone please assist with procedures for recovering?
Thanks.
Need help with recovering a corrupt msdb database in SQL 2000. We had a hard disk failure and now I've been trying to recover the msdb database. The good news is that we have backups of the database however when I start sql server using the -C -T3608 flags, I'm not able to move the msdb data and log files AND in single user mode, I'm not able to access Query Analyzer as 'sa'...says only one connection at a time which makes sense but I'm the only one connecting!!! Can someone please assist with procedures for recovering?
Thanks.
