Maintenance plan: backup

Hi,

I have made a maintenance plan to backup a database.

The file name is like this: name_db_200606211209.BAK

isn 't it possible to get the filename to be always the same
(without 200606211209)

I have unchecked the checkbox to remove files older than x-days
but it still appends 2006... to itNot thru a maintenance plan. If you want the same file name for each backup, create a backup device, then manually create a sql agent job to backup the database to that device.

I would recommend using the init feature of the backup command so you don't keep appending the current backup to the backup device. That couls get messy (and quite large) after a while.|||Do you perhaps have an example of

an sql agent job to backup the database to that device ?|||Nope ... i use LiteSpeed to backup to disk and then have the files written to tape. I typically keep 2 or 3 days backups and trans logs on disk before deleting them.

I could type up all the steps, or you could try to do it yourself using Books OnLine. I prefer the latter, so that you learn to fish instead of me giving you the fish.

Try it, detail your results, and come back with specific questions that we can answer.