Post reply

.BAK keeps getting bigger

  • May 22, 2008 at 1:51 pm

    #380664

    I have SQL Server 2005 DB. I use the SQL Server Managment Studio to create a .BAK. When does the .BAK keep getting bigger? When I restore it on another server, I see several .BAKs in the file. How do I only get the latest .BAK and not the many others that seem to be accumulating in the .BAK.

    Thanks!

  • May 22, 2008 at 1:58 pm

    #819364

    if you are backing up to a file or device of the same name ensure you tick the box to overwrite the backup rather than append.

    This will of course mean you only have one backup on disk so be sure this suits your needs. You may be better off setting up a maintenance plan anfdkeeping a few days worth as seperate .bak files

    ---------------------------------------------------------------------

  • May 22, 2008 at 2:05 pm

    #819368

    ofcourse if u left the deafult option for the backup the fill will get bigger cos it will use append.

    any way u can create to jobs one to run every day with append option, and a second one the overwrite option which will wirte over the file. but the file size would be as

    (backup file size) for one day* 6

    ..>>..

    MobashA

  • May 23, 2008 at 10:36 am

    #819813

    Thank you. You answered my question.

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

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