September 8, 2005 at 3:32 am
Hello all,
I have a database which size is around 15GB as full backup file. Still my nightly full backup creates dumps from 15GB to even over 70GB. I thought that this is because of the application that does not commit transactions and log would grow, but log file is less than 1 GB. What could cause these huge backup files?
With thanks beforehand,
Jyrki
September 8, 2005 at 9:02 am
Sounds as though you're using "Append to Media" instead of "Overwrite Media". Perhaps you can post your actual backup statement.
September 8, 2005 at 10:50 pm
I am simply using,
BACKUP DATABASE DBNAME TO DEVICE_001.
I am using SQL server 2000 with SP3.
September 9, 2005 at 7:05 am
Then you are appending your backups. WITH NOINIT is the default and causes the backups to append. WITH INIT overwrites the previous backup.
-SQLBill
September 13, 2005 at 3:33 am
Many thanks to you SQLBill.
Jyrki
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply