SQL 05 automatic delete table older than 3 days

• h2sut

  SSC Veteran

  Points: 241

  More actions

  December 18, 2007 at 5:47 pm

  #119298

  would like for you to come up with the SQL that will automatically delete any table backups that are older than 3 day. Beware of months/days with single digit.

  Does anyone no the best way to do it. I was thinking about some time of script but i not sure

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736160

  More actions

  January 1, 2008 at 8:58 pm

  #763901

  SQL Server doesn't do table backups. It does database backups and you can search for scripts to handle that. The Maintenance plan can also do this.