Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    47

    Unanswered: .bak size increase each time you replace the .bak with new .bak ?

    when ever i take backup of my database called bms from my application
    while dong back up the back up ends up in replaceing the old backup copy of similar date but the size of .bak file increases each time it gets backed-up
    so for eg
    if you do back up no.1 size of .bak is 1.73
    back up no.2 ends up in replacing previous .bak file and grows by 1.73*2 = whatever
    why so , and how to control that ?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The backups default to appending. If you were to run
    Code:
    restore headeronly from disk = 'your filename here
    you would see entries for each backup taken. Add WITH INIT to the end of your backup command, and the backup will be overwritten.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Code:
    BACKUP DATABASE [<dbname>] 
     	TO DISK = N'\\<fp>\<fn>.BAK' 	
    	  WITH NOFORMAT, INIT,  NAME = N'<db Desc>', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
    GO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •