Post reply

Database backup times double

  • December 29, 2006 at 8:29 am

    #122090

    I have a backup job that do a full back up of a 46 GB SQL Server database. Usually, it takes about 2 hrs to for the backup to finish. Started on Dec 25th this month, the backup time doubles to 5 hrs. We don't have anything changed in the server and the database size seems to stay the same.

    Any suggestions as of what is causing the backup time to double?

  • December 29, 2006 at 8:49 am

    #680519

    Are you doing local backup or network backups?

    Check for disk error and disk queuing during backups operation...

    If your backup is network backup then check Network adaptor for any errors or configuration change...

     

    MohammedU
    Microsoft SQL Server MVP

  • December 29, 2006 at 9:55 am

    #680542

    Please double check that the job hasn't changed. You might not have changed something, but someone else might have. Also, check disk space and Mohammed's suggestions.

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

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