How can we help you today? How can we help you today?

Feature request - Exclude OFFLINE dbs in db selection window

I am not sure if it's currently done, but in the last week while we moved many databases, we had to go in and manually de-select Offline databases for the SQL Backup jobs

In the Backup Databases Selection window (either via the Manual backup, or Schedule Backup Job method), the checkbox to "Filter List to show only databases eligible for the chosen backup type"

I would imagine OFFLINE databases are not eligible for ANY kind of backup type, and thus should not be available to SELECT/DE-SELECT

Another question:
Are OFFLINE/SIMPLE mode detected at run-time, or job-creation time?
e.g. are the backup jobs smart enough to exclude OFFLINE at run-time, or SIMPLE recovery mode databases for TLOG backup?

Please see the screen shots
256e7g3.jpg
96hlyt.jpg
jerryhung
0

Comments

4 comments

Sort by
  • Anu D
    Thanks for your post and apologies for the inconvenience caused.

    I tired to replicate the issue but it grays out the Database if Offline/Restoring/Suspect mode.

    Can you kindly confirm the version of SQL Backup you are using?

    You can know the detailed version of SQL Backup by navigating in SQL Backup UI by selecting Help --> About SQL Backup and version number is displayed on bottom right.
    Anu D
    0
  • jerryhung
    Anu

    I have SQL Backup 6.4.0.56 as Client
    and on all the servers as well

    I have always had this issue for OFFLINE databases since 6.3 though

    FYI: I got the screen from double-clicking on a scheduled Backup job

    I just did it again
    - intentionally take MDW db offline
    - refresh in SQL Backup
    1. I see MDW greyed out when I do "manual backup" = GOOD
    2. I double click on my current FULL/DIFF jobs, I see MDW in "Orange" = BAD

    so I think that's only the place it happens, so I think it's still a bug unfortunately :) Hopefully gone in 6.5 version
    jerryhung
    0
  • Anu D
    Many thanks for detailed steps I replicated the scenario at my end.

    I have logged this as a feature request in our internal tracking system whose tracking id is SB-4534.

    I will update you as soon as this functionality is incorporated.

    Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.
    Anu D
    0
  • jerryhung
    Many thanks for detailed steps I replicated the scenario at my end.

    I have logged this as a feature request in our internal tracking system whose tracking id is SB-4534.

    I will update you as soon as this functionality is incorporated.

    Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.

    I would classify as a bug rather than a feature :P

    but thanks for accommodating me, and hope to see it in 6.5 (or 7.0)
    jerryhung
    0

Add comment

Please sign in to leave a comment.