Posted by Shuurai on 12/20/06 21:38

gabe101 wrote:
> Yes, this is a response to my own response...
>
> ;-)
>
> gabe101 wrote:
>
> > > Try backing up over the wire to a UNC share on another machine. You are
> > > almost definitely stressing the disk I/O system on this box.
> > >
> > > A backup on the same machine won't do you much good if say the RAID
> > > controller fails.
> >
> > I sheepishly have to admit my inexperience again and say that this
> > makes perfect sense. We are currently saving the noon backup on the
> > same system and I'll save the BAK file to another box starting now.
> > Thanks.
>
> I suddenly have a reason for concern...
>
> I transferred our existing 'Noon' backup file accross the network to
> the share on another box. It took 8 minutes and 17 seconds and the
> backup write process only takes between 3 and 4 minutes. Is this going
> to cause a problem when the server is doing the backup and transferring
> at the same time? Is it actually going to write to temporary location
> on the server before making the transfer anyway? If so, that would
> defeat the purpose for transferring to the other box. Again, any input
> is appreciated.

Depends on your network of course but it doesn't surprise me that
sending a large file over a network would take longer than the local
backup, especially during the day. Have you considered getting a tape
drive to do your backups - they're not all that expensive, certainly a
lot cheaper than losing your data would be :)

Also, as someone else mentioned, consider doing a differential backup
during the day rather than the full backup. It's just one more step if
you need to restore, and it should be much smaller and faster than your
full backup.

[Back to original message]