Database backup with COPY_ONLY and common backupsets

Copper Contributor


I need to copy my product database with BACKUP and RESTORE operations. This is an intermediate copy at a point in time. 

I use backup command with a COPY_ONLY parameter so that this step doesn't affect a main set of backups. But when I restore my database from the main set, the server requires to use the backup created with the COPY_ONLY parameter anyway. What did I do wrong?

2 Replies

@drhunter685 , I don't understand what your issue is?

It doesn't matter which backup options you use, the restore process is the same.



Hi @drhunter685 -- Try using the "restore headeronly" command on the backup that was supposed to be COPY_ONLY and check that the "IsCopyOnly" bit is set.  Take care.