BackupPC-users

Re: [BackupPC-users] how does backuppc handle DBs

2009-02-06 21:30:28
Subject: Re: [BackupPC-users] how does backuppc handle DBs
From: Nick Smith <nick.smith79 AT gmail DOT com>
To: backuppc-users AT lists.sourceforge DOT net
Date: Fri, 6 Feb 2009 21:28:27 -0500
On Fri, Feb 6, 2009 at 9:09 PM, Nick Smith <nick.smith79 AT gmail DOT com> 
wrote:
> I have a couple clients backup nightly over the internet.
> I seem to be doubting if the backups are actually being completed 
> successfully.
> Backuppc tells me they are, but the reason im questioning is because
> it is suppose
> to backup 10gigs a night (their sql db changes daily) and backup
> completes in 40mins
> over a max connection of 600kb.  The backup results do say its getting
> about 50%
> compression and the backup is only 5gigs when it complete.
>
> How does backuppc handle databases? does it take just whats changed or if the 
> DB
> changes does it have to backup the entire thing again?
>
> ive gotten 14 complete full backups (one a day) and they all have the
> same results
> completed successfully and are about 10gigs before compression and pooling.
>
> its there a way i can make sure that things are working as planned?
>
> i mean without doing a restore and testing what its backing up.
>
> i just dont want to think im getting good backups when im really not.
>
> im using scripts that use volume shadow to get backups of their windows 
> servers
> after hours.
>
> it just seems like the backups are going way to fast with the speed of
> the connection
> and the size of the data.
>
> thanks for any light you can shed on the subject.
>
and to add to my own post im doing these backups over a pfsense
firewall on both sides and the stats for the last 4 hours
(when the 10gig backup was supposedly preformed), the output
transmitted on the WAN was only 50megs. so something
isnt working correctly here.

------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
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/