Activity overview
Latest activity by vanderetto
SQL2012 AlwaysOn Availability Groups
Hi,
Does anyone know if there are any plans to be able to use a replica server within SQL Backup anytime soon?
Or, has anyone actually managed to get SQL Backup installed on an Availability Group a...
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...
Transaction Log Restores
Hi All,
I currently have the following backup schedule for a selected database:
Weekly FULL, Daily DIFF & Hourly LOGS
I was under the impression that any FULL backup that was done on the database w...