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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2009-03-18 : 02:22:57
|
| Applying the log sequential backups to a database i can't later stop At a previously applied fully applied log?ex:applied log1 no recoveryapplied log2 no recoveryapplied log3 no recoveryapplied log4 stop at (log2 elapsed time) with recoverywill not recover to log2 time? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-18 : 08:25:42
|
| If you were going to do a stop at on an earlier log you would have to have done it with recovery. For example if your stop at time was part of log3 then you would have used restore log stopat with recovery and that would be it. You can't restore logs after the stop at point that doesn't make any sense and your LSN chain would no longer be in order.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
restoring log question