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!

    I know I am "learning_sql" but is your backup drive the spindle which houses your database (and or transaction log) backups - what backup strategy do you employ

    -- how large is 1 of your backup sets today?

    -- how much space have you got on your drive in total ?

    -- how much is remaining?