SQL Server Performance Forum – Threads Archive
Overwrite exsiting bak fileI 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,
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.