Home Forums SQL Server 2005 Backups How take backup without overwriting or Appending the old files RE: How take backup without overwriting or Appending the old files

  • January 13, 2012 at 6:37 am

    #1433187

    guruprasadurs (1/9/2012)

    Hi,

    I want to schedule back up DB in ms sql server 2005 using maintainence plan wizard. I want to know Is it possible to schedule backup like Test09jan2012.bak, Test10jan2012.bak, Test11jan2012.bak in backup folder. Like individula files.

    Please let me know if possible.

    Thnaks in Advance

    Regards,

    GP

    Maintenance Plan does that only. It automatically adds the timestamp in backup file name. Also, it asks you whether you want to store the backup files in a single backup directory or you want to create new directory for each & every database backup. Choice is yours!!

    Sujeet Singh