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
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)
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.
Software Test Engineer - SQL Backup