Backup on file and delete old backups

• garsan

  Newbie

  Points: 5

  More actions

  March 4, 2011 at 10:11 am

  #233001

  Hello, Im new with SQL Server, Im using Express 2008 and I hope someone can help me with this.

  I want to backup a database to a file called "backup.bak" (no problem until here) and on the same file save 3 backups, for example

  day 1

  backup 1

  day 2

  backup 2

  day 3

  backup 3

  day 4

  delete the oldest backup (backup 1) and store the new backup 4 with backup 2 and 3 and so on

  Any clue?

  Thank you all!

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  March 4, 2011 at 11:31 am

  #1294824

  Please check if "RETAINDAYS" option while Backing up the database meets your requirements. Read more here

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga