Home Forums SQL Server 2005 Backups Backup policy for 2 TB database (Interview perspective) RE: Backup policy for 2 TB database (Interview perspective)

  • catchmekiran (11/28/2012)


    Backup policy for a 2 TB database.....

    what would you recommend exactly and why for each day of the week. what you would do daily, weekly and monthly.

    Not enough information. Would need to know at least:

    RPO and RTO

    Maintenance window

    Backup retention policies

    Available storage space

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass