December 2, 2011 at 4:41 am
Hi,
We have a SQL 2008 server with two databases that are being backed up using BackupExec and the logs are being backed up every 15 minutes.
I'm implementing a solution which requires me to take a copy of the databases and restore them to another server.
I was planning on doing this via a SSIS package, but I'm a little concerned that this would upset the log backup strategy as it would create a new starting point.
Is it possible to backup a database without it interfering with the log backups?
Many thanks,
Graham
December 2, 2011 at 4:49 am
Full backups don't affect log backups in that way. They only affect differential backups. If that's not part of your restore strategy, then you're fine.
"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
December 2, 2011 at 4:51 am
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
December 2, 2011 at 4:59 am
Brilliant, thank you very much for your speedy replies.
Thank you!
Graham
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply