Home Forums SQL Server 2008 SQL Server 2008 - General point-in-time restore of a database requirements RE: point-in-time restore of a database requirements

  • January 16, 2013 at 2:12 am

    #1577704

    Full backup with copy only can be used for a PIT recovery.

    A copy only full backup, cannot serve as a base for differential restores.

    Restore a Full backup with copy only -> Restore a differential = FAIL

    Restore a Full backup without copy only -> Restore a differential = SUCCESS

    Restore a Full backup with copy only -> Restore a transaction log = SUCCESS

    Restore a Full backup without copy only -> Restore a transaction log = SUCCESS