Forum Discussion

drhunter685's avatar
drhunter685
Copper Contributor
Jun 20, 2022

Database backup with COPY_ONLY and common backupsets

Hi! 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'...
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jun 21, 2022

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.

 

 

Resources