June 27, 2022 at 2:18 pm
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?
June 27, 2022 at 2:55 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy