Post reply

bakup job time

  • April 1, 2008 at 3:37 am

    #184665

    sometimes backup runs for a longtime(3-4 hours) and not yet finished.In this case we have to cancel the backup job and restrat again the backup job ,then it takes only 1 hour to be completed.My question iswhy it happens .how to avaoid this situation.

    Thanks,

    Litu

  • April 1, 2008 at 7:07 am

    #796446

    Are you backing up across the LAN (not really recommened) or locally (faster)? Is anything else that is resource intensive running on the SQL server? Backup times are usually fairly consistent, unless of course a huge amount of data has been added/dropped.

    -- You can't be late until you show up.

  • April 2, 2008 at 4:57 am

    #797097

    I am taking backup locally.Sometimes it takes longer time and some times it takes normal time.Database size vary only 10 mb to 20 mb.Is it for temporary blocks it takes long time.

    Thanks,

    Litu

  • April 2, 2008 at 4:58 am

    #797098

    SQL 2005?

    If so, check the error log, see if there are any messages about teh backup buffer size been reduced.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 2, 2008 at 8:44 am

    #797294

    No ,it is Sql2000.what should I check then?

  • April 2, 2008 at 8:50 am

    #797300

    FYI - For quicker, more accurate responses, be aware of which forums you post to, this is for SQL2K5. :rolleyes:

    -- You can't be late until you show up.

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

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