Post reply

The database size verses the backup size verses the restored database size

  • June 18, 2015 at 8:59 am

    #318311

    The database size is 570 the space available is 170 MB. The sql server native backup file size is 350 GBs.

    It appears the backup process removes the space available?

    It appears the restore process, adds the space available back to the database.

    Are the above observations correct?

    Any thoughts and details are appreciated. Thanks.

  • June 18, 2015 at 9:25 am

    #1806426

    A backup contains only the allocated extents.

    When restored, a database is recreated exactly as it was at the time of backup.

    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

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

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