SQL Backup

This forum is for you to give us your feedback on SQL Backup, and suggest new ideas. Please let us know what you think! Post your suggestions, and share your views here.

How can we improve SQL Backup?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Filenames should be changed in extended SP restore with MOVE DATAFILES TO option

    When I execute a RESTORE command using the extended Stored Procedure, I'd like to use the MOVE DATAFILES TO option. But I can't use it when restoring to a NEW database in the SAME folder, because, unlike via the GUI, restoring via the extended SP uses the original filenames from the backup file. And they of course exist. I'd like an option, without having to use MOVE ... TO ... to have similar behaviour as in the GUI: a restore of backupfile X to database Y gives me files automatically renamed to Y.mdf, Y_1.mdf Y_2.mdf etc.

    3 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…)
    • Network Path as a Server Option and <token>

      Add a Server Option to store the root UNC path for network-copied backups.

      Enable us to test the credentials here.

      Make the path a new <NetCopyLocation> token so we don't have to change every job should the UNC change, which happened to me when the original server croaked in a big way...

      Make sure we can use the same "separate folder for each database" paradigm when stating the path for each job.

      Allow the service to create the destination folder on the fly rather than have to predefine it for every new database.

      3 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…)
      • Support for Certificate based Backup Encryption

        Need the ability to do backups based by certificate, not just by a pre-shared key. It'll be more secure if a private key needs to be in a keystore, rather than just a shared secret anyone could brute force.

        Whether the keystore/certs are stored in MSSQL's built in certificate support, or through the compact database, or through the certificates snap-in (perhaps on the service account), or through some other means; could be up for discussion. Selection of certificate by fingerprint or serial number via the Backup/restore commands... Additional ability to use a pre-shared key to lock or unlock the certificate.

        3 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…)
        • The ability to multi-select restore items on the Restore (Step 1 of 4)

          The ability to multi-select restore items on the Restore (Step 1 of 4), there could be several hundred log backups throughout the day and although you can add/remove ALL, you can only select/remove one at a time (tried shift and/or ctrl) if the chain is broken or needs adjusting

          3 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…)
          • The ability to set a default smtp server & email for all registered servers/jobs.

            It would be extremely convenient to be able to set a SMTP server and Email for the backup notifications to go to rather than configure it server by server and job by job.

            3 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…)
            • I would like to be able to reorder the time-zone tabs

              At the moment it seems that the order of the time-zone tabs is fixed in the order that you create them. I want them in order of timezone.

              3 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…)
              • Save changes to servers.dat file without closing GUI.

                When making changes to servers in the backup interface, I often loose my work due to an unexpected crash or a process that is hung up. Please add an option to save changes to the servers.dat file without closing the interface.

                3 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…)
                • When backing up multiple databases & using COPYTO= there should be an option to put each copy in it's own folder.

                  When i backup severa databases i have the option to Create a subfolder for each database. I'd also like a similar option for the copies. I know that i can edit the script to do this, but it should be automated.

                  3 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…)
                  • Add integration with other cloud storage options

                    The ability to automatically copy backups to Amazon cloud drive, Microsoft one drive, Google drive, Dropbox, iCloud drive, etc. would be a great feature. Allow the customer to choose which cloud services they want to use.

                    3 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…)
                    • Save splitter position between database names panel and schedule panel

                      Currently, every time you open the SQL Backup screen, the database names on the left are truncated and ellipses are added to the truncated name. This is confusing when names start with the same text. I would like to see the position of the splitter that is between the database names panel and the schedule panel saved and restored when the program is next opened.

                      3 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…)
                      • Allow different levels of information in the post-backup email

                        The email sent on completion of a backup job is too verbose. Whilst I *may* want to see such a level of detail at times, I would like to have control over it. Ideally I would like a bullet point email listing all databases and the status of the backup, maybe listing all the failures / with-errors at the top of the list so I don't have to scan 150+ rows looking for issues.

                        You could use the madness of XML a la Symantec Backup Exec which presents a high level view of the backup job and then you can…

                        2 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…)
                        • Send a combined email (rather than separate emails) when multiple files copied to network share as part of a job

                          When I backup multiple databases in one job, and select the option to get an email confirmation for any outcome, I get one email for the job - which is great. If I then add the option to copy the backups to a network share as part of the job, I also get email confirmation of the successful copies - but I get one email per database rather than one email for the job. As I have about 60 databases, this results in lots of emails. I'd like to get email confirmation of the copying on a per-job basis (like…

                          2 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…)
                          • Backup User Database ability to GUI

                            Within the interface, generate the BACKUP USER DATABASES as an option, instead of listing individual databases (i.e., if you set this mode, the script will "know" when new databases are added). Right now it only generates scripts with each named database listed--you should not need to manually script this.

                            2 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…)
                              1 comment  ·  Admin →
                            • Is there a way to see the history of a successful copy to hosted storage.

                              Some logging to see when the copy started and finished to hosted storage?

                              2 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…)
                              • Being able to create a reminder when editing a backup job

                                When Database(s) get added to a server, we have to edit the backup job to get them included. It would be nice to be able to create a reminder to include them on the restore as well.

                                2 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…)
                                  1 comment  ·  Admin →
                                • Need to group by database name

                                  Would really be helpful to group or filter by database name so I can see my backups for a specific database.

                                  1 vote
                                  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…)
                                  • Used Storage

                                    It would also be nice to see how much storage space is being used in total, and by database.

                                    1 vote
                                    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…)
                                    • Change time zone

                                      Hi

                                      I would like to be able to change the time zone in the online portal from UTC to whatever time zone the customer is in.

                                      1 vote
                                      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…)
                                      • Backup Organizing feature

                                        Hi,

                                        It would be better if can allow to organize the backups such as Sorting backups by type, date and folder organizing such as putting them on separate folders.

                                        Please let us know if this feature is available.

                                        Thanks.

                                        1 vote
                                        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…)
                                        • New Feature: Set time to automatically close the UI

                                          I have been informed by technical support that there is a known issue with the UI being left open for an extensed peroid of time. When left open the UI affects the performance of the Server Agent on the database server(s). I my case I have 6 servers.

                                          My sugestion is to add a field that will automatically close the UI if it is left unattend for an extended peroid of time (example: 1 hour). The end user should get the choice as to what the time peroid is.

                                          1 vote
                                          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…)
                                            1 comment  ·  Admin →
                                          • Don't see your idea?

                                          SQL Backup

                                          Feedback and Knowledge Base