Post reply

Database dump/ tape backup scheduling

  • November 23, 2001 at 11:45 am

    #104693

    Scheduling of database backups:

    In the past I dumped our databases to a local folder at 9pm and backed the folder up to tape. Due to a shrinking time window our Sys Admins are kicking the Tape jobs off at 6pm. I have no control over when the job backs-up a given server. If the tape backup happens before 9pm, then it captures the previous day's database dumps. If it happens after 9pm, it gets the current days dumps. In the middle of this we have hourly trans logs dumps (not really needed at night but running)

    How do you handle database dumps /backup scheduling?

    TIA,

    Bill

  • November 23, 2001 at 3:43 pm

    #420361

    I keep at least two days on disk. In my case I know that the tape backup will always run after the SQL job. Keeping two days on disk allows me to restore more quickly, but more importantly if the tape job fails I have a chance to get the backup on tape again the following night. Usually not a big deal, but it sucks when you're wanting to do a restore from a week earlier only to find out that its not on tape!

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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