April 3, 2010 at 3:05 am
Hi
I want to know if .mdf file gets deleted wrongly, can we recreate .mdf file, whereas .ldf file is available on the disk.
If it is possible suggest me how to do.
April 3, 2010 at 10:31 am
If you have a backup - you can restore to get the mdf file. If you don't have a backup (why not?) - then you no longer have a database.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 3, 2010 at 2:16 pm
beejug1983 (4/3/2010)
HiI want to know if .mdf file gets deleted wrongly, can we recreate .mdf file, whereas .ldf file is available on the disk.
If it is possible suggest me how to do.
As Jeffrey stated if you loose the MDF file a FULL database restore is the only possible way to "recreate" it. You can recreate the LDF files, but restoring backups is the best and safest method.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 3, 2010 at 2:23 pm
But I have to take the tail log backup, so how it is possible ?
April 3, 2010 at 4:15 pm
If you lose the MDF, not sure you can take a tail log backup.
The MDF is the data, the LDF is the log records SINCE the last checkpoint. It's not all log records.
Did someone delete one of your MDFs? Have you tried a deleted file recovery utility?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply