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'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?

  • 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.

     

     

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Jun 20, 2022

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

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

     

    Olaf

Resources