Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restoring system databases Expand / Collapse
Author
Message
Posted Wednesday, May 14, 2008 4:43 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 6:47 AM
Points: 426, Visits: 217
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?
Post #500300
Posted Monday, May 19, 2008 3:25 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
You should not lose any information on security, such as logins and users, if you have right backups.
Post #503186
Posted Monday, May 19, 2008 3:36 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:37 AM
Points: 5,879, Visits: 13,009
you can restore a database that is marked suspect.

---------------------------------------------------------------------

Post #503193
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse