In SQL 2005 a COPY_ONLY option became available for backing up your databases. What COPY_ONLY does is take a backup (full or t-log) without affecting the backup/restore cycle. This is a great new feature as quite often DBAs are asked for an out of sequence backup to be taken to restore to a different environment. [...]


