Post reply

Confused with BAK file Size

  • September 19, 2008 at 5:32 pm

    #193822

    Hello All,

    I have 7 databases with size 1gb ,2gb,1.5gb,3gb etc.

    I scheduled a job to take full backup of these databases.

    But .BAK files are of size in MB's like 800mb,400mb etc..

    Why this difference is happening?

    Thanks

    Kotla

  • September 20, 2008 at 2:29 am

    #874559

    The backup is the size (more or less) of the data in the database, not the file size of the databases. It means that your DBs have some space free inside them.

    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

  • September 20, 2008 at 6:48 am

    #874586

    However, if you don't use the WITH INIT option, they'll get to be the same size :hehe:

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

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