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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-10-20 : 12:00:52
|
| Hi,For Example:I have a full backup from yesterday night, differential backup from today morning and transactional backup files for every 5 minutes. My question is if database crashes in the morning at 11 AM, I have to apply last full backup then last differential backup and then all transaction backup files taken after differential backup happened. Please advise if this is correct or not.I am trying to gather this information just in case if I need, so I can act quickly. Do I need to take any other steps after recovering the database.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-20 : 12:51:14
|
| Yes, Full Restore with NORecovery,last Differential with NORECOVERY,all T-Log except last one with NORECOVERY and last T-log with Recovery and you can use STOPAT option(specifying time) as well. |
 |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2008-10-20 : 14:04:56
|
quote:
Originally posted by sodeep
Yes, Full Restore with NORecovery,last Differential with NORECOVERY,all T-Log except last one with NORECOVERY and last T-log with Recovery and you can use STOPAT option(specifying time) as well.
Thanks :) |
|
|
|
|
|
|
Restoring database