Why the Backup files double its size

[Xaplytz]

I make my own backups pointed to a file in the hard disk , I do it by code, it works ok. But when I run the second time the size of the file get double
If I run third time get triple.

Sample :
Line of code
backup database <dbname> to disk = “c:\sqlbackup\test.bck”

run the 1st time
C:\sqlbackup\test.bck size 10 Mb

2nd
C:\sqlbackup\test.bck size 20 Mb

3rd
C:\sqlbackup\test.bck size 30 Mb


To avoid this, I take the date as file name, this way will be a different file and the size doesn't get double.

But I would like to know if there were other way to use the same file name without double the size.
thank


[sig][/sig]

 

[karluk]

From your description of what's happening it's not at all obvious that anything is wrong. The second and third backup could very easily be appending to the end of the file, instead of overwriting it. That would explain the file sizes that you are seeing. [sig][/sig]