Post reply

Missing the obvious on a full backup?

  • August 20, 2005 at 9:05 am

    #109892

    My nightly full backup just tripled in size (no real increase in data or log space though); using full recovery model.

    What am I missing?

     

  • August 20, 2005 at 10:07 am

    #583755

    looks like you're appending to the previous backup instead of overwriting it!!! - that's where I would look first!







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 20, 2005 at 11:19 am

    #583757

    Sushila,

    My backup script, which I have used at a variety of sites, deletes the existing BAK file and then performs the Backup on the database.  My normal BAK size is 100 GB and overnight it became 300 GB.  I don't recall observing this type of behavior before.  Is there something else on the append that I am missing?

  • August 20, 2005 at 11:28 am

    #583760

    I'm going by personal experience....I had a scheduled backup that ran just fine for over 6 months before suddenly deciding to (most mysteriously I may add) start appending...

    does your backup script include the format or init clause ?! If it does, then I'm afraid I'm out of ideas...







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 20, 2005 at 12:17 pm

    #583765

    Guess I am missing something.  The BACKUP DATABASE portion of my script does not use either INIT or FORMAT.  The first step is an xp_cmdshell to delete the existing backup....  BTW, this happend two night in a row, then the BAK size return to what had been previously.

    Thanks for the feedback...

     

     

  • August 20, 2005 at 12:31 pm

    #583766

    oh - didn't realize from your first post that the file size has reverted back to normal!

    next time (hopefully there won't be one) you may want to post your script - I'm sure someone will be able to come up with a solution faster if they have the script in front of them...

    guess all's well that ends well!







    **ASCII stupid question, get a stupid ANSI !!!**

  • August 20, 2005 at 4:22 pm

    #583770

    You're right on target.  I should have posted the script and will for any future such posts.

    Thanks again...

  • August 22, 2005 at 7:53 am

    #583898

    Look through the Windows Event Viewer logs for any related error messages. Also, how are the job steps set up for if they fail? If the first step (deleting the previous backup), does it continue or quit?

    I'm thinking the delete portion might be failing and the job continues to the next step.

    -SQLBill

  • August 22, 2005 at 9:17 pm

    #584131

    I confirmed today that the delete was indeed failing.  

Viewing 9 posts - 1 through 8 (of 8 total)

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