Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
veggiop
Starting Member
10 Posts |
 Posted - 2011-06-22 : 02:35:01
|
| 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 ?http://www.fivefingers.me/vibram/ |
|
|
raghuveer125
Constraint Violating Yak Guru
285 Posts |
Posted - 2011-06-22 : 03:06:08
|
| 1 and 2nd steps ok.3rd stepYou need to restore 1.35pm-1.55 trna backup with norecovery and at the end last tran backup (2pm tran backup)you need to restore withrecovery. In Love... With Me! |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-22 : 14:08:10
|
| Nope. You need the full, the diff and then ALL the log backups in sequence, so a lot more than 3 files.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Backup and Restore queries