Post reply

Backup Size

  • November 2, 2014 at 9:07 pm

    #294829

    Hi All,

    I was told by my seniors that that the backup size will be more in compare to actual size of database in SQL server,(for example if my database is 10GB and when I take backup of this database it will be 12 GB).

    Is it correct if so why will it be more in size?

    Thanks.

  • November 2, 2014 at 10:36 pm

    #1756258

    No, it's not correct.

    he backup will be at most the size of data + log file and will generally be smaller.

    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

  • November 2, 2014 at 11:40 pm

    #1756262

    As Gail said, whoever told you that is wrong.

    Although one could possibly misconstrue that a backup is larger if they only look at the on disk size of a file that may contain multiple backups. But that is different because it would be the aggregate of multiple backups and not a single backup.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • November 3, 2014 at 1:03 am

    #1756269

    Thanks Shaw for your valuable inputs.

  • November 3, 2014 at 10:55 am

    #1756374

    Furthermore, if you use SQL Server native backup compression, it may be substantially smaller

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

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