Re: [BackupPC-users] Anyone with experience of MS-SQL database dumps?

2009-09-05 Thread dan
On Sun, Aug 30, 2009 at 2:13 PM, Jeffrey J. Kosowsky wrote: > dan wrote at about 14:00:43 -0600 on Sunday, August 30, 2009: > > I personally think that using ssh compression is the better method. I > say > > this because running rsync through ssh encrypts the data and compresses > > it(optiona

Re: [BackupPC-users] Anyone with experience of MS-SQL database dumps?

2009-08-30 Thread Jeffrey J. Kosowsky
dan wrote at about 14:00:43 -0600 on Sunday, August 30, 2009: > I personally think that using ssh compression is the better method. I say > this because running rsync through ssh encrypts the data and compresses > it(optionally). Unless you plan to run rsync in the clear then the built in > c

Re: [BackupPC-users] Anyone with experience of MS-SQL database dumps?

2009-08-30 Thread dan
I personally think that using ssh compression is the better method. I say this because running rsync through ssh encrypts the data and compresses it(optionally). Unless you plan to run rsync in the clear then the built in compression isnt needed. On Sat, Aug 29, 2009 at 11:36 PM, Jeffrey J. Kos

Re: [BackupPC-users] Anyone with experience of MS-SQL database dumps?

2009-08-29 Thread Jeffrey J. Kosowsky
Les Mikesell wrote at about 07:37:07 -0500 on Tuesday, August 25, 2009: > Nigel Kendrick wrote: > > Hi, > > > > This may also be applicable to MySQL etc.. > > > > I have an MS-SQL database that dumps out a backup that's around 700MB in > > size. BackupPC brought this over to its server

Re: [BackupPC-users] Anyone with experience of MS-SQL database dumps?

2009-08-28 Thread dan
Because this is a dump, a small change in a record near the beginning of the sort would cause the whole file to be a different structure. If you can influence the sort process for the dump and do it by date that the record was updated then you wouldnt likely have this issue. example (csv formated)

Re: [BackupPC-users] Anyone with experience of MS-SQL database dumps?

2009-08-25 Thread Les Mikesell
Nigel Kendrick wrote: > Hi, > > This may also be applicable to MySQL etc.. > > I have an MS-SQL database that dumps out a backup that's around 700MB in > size. BackupPC brought this over to its server via ADSL/VPN/Rsyncd > (422mins!) and when I did another data dump about 4 hours later, aroun

[BackupPC-users] Anyone with experience of MS-SQL database dumps?

2009-08-25 Thread Nigel Kendrick
Hi, This may also be applicable to MySQL etc.. I have an MS-SQL database that dumps out a backup that's around 700MB in size. BackupPC brought this over to its server via ADSL/VPN/Rsyncd (422mins!) and when I did another data dump about 4 hours later, around 16Mb of changes to the file were tra