Comments
Sort by recent activity
Thanks Peter.
Makes perfect sense now.
Regards,
Bob / comments
Thanks Peter.
Makes perfect sense now.
Regards,
Bob
Just done some further reading on this and discovered that my understanding of my restore scenario is wrong.
So, unless I'm mistaken, I could still use the same backup set for the restore without any problems.
:oops: / comments
Just done some further reading on this and discovered that my understanding of my restore scenario is wrong.
So, unless I'm mistaken, I could still use the same backup set for the restore without a...
Hi Peter,
Thanks for taking the time to reply.
Reading back my post, I don't think I explained particularly well what my query is - I'll try and clarify a bit better.
Let's say I have the following backup files (all created by RedGate):
Full_1
Log_1
Log_2
Log_3
Diff_1
Log_4
Log_5
Log_6
Full_2
Log_7
Log_8
Log_9
Diff_2
Log_10
Log_11
If I wanted to restore up to (and including) Log_6, I would restore Full_1, Diff_1, Log_4, Log_5 & Log_6. Pretty straightforward.
However, let's say that unknown to me, someone had taken a full backup of the database (via SSMS) after Log_4. Surely in this case, the "log chain" will have been broken, and my attempt at restoring using the same backup set would fail?
Hope that makes sense.
Thanks,
Bob / comments
Hi Peter,
Thanks for taking the time to reply.
Reading back my post, I don't think I explained particularly well what my query is - I'll try and clarify a bit better.
Let's say I have the following...