SQL Server Performance Forum – Threads Archive

Overwrite exsiting bak file

I set up Maintenace Plan to do databases backup. When the new bak file is created, it will not overwrite the existing one. Is there option that we can check to overwrite the exsiting one? Or can I modify the T-SQL created by maintenace Plan? thanks,
– Kathy

Nope, the maint plan creates a unique filename each day. You can however set it to delete files older than X days.

My suggestion is if you want to manage the backup/restore process according to your requirement, then better not to rely on wizards and maintenance plans. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>