December 1, 2011 at 6:41 am
Dear All,
we deleted the .Ldf and .Mdf Files For one database. It's is having large data. We need the database back. is there any possibility to restore the database.
Thanks In Advance....
December 1, 2011 at 6:43 am
Only if you have a backup.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 1, 2011 at 6:50 am
Adi Cohn-120898 (12/1/2011)
Only if you have a backup.Adi
Backup includes SQL Server Backup as well as OS backups. Please check with your IT team if they have any OS backups of your Database Server. In any case you will lose all transactions after last backup.
December 1, 2011 at 6:56 am
Sure we will Ask the IT people, if they said yes, Can I restore the OS BackUp ..?
December 1, 2011 at 6:58 am
Only 1 way to know... assuming you never tested the scenario.
December 1, 2011 at 7:01 am
You can only use the OS restores of the mdf and ldf files IF SQL was offline during the OS backups or if the database was detached from SQL.(or a 3rd party agent is used like TSM) Otherwise you will have to have the SQL backup in order to restore the database.
December 1, 2011 at 7:08 am
I've seen successful restores even if the dbs were live. that being said it's not the norm, hence you need to test.
December 1, 2011 at 7:51 am
Just a side note, if you don't have backups of this database, are you running backups of your other databases? If not, in addition to worrying about getting this one back online, I'd jump on the task of setting up a good backup routine. It's a fundamental part of your job as a DBA (even if DBA is only part of your responsibilities).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply