The blog runs on MSDE, which is the "desktop" version of SQL Server (and the predecessor to SQL Server Express). I run a backup every night, and to back up the blog database, I use a command like this:BACKUP DATABASE blog TO DISK = 'c:\blog_bu\dayofweek\blog.dat_bak'
So of course I have 7 backups at any given time. I was looking at my disk stats on the server today and noticed that I seemed to be running a bit low on disk space. I looked through the drive to see where all that space was going, and I noticed that the backup files for the blog database were huge -- like, 2.5 GB each. (And that times 7.)
Long story short, the backup command I've been using appends to the backup file. Every time I back up, the backup files are getting bigger. The solution (a solution) is to add the INIT option to the command, like this:BACKUP DATABASE blog TO DISK = 'c:\blog_bu\dayofweek\blog.dat_bak' WITH INIT
Much better -- the backup is now in the neighborhood of 35 MB. Whew.
|
