I am going to run a job nightly to restore backups from my prod box to my dev box. Is it possible to drop and replace a backup with the same name?
Let me clarify a little better.
When I wrote the script to restore the backups from the prod box to the dev box, I included the name of the backup file; exp.(backup_db_2004.bak). Each night my backup runs, a new file is placed in the backup directory with a unique name. Is there a way to change the name of that file before running my script?