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

  • November 28, 2012 at 1:46 pm

    #1563433

    catchmekiran (11/28/2012)

    Could you please say in general

    There's no 'general' solution to backing up a 2 TB database.

    General: Backup often enough that you will be able to restore to meet your RPO, backup so that your restore sequence will worst case meet your RTO, and make sure that everything fits into the acceptable maintenance windows.

    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