Space estimate for database

  • Is there any script available which would estimate the space growth for a database so that proper

    space addition could be made to overcome space shortage. Thanks.

    M&M

  • Search "database growth" and you will find quite a few posts & scripts

  • Moin,

    As per http://www.sqlservercentral.com/scripts/Backup/62497/ try it:-

    From this you can get a pretty good idea of how fast your database is growing.

    select

    BackupDate = convert(varchar(10),backup_start_date, 111)

    ,SizeInGigs=floor( backup_size/1024000000)

    from msdb..backupset

    where

    database_name = 'DatabaseName'

    and type = 'd'

    order by

    backup_start_date desc

    HTH!

    Manu

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

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