Post reply

Baffling Sql2k backup times

  • March 8, 2004 at 10:36 am

    #65951

    For the longest time the nightly Sql backup job of a particular server took about 30 minutes to run. This job backs-up the live databases to a local directory on the same box.

    Last Thursday I noted the time for the same backup had suddenly dropped to about 9 minutes -- and has remained at that level ever since.  I checked all databases for any precipitous change in size (or deletion)  and found none. I checked with the networking guys to see if they had changed their (tape) backup schedule for that server. We reviewed the logs and the answer was no.

    Any ideas on this one or where to look mcuh appreciated?

    TIA,

    Bill

  • March 8, 2004 at 11:18 am

    #497854

    1. How do you do you backups? Via SQL Server commands or via third-party software? Do you take the server off-line/detach databases?

    2. Any idea what else happened last Thursday? Did you have jobs running before then that aren't running any more? Did the network people have jobs running that aren't running any more (or are running at a different time)?

    3. Any upgrades (to drivers, software, scsi, etc)?

    4. Any change to the type of backup (we are talking about a FULL backup right?)?

    -SQLBill

  • March 9, 2004 at 1:23 am

    #497925

    Although no change to the DB size, did the size of the backup change?


    Cheers,
    - Mark

  • March 9, 2004 at 10:18 am

    #498011

    We had a similar issue - backup times had gone up drastically - and it turned out that 1 of the disks in the array had gone bad - as soon as we replaced that disk - the backup time came down to normal.

    - DK

  • March 9, 2004 at 7:11 pm

    #498080

    I haven't yet found the source of the problem but thank everyone for their thoughts!

     

    Bill

  • March 10, 2004 at 7:44 am

    #498127

    While this doesn't offer any reasons why it is happening, I think the first thing I would do is try to restore one of those backups (obviously not over production)!

    Steve

  • March 10, 2004 at 9:35 am

    #498149

    I didn't think of it, but a restore makes sense. Be sure that your integrity has not suffered before you go any further.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

Viewing 7 posts - 1 through 6 (of 6 total)

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