BackupPC-users

[BackupPC-users] backup size confusion

2009-01-22 08:38:00
Subject: [BackupPC-users] backup size confusion
From: Nick Smith <nick.smith79 AT gmail DOT com>
To: "General list for user discussion, questions and support" <backuppc-users AT lists.sourceforge DOT net>
Date: Thu, 22 Jan 2009 08:35:51 -0500
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
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/

<Prev in Thread] Current Thread [Next in Thread>