September 22, 2018 at 7:11 am
Hi All,
Thank you in advance for your help.
I am running sql server 2012 standard edition. I am looking to setup log shipping to a report server.
My question is can I do additional backups on the primary database for DR purposes without affecting the log shipping to the report server? I would like to do a full each Saturday night and differentials during the week that I send to a DR environment. Will this break log shipping because the logs being sent to the report server will be associated with a different full backup?
September 22, 2018 at 7:37 am
dhydier - Saturday, September 22, 2018 7:11 AMHi All,
Thank you in advance for your help.
I am running sql server 2012 standard edition. I am looking to setup log shipping to a report server.
My question is can I do additional backups on the primary database for DR purposes without affecting the log shipping to the report server? I would like to do a full each Saturday night and differentials during the week that I send to a DR environment. Will this break log shipping because the logs being sent to the report server will be associated with a different full backup?
Additional backups will not affect log shipping - transaction log backups do not tie to a specific backup and can be applied to any previous backup as long as you have the full log chain from that backup to the point in time you are recovering.
What will be affected are your differential backups - which are tied to the previous non-copy only backup.
If you are going to be running differentials then you will need to make any other backup processes that are running perform copy-only backups. If you run a full backup on Saturday - a differential on Sunday at 10pm - another full is run by another process on Sunday at 11pm - then your next differential is run on Monday at 10pm, the Monday 10pm differential is tied to the Sunday 11pm backup and your chain is broken for restore at the DR site.
If the Sunday 11pm backup is set as a copy-only backup then the Monday 10pm differential would still be tied to the Saturday full backup.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply