[Box Backup] Restore & Compare Issue ** UPDATE **

[Chris Wilson]

Hi Matt,

On Tue, 24 Apr 2007, Matt Brown wrote:

> Well I ran the command and this was what was returned:
>
> root@io:/tmp# dd if=/dev/zero of=/tmp/bigfile bs=1M count=4k
> 4096+0 records in
> 4096+0 records out
> 4294967296 bytes (4.3 GB) copied, 60.7408 seconds, 70.7 MB/s

OK, so it's not a problem storing 4 GB files on your /tmp drive. It must 
be a bug in Box Backup restore, as far as I can tell. I will investigate 
as soon as I have time.

> In relation to the rsync of the actual file(s), the only way we are able 
> to do that is if the Server that is running SQL Server 2005 (I am no 
> windows expert, this is second hand) is told to disconnect the Database 
> so we can rsync the actual SQL DB File(s) and then reconnect to it again 
> afterwards - however because this is in a cluster environment, I am told 
> the SQL Server would think SQL Server has failed or stopped and would 
> fall over to the other SQL Server :( - therefore an automated backup is 
> preformed each night using SQL Server or NT Backup to create this one 
> large file - once this has been created we simply use Rsync to shift it 
> over to the storage array.

How about not gzipping the file before transferring it, and turning of 
compression in MS Backup?

> In addition, I was under the assumption that BB will use available 
> soft/hard space available on the server and once this is close to full 
> housekeeping would free up space. Currently we are only keeping about 7 
> days of backups of this file offsite - we have 3 months + in house if we 
> needed to roll back plus transaction logs.

Yes, this is true, but you would be able to store a lot more history on 
the Box Backup server if the diffs were smaller. The best way to achieve 
this is to back up uncompressed files, as far as I know (especially if 
they are large files which change regularly, which seems to be the case 
here).

Cheers, Chris.
-- 
_____ __     _
\  __/ / ,__(_)_  | Chris Wilson <0000 at qwirx.com> - Cambs UK |
/ (_/ ,\/ _/ /_ \ | Security/C/C++/Java/Perl/SQL/HTML Developer |
\ _/_/_/_//_/___/ | We are GNU-free your mind-and your software |