"ad" <a*@wfes.tcc.edu.tw> wrote in message news:OP5EAghqFHA.3544@TK2MSFTNGP15.phx.gbl...
>I use the statement below to backup my database
>
>        backup database Health to disk='c:\Health.bak'
>
> The size backup file Health.bak will increment every time when I perform the
> statement even I did not modify the database.
> For example, the first time after  I execute the backup statement,
> Health.back is 5M, the second time is 10M, the 3rd is 15M....
> If the size is to large, I must delete Health.bak.
>
> How can I  perform a new backup every time, so that I did not need to delete
> the file before backup?
>
>
>
>
>
>
>