I just started doing this and confused why the backup grows by a gig plus a day...
I really don't need incrementals and it's not set as that, its just a backup of helpdesk tickets...
I only want an overwrite every night. I assume its the transaction logs?
I read something about adding INIT?
ANy way this is what I have if anyone see's ssomething odd??
BACKUP DATABASE [servicedesk] TO DISK = N'D:\SQLBackup\servicedesk-nightly.bak' WITH NOFORMAT, NOINIT, NAME = N'servicedesk-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10