Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can´t start SQL Server instante (master database corrupetd) - No backups... Expand / Collapse
Author
Message
Posted Tuesday, February 15, 2011 2:03 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 15, 2016 5:58 AM
Points: 908, Visits: 1,290
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
Post #1064084
Posted Tuesday, February 15, 2011 2:20 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 44,914, Visits: 42,954
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, MVP, M.Sc (Comp Sci)
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

Post #1064099
Posted Tuesday, February 15, 2011 2:23 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, July 15, 2016 5:58 AM
Points: 908, Visits: 1,290
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...
Post #1064100
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse