How can we improve SQL Backup?

Copy only backups should not be included in the restore list

Backups made with the copy only option checked should not be included in the backup history list of databases when restoring by default. The copy backup is used to maintain the sequence of logs so I dont think these should be shown in the

11 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Andrew Hodge shared this idea  ·   ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Stephen commented  · 

        Agree with Jonathan and Andrew, option is best as we take full COPY_ONLY backups from Production and restore for parallel testing.

      • Andrew Hodge commented  · 

        If it could be the other way round. Have the option to filter copy only backups out on by default and then remove the filter to show the copy only backups

      • Hi Andrew,

        There might be some use cases where this behaviour might be desired. Whilst I have raised an enhancement request (SB-4934), what we might do is add a option to filter this out of the activity history rather than always hide them.

        Regards,

        Jonathan
        ---
        Software Test Engineer - SQL Backup

      Feedback and Knowledge Base