COPY_only Backup??

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 1

Yes you may.

It's simply another backup, but it doesn't affect the chain of log backups and differential backups which are based on the last full backup.

To use it, simply append WITH COPY_ONLY to the regular backup script:

BACKUP DATABASE AdventureWorks2008

TO DISK = ‘c:\bu\AdventureWorks2008_Copy.bak’

WITH COPY_ONLY

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt