Post reply

Can't restore a Copy Only backup

  • March 24, 2009 at 12:14 pm

    #384196

    I'm trying to restore a Copy Only backup from a production server onto a test server. When I specify the backup file for the restore I can click the browse button, select the file, and see the backup set within the file. However, when I return to the Restore Database screen, the backup set doesn't show in the "Select the backup sets to restore" list. Does anyone know how to get the backup set to show so I can complete the restore?

    Thanks!

  • March 24, 2009 at 12:22 pm

    #965486

    it was backed up on a different server so is not recorded in msdb so will not show up. select the restore from a device option and browse to the .bak file you want to use

    ---------------------------------------------------------------------

  • March 24, 2009 at 12:23 pm

    #965487

    Try typing the restore command manually. I seem to recall running into an issue with Copy-only and the GUI restore window.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 24, 2009 at 12:23 pm

    #965488

    You don't need a set, just restore it.

  • March 24, 2009 at 12:28 pm

    #965490

    "If it was backed up on a different server so is not recorded in msdb so will not show up. select the restore from a device option and browse to the .bak file you want to use"

    I've done that. That's how I saw the set within the backup. However, it still doesn't show in the "Select the backup sets to restore" list.

  • March 24, 2009 at 12:30 pm

    #965491

    "You don't need a set, just restore it."

    When I try to restore with no sets showing and therefore none selected, I get the error "You must select a restore source."

  • March 24, 2009 at 12:32 pm

    #965492

    GilaMonster (3/24/2009)

    Try typing the restore command manually. I seem to recall running into an issue with Copy-only and the GUI restore window.

    Ok, I'll try that....

  • March 24, 2009 at 12:48 pm

    #965507

    GilaMonster (3/24/2009)

    Try typing the restore command manually. I seem to recall running into an issue with Copy-only and the GUI restore window.

    That worked! You rock Gail.

  • March 24, 2009 at 12:49 pm

    #965509

    Not have tried to restore a copy only backup, ever, the only suggestion I have is to script it manually and see if that works.

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

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