Home Forums SQL Server 2005 Administering backup file growth and disk size-SQL 2005 database RE: backup file growth and disk size-SQL 2005 database

  • November 26, 2012 at 2:22 am

    #1562100

    Sqlsavy (11/26/2012)

    full backups taken every day (deleteing old backup file from previous night) .Backups are copied daily to tape.

    db size is around 800GB and Litespeed backup file size is around 450 Gb.

    with 300mb growth a day - 30 x 330mb = 9.9GB (ish a month) to your database. Looks like your backup is about 60% of your database so the backup size will increase by about 6.6GB a month (very rough)

    What is the size of your backup drives ?

    I assume you already worked out the above.More experienced people will comment further...