Post reply

Storage Space Estimation (Can Calc Table Size)

  • April 2, 2007 at 2:04 pm

    #171897

    Hi,

    I'd like to guesstimate how much space is required for a 2005 database and log file. I can calculate the size of the tables but how big will the log file be in relation to this? When you backup the database, what happends the log file?

    Thanks,(Amateur!)

  • June 19, 2011 at 5:14 am

    #1340853

    Hi,

    Please run the following query

    SELECT

    SUM( * 8) / 1024 AS DB_Size -- Field "size" contains the number of 8 KB pages contained in each file

    FROM

    [db_name_here].sys.database_files

  • June 19, 2011 at 8:32 pm

    #1340950

    dec_obrien (4/2/2007)

    Hi,

    I'd like to guesstimate how much space is required for a 2005 database and log file. I can calculate the size of the tables but how big will the log file be in relation to this? When you backup the database, what happends the log file?

    Thanks,(Amateur!)

    There are several sections in Books Online on how to do this. Please lookup "estimating database size" in Books Online.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 20, 2011 at 6:56 am

    #1341150

    dec_obrien (4/2/2007)

    When you backup the database, what happends the log file?

    Absolutely nothing. Database backups don't even look at the log file. Transaction Log Backups, however, are a different story entirely. Read the entry in Books Online to get more details. Then let us know if you have any questions on what you've read.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • June 20, 2011 at 7:25 am

    #1341178

    Jeff Moden (6/19/2011)

    dec_obrien (4/2/2007)

    Hi,

    I'd like to guesstimate how much space is required for a 2005 database and log file. I can calculate the size of the tables but how big will the log file be in relation to this? When you backup the database, what happends the log file?

    Thanks,(Amateur!)

    There are several sections in Books Online on how to do this. Please lookup "estimating database size" in Books Online.

    My bad. I misread that... the size of the log file doesn't actually have much to do with the database size. It depends on things like how big your largest transactions will be and how often you do a logfile backup.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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