April 24, 2011 at 12:35 pm
Hello
If there is a hard disk failure before the differential backup occured, is there any point in using the differential backup file to recover database ? Because the .mdf file from the diff backup would not have any transactions after the hard disk failure... would it ?
April 24, 2011 at 12:52 pm
I think you are confusing concepts. The mdf holds to actual data. The ldf holds the transactions that have altered the mdf.
The diff backup holds all pages changed since the last full backup.
If you had a hard disk failure, what did you lose? What files/backups do you have?
The restore sequence if you need to rebuild the db is either
- restore full backup, restore diff backup, restore logs
- attach copy of an mdf/ldf.
April 24, 2011 at 1:05 pm
What is normally lost in a hard disk failure ?
April 24, 2011 at 1:25 pm
There is no "normally" for a hard disk crash.
What was on the disk that crashed, and what is on other disks on that particular machine? If everything was on one disk, then everything is gone.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply