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

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

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:22 AM
Points: 742, Visits: 1,053
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 @ 1:14 AM
Points: 42,412, Visits: 35,479
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

Post #1064099
Posted Tuesday, February 15, 2011 2:23 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:22 AM
Points: 742, Visits: 1,053
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