Restoring in SSMS: how not to see copy-only backup?

  • We have a maintenance plan involving weekly full backup plus transaction log backup every 6 hours, and it's working OK. In addition to this, there's daily full copy-only backup, which us sent offsite.

    When in SSMS I right-click a database and choose Tasks->Restore, I expect to see the "regular" backup followed by transaction log backups. Instead, I see copy-only backup.


    I thought, since copy-only backup by definition is not part of the backup sequence, SSMS shouldn't show it in 'Backup sets to restore". Am I doing something wrong? Is there a way to show only the backups created by the maintenance plan?

    • This topic was modified 1 month, 2 weeks ago by  Vadim Rapp.
    • This topic was modified 1 month, 2 weeks ago by  Vadim Rapp.
  • SSMS doesn't know you want to exclude copy-only backups when you are doing a restore using the GUI. It is allowable/valid to restore a copy-only backup. It might be nice to have that a default w/ a checkbox in GUI one can uncheck to show copy-only backups...

    But no, that functionality doesn't currently exist.

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

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