Does SQL Server Maintainance Cleanup consider exact times when deleting old backups?

Posted by Heinzi on Server Fault See other posts from Server Fault or by Heinzi
Published on 2012-11-06T10:19:25Z Indexed on 2012/11/14 5:02 UTC
Read the original article Hit count: 542

Filed under:
|

Let's say I have a daily maintainance task that:

  1. Backups all databases and then
  2. removes backups that are older than 3 days.

Now let's say the first backup at day 1, starting at 10:00, results in the following files

db1.bak 2012-01-01 10:04
db2.bak 2012-01-01 10:06

Now let's say at day 4 the first step of the maintainance task (backup the DBs) happens to finish at 10:05. Will SQL Server

  • delete db1.bak and keep db2.bak (would be logical, but might be surprising for the user) or
  • keep both or
  • remove both?

© Server Fault or respective owner

Related posts about sql-server

Related posts about backup