Post reply

System date change and backups

  • May 10, 2011 at 8:22 am

    #239788

    Hi,

    I have this SQL server 2005 instance where a maintenance plan is in place -

    1. Daily full backup - at 12:30AM

    2. Hourly log backup - starts 12:00AM

    Issue is that the Tlog backup job run at 12:00AM fails, rest all runs in the day are going good.. this is a daily observation.

    The system has enough space, so space issue is ruled out as root caise. No system errors in eventlogs as well.

    My conclusion comes to a point where I have to bring in the "date" change into picture.

    The last full backup which is the reference for all Tlog bckups is at previus day 12:30AM. (eg 5/9)

    My tlog bkup at 12:00AM will be at next date (5/10).

    So does this make the full backup "invalid" in some way ?

    All later backups (full at 12:30AM and consequent Tlog backups at 1:00AM, 2AM etc) are all successful.

    Is system date change causing the problem ?!!

    Thanks in advance for inputs !!

  • May 10, 2011 at 9:16 am

    #1322393

    My bad ...

    didn't check the "Backup set expiry" setting before posting the question. This was set to "1 day", so naturally at 12:00AM the last backup becomes invalid ...

    to avoid that one failure, changed the schedule, full backup at 12AM and hourly log backups starting at 12:30AM 🙂

    Thanks !!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply