Browse by Tags

Why use BACKUP...WITH COPY_ONLY?
03 June 2008 18:49

New in SQL Server 2005 - this BACKUP option doesn’t appear especially interesting from the description in Books Online - however could be really handy in some scenarios. The benefit of using the COPY_ONLY option is that it doesn't break the backup chain - so won't disrupt the restore routine required for regular log, or differential backups. Periodic... Read More...

by JustinL | with no comments

Filed under: best practice, lsn, database backup