How can we improve SQL Backup?

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

16 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...
      • Anonymous commented  · 

        Also when performing any "MOVE" syntax command, the software should automatically use the filegroup names rather than suffixing with "_1.ndf" as if you have multiple filegroups you get an error as the "filename_1.ndf" already exists

      • Andrew Hodge commented  · 

        Hi Jonathan, basically when doing a scheduled restore, choosing create a new database (http://www.ahah.org.uk/forumposts/scheduled_restore_2.png ) and using the same directory I get the warning that the restore will fail because the filenames are the same (http://www.ahah.org.uk/forumposts/scheduled_restore_3.png ). I would prefer that if you create a new database in a scheduled restore then the data and log files are renamed (the MOVE syntax) as in the normal restore so that warning / error doesnt occur....(http://www.ahah.org.uk/forumposts/normal_restore.png)

      • Hi Andrew,

        Could I request a few more details about the behaviour you are seeing?

        I have tried to get the Restore Wizard and Scheduled Restore Wizard to keep the name of the database stored in the backup when overwriting a different database or creating a new one to no avail.

        I can only get it to behave the way you seem to be suggesting you want.

        Regards,

        Jonathan
        ---
        Software Test Engineer - SQL Backup

      Feedback and Knowledge Base