Post reply

Backup Diferencial Muy Grande

  • July 17, 2007 at 5:29 pm

    #124918

    Buenas tardes,

    Tengo un dilema con el crecimiento repentino de nuestro Backup Diferencial que se realiza al cierre de cada día.

    Les comento que no se han hecho cambios, ni en la estructura, ni en las operaciones del aplicativo, ni mucho menos hemos crecido en usuarios.

    Normalmente nosotros realizamos nuestro Full Backup los días Domingos y diariamente se realiza los Backup Diferenciales.

    Lo normal era que nuestro Full Backup pese 34 GB mas o menos y sus diferenciales entre 2.5 y 3.0 GB.

    La semana pasada hubieron 2 días que se realizó el Backup Diferencial y este creció enormente llegó a 27 GB, lo primero que viene a la mente que alguien ejecuto algún proceso en batch y generó el crecimiento del LOG, bueno ese mismo día en lugar de realizar el Diferencial se realizó un Full Backup y al día siguiente se realizó el Diferencial y todo regresó a su normalidad 2.7 GB.

    El dia Domingo tocó realizar el Full Backup todo normal hasta que el día Lunes al realizar el Diferencial este nuevamente llegó a los 27 GB, como les vuelvo a mencionar se monitoreo el Servidor y además no se realizaron operaciones en batch y mucho menos crecimos en usuarios. Lo extraño es que creció tanto como si fuera un Full Backup.

    Si alguién me puede ayudar con este dilema se lo agradecería.

    Saludos cordiales,

    Luis Lozada

  • July 17, 2007 at 11:37 pm

    #720263

    Can you post this in English please?

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 17, 2007 at 11:47 pm

    #720266

    If you take a full backup once per week, let's say on Sunday, and daily differentials, then your Saturday differential may grow as big as your next Sunday backup; your daily differential gets data between Sunday and the moment you take the differential.

    Hope I understood well your problem, however as Sugesh said before, try to write in English even that would not be perfect.

     

  • July 18, 2007 at 8:03 am

    #720371

    Good afternoon,
    I have a dilemma with the sudden growth of our Backup Differential that is made to the closing of every day. Them comment that have not become changes, neither in the structure, nor in the operations of the applications, we have not grown either in users.
    Normally we made our Full Backup the days Sundays and daily the Backup is made Differentials. The normal thing was that our Full Backup weighs 34 GB more or less and its differentials between 2,5 and 3,0 GB.
    The last week there were 2 days that were made the Backup Differential and this it grew enormously arrived at 27 GB, first that comes to the mind that somebody I execute some process in batch and generated the growth of the LOG, good that same day instead of making the Differential a Full Backup was made and on the following day the Differential was made and everything returned to its normality 2,7 GB.
    The sunday was made the Full Backup, all normal one until the day Monday when making the Differential this one arrived again at the 27 GB. As I return to them to mention who the Server was reviewed and in addition operations were not made in batch and much less we grew in users. The stranger is that the Differential grew as much as if outside a Full Backup. If somebody can help me with this dilemma it would thank for it.
     
    Greetings,
     
    Luis Lozada
     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply