May 8, 2014 at 11:49 am
We have a SQL 2012 server instance that has log shipping set up to another SQL 2012 server to provide a warm standby for a forward facing application. The databases on the primary server occasionally are required to be backed up and restored to a development environment, completely different server. Is there a way to schedule full backups with log shipping enabled?
May 8, 2014 at 12:15 pm
Taking full backups do not interrupt the log chain so you can backup the primary databases with affecting log shipping. You should be regularly backing your primary databases anyway. Your log shipping secondaries cover you from hardware failure but what if a table is dropped/truncated. that will get shipped over to your secondary
Here's a quick FAQ about log shipping: http://www.brentozar.com/archive/2013/03/log-shipping-faq/
May 8, 2014 at 12:22 pm
Thanks for your quick response and further testing proves you are correct. I set up a full backup to complete while log shipping was enabled and then ran the jobs manually in the order they would likely occur and everything worked successfully.
With regard to table truncation or data loss, the databases are used as a presentation layer, there are not many transactions taking place. We have daily full backups in prd, dev and stage environments available. The log shipping is setup in the event of hardware failure.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply