|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
|
|
Hi,
I Can´t start SQL Server instante (master database corrupetd) - No backups...
Is there any thing that can be done to recover the instance and the databases?
Thank you
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722,
Visits: 29,977
|
|
There's a utility to rebuild the master database. You will lose all logins, all server-level roles and permissions, all linked servers, you'll have to reattach all user databases.
Google for rebuild master SQL 2000.
Why no backup?
Gail Shaw Microsoft Certified Master: SQL Server 2008, MVP SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter We stand on the bridge and no one may pass
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679,
Visits: 953
|
|
thank you very much for the tip.
Why no backups? because it is Angola....
In Angola we do not have database administrators and SQL Server backups (maintenance plans) where not working.... someone did something to the backups...
|
|
|
|