kesmond (6/20/2011)
Dear all,just to check with you. for restoration of database, i would need to perform the following:
I did a full backup at around 1pm today. and a differential backup at 130pm today, follow by transaction log backup every 5 mins from 130pm onwards.
If i wish to restore back the information that is at 2pm. I would need to do the following:
1) Restore the full backup (with norecovery)
2) Restore the differential backup (with norecovery)
3) Restore all the transactions logs from 130pm onwards to 2pm (withrecovery)
Am i right? And also there would be only 3 files. Fullbackup.bak, DiffBackup.bak and Logbackup.bak for the entire backup processes. Am i right ?
Yep restoration sequence is right.
Am i right? And also there would be only 3 files. Fullbackup.bak, DiffBackup.bak and Logbackup.bak for the entire backup processes. Am i right ?
Its depends upoun your backup plan if you are append all the files then there will be a single log bak file.
See the bottom of the post .
What is the sequence to restore the database?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/