Re: [BackupPC-users] Anecdote about backup of changing zip files
2009-09-07 12:01:12
-----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 wrote:
>
> 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 nightly scheduled batch file runs SQL scripts to dump the tables by
> calling a stored procedure
>
> Backups are called backup_tablename_dayofweek.bak (eg:
> backup_testdb_wed.bak)
>
> 2) The .bak file is renamed to backup_tablename.bak to create a daily
> generic backup file which is synced off-site by BackupPC
>
> 3) The .bak file is ZIPped to !B_tablename_dayofweek.zip (eg:
> !B_testdb_Wed.zip) and this is left in the backup folder as a local copy.
> BackupPC is set to ignore files that start !B* so these files are not copied
> offsite but are kept for a week until overwritten.
>
> It's not easy to determine actual backup speed and performance yet because
> we have only rolled out the new app on two sites, and the devs are messing
> around with the database schema so a lot of the data in the .bak file is
> changing between backups. During initial testing (when things were not being
> changed so much), a daily sync of a 700MB database was taking around 20-40
> minutes, albeit across an old 512K ADSL (VPN) line with an upload speed of
> 288Kbit/sec. I have just upgraded this to an LLU service that's currently
> running at 5.5Mbit down, 883Kbit up and will be seeing what improvement this
> gives.
>
> 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.
>
> Nigel
>
>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> _______________________________________________
> 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/
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with CentOS - http://enigmail.mozdev.org/
iD8DBQFKpS1w0XNIYlAXmzsRAtQJAKDconkj6kYS9Z1GnYJc1xj6Vl2K7wCeMPU7
p9bI6QKfJOUKTDMN348RDjc=
=jO4s
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
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/
|
|
|