Backup file huge compared to data files 1

[HellTel]

Hi all, long time no post

Done a search but can't find the solution so fingers crossed...
I have a small SQL Server 2000 database, only 2MB MDF and 2MB LDF files but my nightly backup is 318MB!

any clues please?

Thanks
Terry

p.s. I actually have two of these DB's acting the same.

 

[RobertT687]

Is the nightly backup being appended to the backup file? The backup command needs the /INIT parameter to start a new file.

 

[HellTel]

Sorry for the delay, one of those weeks!
Anyway, I can't believe I was such a putz! That was of course the correct answer. I have another 8 or 9 db's all backing up with the WITH INIT command and these two were set to WITH NOINIT.
Amazing how you can miss the blindingly obvious sometimes isn't it

Thanks for your help.
Terry

Hope I helped / Thanks for helping
if ((Math.abs(x)<10&&Math.abs<10) && (((parseInt(Math.abs(x).toString()+Math.abs.toString())-Math.abs(x)-Math.abs)%9)!=0)) {alert(&quot;I'm a monkey's uncle&quot;}