Post reply

Backup size estimation

  • October 31, 2012 at 9:49 am

    #264101

    We are going to do an upgrade from 2005 to 2008. Is there a way to estimate the size of a backup and time it might take?

  • October 31, 2012 at 10:05 am

    #1554684

    Best bet would be to look at your normal scheduled backups, see how large they are and how long they took.

    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

  • October 31, 2012 at 11:01 am

    #1554711

    Thanks Gail.

  • November 1, 2012 at 1:00 pm

    #1555150

    Since you are going to 2008, you should be using backup compression by default.

    Since backups are more likely to be IO bound than CPU bound, you backups will be substantially smaller and somewhat faster.

    The amount of space savings will depend on the type of data you have in the database.

    Therefore, you are going to have to do this empirically after the fact.

  • November 5, 2012 at 3:05 am

    #1555937

    arnipetursson (11/1/2012)

    Since you are going to 2008, you should be using backup compression by default.

    i read somewhere that compressed backups take cmparatively high CPU (from normal backup files) during restoration.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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