SQL Server Performance

Overwrite exsiting bak file

Discussion in 'SQL Server 2005 General DBA Questions' started by beaniebear, Nov 10, 2005.

  1. beaniebear New Member

    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
  2. Haywood New Member

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

    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.

Share This Page