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

navedjobs · #1 (**permalink**) 01-18-12, 09:51

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 ?

MCrowley · #2 (**permalink**) 01-18-12, 11:58

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.

Brett Kaiser · #3 (**permalink**) 01-18-12, 12:59

Code:

BACKUP DATABASE [<dbname>] 
 	TO DISK = N'\\<fp>\<fn>.BAK' 	
	  WITH NOFORMAT, INIT,  NAME = N'<db Desc>', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

Internet Services

Web Development

Digital Marketing

Consumer Tech