Re: [BackupPC-users] periodically e2fsck the device /var/lib/backuppc

Why not ext4? works very well on my setup On Mon, Sep 7, 2009 at 1:04 PM, higuitahigu...@gmx.net wrote: Hi On Sun, 6 Sep 2009 08:17:42 -0500, Michael Stowe mst...@chicago.us.mensa.org wrote: By the way, what's the point of doing this?  Are your drives unreliable?        even worst... why

[BackupPC-users] Anecdote about backup of changing zip files

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a remote machine which backs up a MS SQL DB and automatically puts it into a dated zip file. I wrote a small script to move these files to another directory where the new filename would have a number 0 - - 6 for the 7 days of the week (so there

Re: [BackupPC-users] periodically e2fsck the device /var/lib/backuppc

On Mon, 7 Sep 2009 18:04:55 +1200, Michael michael.auckl...@gmail.com wrote: Why not ext4? works very well on my setup well, AFAIK, it also have a inode limit, but the max its too large to be a problem... yet, i dont know what default limit it have but the main

Re: [BackupPC-users] Using rsync for blockdevice-level synchronisation of BackupPC pools

On Sat, Sep 05, 2009 at 06:35:16PM -0600, dan wrote: [...] Thinking about the logistics in the method I have thought up a few hurdles. The source disks must remain unchanged during the entire sync. You would need to either have a spare disk in a raid1 mirror that you could remove from the

Re: [BackupPC-users] Tuning for disk contention

On Sat, Sep 05, 2009 at 06:52:35PM -0600, dan wrote: [...] You make a lot more sence here, but I think you overestimate CPU usage. backuppc is so IO bound that after your get a 2Ghz+ Dual core and 2GB RAM you can pretty much blame your disks for slow performance. I have a dual core 2Ghz

Re: [BackupPC-users] Anecdote about backup of changing zip files

Thanks for the stats on ZIPped MS-SQL db files - that has saved me doing some tests! I will eventually have to backup MS_SQL servers on 31 sites to a number of remote locations and so I am currently experimenting with a number of strategies. At the moment, I am backing up as follows: 1) A

Re: [BackupPC-users] Anecdote about backup of changing zip files

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey, it's a litle bit off-topic, but can someone post his steps how to get a dump of a MS SQL database? I have one DB here running with the Express version for one application and I'd like to back it up properly. Thanks, Christian Nigel Kendrick

Re: [BackupPC-users] Anecdote about backup of changing zip files

Nigel Kendrick wrote: Thanks for the stats on ZIPped MS-SQL db files - that has saved me doing some tests! I believe those stats use rsync -z which you can't do directly in backuppc. I will eventually have to backup MS_SQL servers on 31 sites to a number of remote locations and so I am

Re: [BackupPC-users] Anecdote about backup of changing zip files

I just use Volume Shadow Services to back up the whole thing at the file level -- neat, and consistent. Hey, it's a litle bit off-topic, but can someone post his steps how to get a dump of a MS SQL database? I have one DB here running with the Express version for one application and I'd

Re: [BackupPC-users] Anecdote about backup of changing zip files

Michael Stowe wrote: I just use Volume Shadow Services to back up the whole thing at the file level -- neat, and consistent. Do you stop the DB momentarily while making the shadow to make the files consistent? -- Les Mikesell lesmikes...@gmail.com

Re: [BackupPC-users] Anecdote about backup of changing zip files

It's not necessary, so I don't bother. (The Volume Shadow Copy Service notifies the SQL Server writer to quiesce its data stores, so I/O is stopped during shadow copy creation. It's automatic.) Do you stop the DB momentarily while making the shadow to make the files consistent? -- Les

Re: [BackupPC-users] Anecdote about backup of changing zip files

Michael Stowe wrote at about 12:55:34 -0500 on Monday, September 7, 2009: I just use Volume Shadow Services to back up the whole thing at the file level -- neat, and consistent. Hey, it's a litle bit off-topic, but can someone post his steps how to get a dump of a MS SQL

Re: [BackupPC-users] Anecdote about backup of changing zip files

Michael Stowe wrote at about 14:05:52 -0500 on Monday, September 7, 2009: It's not necessary, so I don't bother. (The Volume Shadow Copy Service notifies the SQL Server writer to quiesce its data stores, so I/O is stopped during shadow copy creation. It's automatic.) Do you stop

Re: [BackupPC-users] Anecdote about backup of changing zip files

But anyway, using VSS does not assure a stable database state. You would at least need to 'sync' (or stop) the database to ensure such a state. Now in practice, the database may be robust and you may just lose the last entry but taking a VSS is not a recommended method. Microsoft recommends

Re: [BackupPC-users] Anecdote about backup of changing zip files

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Les Mikesell wrote: Nigel Kendrick wrote: Thanks for the stats on ZIPped MS-SQL db files - that has saved me doing some tests! I believe those stats use rsync -z which you can't do directly in backuppc. Sorry, I should have mentioned the reason

Re: [BackupPC-users] Anecdote about backup of changing zip files

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nigel Kendrick wrote: Our 700MB .bak files ZIP down to around 130MB and I was wondering whether it would be worth taking this offsite, but it may be that syncing the raw dumps may be quicker. In my case it is definitely quicker... 550MB approx

Re: [BackupPC-users] Anecdote about backup of changing zip files

Michael Stowe wrote at about 16:37:36 -0500 on Monday, September 7, 2009: If you care to get your technical information from Microsoft rather than conjecture, there's considerable detail available here: http://technet.microsoft.com/en-us/library/cc966520.aspx If you care to know that