Home Forums SQL Server 2005 Administering Database size increase RE: Database size increase

  • January 13, 2015 at 1:41 am

    #1769722

    paul.farnell (1/12/2015)

    8000MB

    How does that logic work then ?

    The size of a database is the sum of the size of all data and log files it has.

    One data file of 20 GB

    One log file of 8GB

    Therefore database size is 28GB

    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