March 14, 2009 at 5:51 am
master .mdf as well as .ldf gets deleted and all the services are also shut down. How to recover the database?Can anybody help?
March 14, 2009 at 7:51 am
Do you have backups?
Sounds like you will need to reinstall SQL Server.
Do you have any auditing on the server? The only way to delete database files in SQL Server is if you shut down the services first.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 14, 2009 at 11:22 am
exam question? google 'rebuild 2005'
---------------------------------------------------------------------
March 14, 2009 at 5:37 pm
Read through http://www.sqlservercentral.com/Forums/Topic675622-146-2.aspx ... there is alot in there on how to get Server back up after system dbs are lost.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply