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

  • Sqlsavy (11/23/2012)


    Hi All,

    We use Litespeed to backup our databases. One particular database grows 330MB/day there is enough space on the data and log drives but I think backup drive will run out of space very soon.

    My PM is asking how quickly would the Backup drive will run out of space? a month or 2 months?

    I've no idea how to calculate that?

    Could you please help me with this ?

    Thanks!

    Its hard to say without knowing more

    Which compression level are you using in Litespeed?

    How large are the current backups?

    Are you taking full backups daily or weekly?

    Etc, etc

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉