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 vote and comment on it.

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

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

  1. If performing a scheduled restore and changing the database name should change the filenames automatically

    If performing a scheduled restore and changing the database name change the filenames automatically to match the new database name so the error / warning about the database failing wont occur. I dont want to specify a different directory to have to restore a database to

    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…)
    • Add SSL/TLS support for emailing results

      My company uses Google Apps for Business for email, so I'm not able to utilize the Backup Pro feature that emails results/logs. Could SSL/TLS support be added?

      Thanks

      10 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…)
      • 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

        9 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…)
        • Prevent "Refresh" repositioning the Activity History List

          This is an OLD problem that is still VERY annoying in EAP5.

          When reviewing the activity history and having scrolled down several pages, along comes "Refresh Connection" and promptly repositions the list at page 1. WHY? I don't want to be on page 1, I want to be on the CURRENT page.

          Please, do something to stop this wasting our time and making the product look bad!

          9 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 backups in the history of another server be the selection for a restore.

            When selecting a file for a restore, you can choose backup history or the file browser. It would be nice if you could pick a file in the backup history of a server, but choose a different server as the target for the restore.

            For instance, when you're using the restore wizard.
            - You "right click and press restore on server Dev1.
            - Choose select from backup history
            - Pick the server you want the backup from and the database you want to restore. choose the file or set of files that interest you from the backup history
            - Press…

            8 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 Filtering to the "Activity History" pane, including backup type, success/fail/warning, and date-range.

              1. In the “Activity History” pane, please add a function to filter the results displayed in that pane, by type of backup, failed/success/warning, and date-time range: When you are trying to find a specific DIFF backup and you have to filter through +200 5-minute transaction log jobs to get to your last DIFF, it is very annoying to zero-in on the exact job you are looking for (especially when the list keeps refreshing all of the time and throwing you back up to the top of the list).

              7 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…)
              • Fix the issue with the data file / log file name changing when restoring

                When restoring there is a UI bug on the restore step 2 of 4 screen (this existed in previous versions). If you click the ellipses next to the database data files or log files the file browser window opens but annoyingly changes the file name from the database name to name of the first file in the list. I then have to retype the database name and other changes that I want

                6 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…)
                • use SQL Server native Operators Mailing instead of SQL Backup mailing

                  It would be great if SQL Backup would use the native SQL Server Operators mailing system instead of his own mailing. We have implemented a mailing strategy with the Operators feature but we can't use it with SQL Backup. I have to put my email directly in SQL Backup!

                  I think it would be good if SQL Backup just use this mailing system instead of is own. That we, we don't have to repeat everything!

                  4 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 Exceptions to Scheduled Jobs

                    One of the odd problems we're running into is that some of our daily back-up jobs tend to overlap with our monthly archive jobs, making both jobs slow to a crawl because they're trying to access the same databases at the same time.

                    We have some other software that executes jobs on a scheduled routine and the interface includes an ability to define exception dates so the jobs don't collide.

                    Some of our database developers have noted the need to suspend a job at certain times, not understanding that it's the other software that can do that; RedGate doesn't have…

                    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 larger restore scripts

                      On many occasions, when trying to restore a VLDB with hundreds of files, I have ran into size-limits on the restore scripts. This has caused me to have to shorten all of my file paths and file names down to near-unrecognizable names like PTDf01.ndf just to get them all into the script, which makes the database less maintainable and more confusing. Is there some reason why the restore script cannot be several MBs long? Why is it limited to just a few KB?

                      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…)
                      • SHEDULE JOB RESORE

                        INTO SHEDULE RESTORE OR BACKUP JOB ABILITY TOO ADD OTHER STEP.

                        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 auto deleting old full backup sets, add an option to also delete all diff backups associated with that full

                          If I run a full backup every sunday night and diff backups mon-sat, and on the full I specify to keep the last 2 full backups. When it deletes an old full backup, it should also delete all diff backups associated with that full backup

                          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…)
                          • Provide the use of templates to quickly add and update new servers

                            It would be good if you could add a new server based on a template of another server already added. If I add a new server to a group, it will usually be configured with the same backup properties as the other servers in the group.
                            I would like the ability to update the common properties of a group, such as backup location, encryption, retention, validation etc without having to update each individual server in turn.

                            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…)
                            • Backup: Multiselect databases in combination with the option "Single Backup file, mirrored to second location" (= MIRRORFILE clause)

                              The current UI does not allow to backup databases to more than one location (MIRRORFILE clause).
                              The option "Single Backup file, mirrored to second location" (= MIRRORFILE clause)" is only available when you select one (and just one!) database.
                              Change Request: Make the option "Single Backup file, mirrored to second location" (= MIRRORFILE clause)" also available when more than one database is selected on the source database backup plane.

                              In our situation we take backups directly to a network path.
                              As a result, when the primary backup location is down, we don’t have a backup.

                              We don’t want to make…

                              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…)
                              • 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…)
                                • individual files in the restore wizard should load the logical names from the backup header

                                  When you have to choose to move the files to a new location the logical file names should automatically be filled in becuase they're available and have to be used.

                                  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…)
                                    • 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…)
                                      • Implement Retention Policy on files in hosted storage

                                        Are there any plans to implement a retention policy on the hosted environment that would “clean up” older versions of the backup files so they don’t continue to take up space?

                                        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…)
                                        • Enable multi-file selection for deleting hosted backups

                                          The only way I could see to clean out old version was to delete them individually. Can you implement a way to select multiple backup files to perform an action on (e.g. delete) so it doesn’t take so long?

                                          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…)
                                          ← Previous 1
                                          • Don't see your idea?

                                          SQL Backup

                                          Feedback and Knowledge Base