August 3, 2017 at 6:09 am
Hi All
In an AlwaysOn environment, I understand that FULL backups can be offloaded onto my secondary replica and I believe that this is limited to copy_only backups.
I believe by testing that a differential backup cannot be restored to a database that was restored with a backup that was taken as copy_only.
My current strategy is weekly FULL's, daily DIFFS and hourly logs.
By offloading my FULL backups to my secondary replica, does this mean that my differential backups are now useless in a restore process?
Any help in understanding this would be appreciated.
Thanks
August 3, 2017 at 7:10 am
Short answer: Yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 3, 2017 at 7:18 am
GilaMonster - Thursday, August 3, 2017 7:10 AMShort answer: Yes.
Thanks
What would you recommend if I were to offload full backups to the secondary replica? Increase the frequency in which full backups are taken then?
August 3, 2017 at 7:38 am
Why are you currently doing weekly fulls and daily diffs?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 3, 2017 at 7:42 am
GilaMonster - Thursday, August 3, 2017 7:38 AMWhy are you currently doing weekly fulls and daily diffs?
Mostly because of the performance hit we incur when running full backups
August 3, 2017 at 8:05 am
SQLSACT - Thursday, August 3, 2017 7:42 AMGilaMonster - Thursday, August 3, 2017 7:38 AMWhy are you currently doing weekly fulls and daily diffs?Mostly because of the performance hit we incur when running full backups
If you offload to the secondaries, you shouldn't have that problem (unless the IO subsystem is terrible), so less of a reason to use fulls and diffs.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 3, 2017 at 9:37 am
GilaMonster - Thursday, August 3, 2017 8:05 AMSQLSACT - Thursday, August 3, 2017 7:42 AMGilaMonster - Thursday, August 3, 2017 7:38 AMWhy are you currently doing weekly fulls and daily diffs?Mostly because of the performance hit we incur when running full backups
If you offload to the secondaries, you shouldn't have that problem (unless the IO subsystem is terrible), so less of a reason to use fulls and diffs.
Thanks for your help
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply