May 14, 2008 at 4:44 am
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?
May 19, 2008 at 3:25 pm
You should not lose any information on security, such as logins and users, if you have right backups.
May 19, 2008 at 3:36 pm
you can restore a database that is marked suspect.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply