Post reply

Estimate the time to restore database

  • October 18, 2005 at 8:23 am

    #166411

    Can anyone tell me a technique to estimate the time to restore database??

     

    Thanks in advance

  • October 18, 2005 at 8:46 am

    #597946

    How long did the backup take?

    -SQLBill

  • October 18, 2005 at 9:19 am

    #597965

    To add to what SQLBill says, it's been my experience that--all else being equal--restores take longer than backups, ranging maybe from 10% to 25% longer. (Hard drive space has to be allocated, and other fussy management stuff.)

       Philip

     

  • October 19, 2005 at 7:20 am

    #598221

    Backup takes about 32 minutes

  • October 19, 2005 at 8:04 am

    #598259

    Restore should take under 1 hour....I would guesstimate that it would be about 40-45 minutes.

    -SQLBill

  • October 19, 2005 at 3:51 pm

    #598507

    Just a couple of other points to factor in ... did you perform the database backup to disk or directly to tape ? Will the restore be from disk or directly from tape ? Also, the time of day and present user/server load may also add some time as well.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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