I am running SBS2003 Standard Edition SP2. My network is very small - just three clients. One part of my backup strategy is daily backups of SBS using the built-in backup software to a Dell removable hard drive. The problem is that these daily files are too large (about 22GB). I can longer fit five of these files, along with my file backups (roughly 65GB using BackUp Exec) on one removable hard drive.
I have moved the WSUS 3.0 files (roughly 12GB worth) on another partition using wsusutil.exe. I checked my C drive and found the SUSDB.mdf file that is 5.2GB in size. If I understand correctly, this one file is almost 25% of my daily backups. I have read that this database file can be re-indexed/compacted to less than half this size. I do not understand the instructions in the other posts well enough to implement them.
If I could reduce this one file down to 2.5GB in size, for instance, it would reduce my backup space requirements by 13GB. This would be a HUGE help in my media rotation plan.
Note: I do not have SQL Server Management Studio Express installed on this server. If you think I need it, please provide a link to the correct version.
Also, besides shrinking the file, is there some way I can tell the SBS backup utility to simply skip the file? My idea is that I have one scheduled event for Mondays when I do a full backup including SUSDB.mdf. Then a second scheduled event for Tues/Wed/Thur/Frid backs up SBS while skipping the one file. This could save another 10GB or more. Or would this mess me up if I ever needed to run a restore?
Thanks so much!