August 21, 2014 at 6:53 pm
Hey there, I hope someone can clear something up as I am getting conflicting messages off the net.
I have log shipping on a bunch of databases, and now I have been asked to take full backups now and again (running SQL 2008 R2).
Can anyone confirm whether or not the full DB backups will break the log shipping? Or will log shipping remain unaffected? These are full DB backups only, I'm not doing T-Log backups (yes I know, lets leave that for now!).
Thanks in advance.
D.
August 22, 2014 at 6:00 am
Full backups and log backups, after the very first log backup, are not in any way connected. You're safe to take those backups. Now, if you start introducing differential backups, then you'll need to add the COPY_ONLY command to avoid breaking the connection between your defined full backup and the differentials. But no worries on the logs.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 22, 2014 at 6:20 am
Duran (8/21/2014)
I'm not doing T-Log backups (yes I know, lets leave that for now!).Thanks in advance.
D.
Are you saying you've disabled the log shipping agent backup jobs??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 6:52 am
If you're doing log shipping, by definition you're backing up the transaction logs. That's how you can move them to another location.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 22, 2014 at 7:41 am
Perry Whittle (8/22/2014)
Duran (8/21/2014)
I'm not doing T-Log backups (yes I know, lets leave that for now!).Thanks in advance.
D.
Are you saying you've disabled the log shipping agent backup jobs??
I hope that isn't the case.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 22, 2014 at 8:24 am
Hi everyone,
Thanks for taking the time to reply, log shipping is currently the only form of t-log backups. I'm not stopping the log shipping no. I'd prefer to do t-log backups, but the log shipping is for reporting purposes, for read.
Regards,
D.
August 22, 2014 at 8:47 am
You can use the transaction log backups from log shipping in a recovery scenario.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply