I have created maintenance plan to take full backup of selected database. In property I have selected to create sub directory for all database.
Now Maintenance plans create backup file name DATABASENAME_backup_YYYYMMDDHHMM.bak file (e.g. MICROBRAIN_Backup_201105171555.bak.
I want that Maintenance Plan should Create File Name as DATABASENAME.BAK (e.g. MICROBRAIN.BAK)
Please Help me How to do this ? Because Creating Seperate Backup file on every backup will exhaust space in removable Hard Disk.
View Complete Post