I'm doing some disaster recovery testing currently and have restored my production system databases (Master, Model and MSDB) to a new server from a clean build of SQL Server 2000.
The problem now is that all the user databases are marked as 'suspect'. This isn't surprising as there are no data or log files on the new server, just their references in Master. I want to restore the user databases from backups but I can't restore a suspect database. So is there any way around this other than dropping the suspect databases. I guess this will lose the permissions that my logins have on each database, the main reason for wanting to restore the Master database in the first place.
So, is there a way around this?