Post reply

Backup Size

  • December 8, 2013 at 12:57 am

    #302120

    Hi,

    My one of database size around 5GB (data file 4.5 & log 500 MB) once i took the complete full backup the backup size is only 2.5 GB how its possible ? [Recovery model is full]

    My understanding is full backup will take complete .mdf and .ldf if so as per files size it should around 5GB but its reduced.

    Kindly clarify on this.

    Pradeep

  • December 8, 2013 at 1:58 am

    #1671749

    A backup is the size of the data in the file + the amount of log space needed to restore consistently. It is not the sum of the sizes of the files.

    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

  • December 8, 2013 at 11:06 pm

    #1671793

    Thanks.

    Pradeep

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

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