Welcome to Sign in | Help

Re: Backup diferential

  •  06-25-2009, 12:53 PM

    Re: Backup diferential

    maneaflorin@hotmail.com:


    In caz ca imi pica joi, ora 15.00, restaurarea vine asa:

      1. restaurez backup full (si bifez Leave database nonoperational but able to restore aditional tr logs)
      2. differentialul de miercuri noapte
      3. log-ul de la ora 8
      4. log-ul de la ora 12.00 si am trei ore de date pierdute.


    Corect.

    Dar totdeauna incepi, dupa un crash, incercind  un tail log backup. In felul asta poti recupera si cele 3 ore 'pierdute'.
    Eu in general recomand LOG backup des, la fiecare 30 de minute sau si mai des (10-15 min).

    http://rusanu.com
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems