I recently changed backup servers, so im starting from scratch on the pool with a new machine. Ive configured it just like the old one and i have the old one around to compare from.
the problem i am having is that the backups on the new machine are ALOT smaller than on the first. the client has some large 7gig+ sql databases that take forever to backup over the wan. they finished in one night (compared to almost a week on the old machine) on the old server the host summary shows 13.21gb and on the new server the same full backup says its only 4.52gb. so i went to the console on each machine and did a du -sh on each server for the /var/lib/backuppc/pc/machine and on the old server the dir was 9.5gb and the new one its 5.2gb. so then i went to the actual machine and looked up the size of the actual db on the machine. the size on the actual clients machine is 5.6bg for one db. when i browse the backups in the web interface, i browsed to where the db is: /mssql/data/db.mdf and tried to download/restore that file and it saved a 768kb file. not the 5.6gb db file, but the name was correct, but size is drastically off. this has be really concerned that the backups arent working the way they are suppose to. its a new server there are no files in the pool, the backups are taking WAY less time then they should and trying to restore a file the size is WAY off. in the host summary under that backup client, the "new files" says size 4427.8 comp/mb 777.0 comp 82.5% thats a heck of a compression ratio. i know that sql dbs can compress down nicely, but im comparing to the old server and its not the same. the first full backup on the old server was size 13119.9 comp/mb 6248.3 comp 52.4% and nothing has changed on the client machine. so something isnt doing right. and the fact that when i restore one of their large db files its only 768kb instead of the 5.6gb its suppose to be. Where can i start to look and see what the problem was? ive checked the logs on the server and client and there are no errors, the backup says it completed successfully. what else can i do/check? this has really got me worried. thanks for any help you can give. ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ BackupPC-users mailing list [email protected] List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
