Backup Suggestions

Posted by Steve on February 7, 2007, 3:59 pm

Please log in for more thread options

I got my first wakeup call to take seriously the daily backing up of our
databases; luckily I dodged a bullet this time. I have 1 HQ and 2 SO's.
Does anybody have any suggestions what kind of hardware that I should buy to
start doing so...preferably a cost-effective solution. Thanks for any
feedback.

Posted by Terrible Tom on February 7, 2007, 8:08 pm

Please log in for more thread options

I use a batch file to backup the database to a folder C:RMS Backup. You can
search the google archive of this group for the code. It seems to work
great. Creates a rolling 3-day archive. Very handy.

I back up to DVD. A DVD-RW drive is cheap. I use NTI's Backup NOW! (cheap
- like $49 or so) for unattended backups.

Tom
--
Stop fishing for e-mail

"Steve" wrote:

> I got my first wakeup call to take seriously the daily backing up of our

> databases; luckily I dodged a bullet this time. I have 1 HQ and 2 SO's.

> Does anybody have any suggestions what kind of hardware that I should buy to

> start doing so...preferably a cost-effective solution. Thanks for any

> feedback.

Posted by Mickie on February 8, 2007, 1:08 pm

Please log in for more thread options

Cheap--you said it.

I USED to use that until we had a hard drive crash on our server.
the incremental backups are REQUIRED to recreate the drive.

One was corrupted or something happened while it was in process.

So, we could not recover the data. I was able to pick pieces off the
original full backup but I was REALLY mad and will never ise NTI again.

I was backing up to DVDs.

mickie

"Terrible Tom" wrote:

> I use a batch file to backup the database to a folder C:RMS Backup. You can

> search the google archive of this group for the code. It seems to work

> great. Creates a rolling 3-day archive. Very handy.

> I back up to DVD. A DVD-RW drive is cheap. I use NTI's Backup NOW! (cheap

> - like $49 or so) for unattended backups.

> Tom

> --

> Stop fishing for e-mail

> "Steve" wrote:

> > I got my first wakeup call to take seriously the daily backing up of our

> > databases; luckily I dodged a bullet this time. I have 1 HQ and 2 SO's.

> > Does anybody have any suggestions what kind of hardware that I should buy to

> > start doing so...preferably a cost-effective solution. Thanks for any

> > feedback.

> >

Posted by Jeff @ Check Point Software on February 7, 2007, 11:10 pm

Please log in for more thread options

: quoted-printable

Steve,

How serious are you? ;-)

A lot depends on your equipment and Operating System.

First, all of our database servers we sell have RAID in them, from RAID1 =
to RAID5.

Second, we use internally and sell Symantec's Norton Ghost for XP =
systems and Backup Exec System Recovery Windows Small Business Server =
Edition (careful when you order as they have other products named =
similarly) products backing up to a hard drive in a hot swappable, =
removable caddy, every hour. =20

In addition, we backup the database(s) using a background script to the =
main hard drive, again every hour, just before the main backup so the =
database backups get backed up onto the removable drive. The removable =
drive gets replaced daily to weekly (depending on if they remember!) It =
can hold multiple full drive backups and a bunch of incrementals =
depending on the size of the hard drive you use (up to 750GB)

Worst case scenario is our customer(s) would lose ~55 minutes of info.

BTW, it takes about an hour to bring a system back up in the event of =
complete failure of the RAID drives, operating system, all programs and =
data files, back to where it was with the last hourly backup! ;-)

Cost ~$70 for Ghost, ~$50 for the removable caddy and cage, ~$30 for a =
second caddy, ~$60 - $375 x 2 or more hard drives. Backup Exec Recovery =
SBS is ~ $1100

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

I got my first wakeup call to take seriously the daily backing up of =
our=20
databases; luckily I dodged a bullet this time. I have 1 HQ and 2 =
SO's.=20
Does anybody have any suggestions what kind of hardware that I should =
buy to=20
start doing so...preferably a cost-effective solution. Thanks for any =

feedback.=20

------=_NextPart_000_06D8_01C74AF4.14A9DAA0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Steve,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>How serious are you? ;-)</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>A lot depends on your equipment and Operating =

System.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>First, all of our database servers we sell =
have RAID in=20
them, from RAID1 to RAID5.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Second, we use internally and sell Symantec's =
Norton=20
Ghost for XP systems and Backup Exec System Recovery =
Windows Small=20
Business Server Edition (careful when you order as they have other =
products=20
named similarly) products backing up to a hard drive in a hot swappable, =

removable caddy, every hour.  </FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>In addition, we backup the database(s) using =
a=20
background script to the main hard drive, again every hour, just before=20
the main backup so the database backups get backed up onto the =
removable=20
drive.  The removable drive gets replaced daily to weekly =
(depending on if=20
they remember!)  It can hold multiple full drive backups and a =
bunch of=20
incrementals depending on the size of the hard drive you use (up to=20
750GB)</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Worst case scenario is our customer(s) would =
lose ~55=20
minutes of info.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>BTW, it takes about an hour to bring a system =
back up=20
in the event of complete failure of the RAID drives, operating system, =
all=20
programs and data files, back to where it was with the last hourly =
backup!=20
;-)</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Cost ~$70 for Ghost, ~$50 for the removable =
caddy and=20
cage, ~$30 for a second caddy, ~$60 - $375 x 2 or more hard =
drives. =20
Backup Exec Recovery SBS is ~ $1100</FONT></DIV>
<DIV><FONT color=3D#008000></FONT><FONT color=3D#008000></FONT><BR>-- =
<BR><BR>Jeff=20
<BR>Check Point Software</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Steve" <<A=20
message=20
<A=20
=
@TK2MSFTNGP04.phx.gbl</A>...</DIV>I=20
got my first wakeup call to take seriously the daily backing up of our =

<BR>databases; luckily I dodged a bullet this time.  I have 1 HQ =
and 2=20
SO's. <BR>Does anybody have any suggestions what kind of hardware that =
I=20
should buy to <BR>start doing so...preferably a cost-effective =
solution. =20
Thanks for any <BR>feedback. <BR><BR></BLOCKQUOTE></BODY></HTML>

------=

Posted by ElBorba on February 9, 2007, 1:56 pm

Please log in for more thread options

I would also point out that for a comprehensive DR program there
should definitely be some form of off-site storage.

Previously we were backing up to tape on a nightly basis and have even
been sending our nightly backups to Iron Mountain for storage. This
is of course partly due to the fact that a large portion of our data
was also internal accounting information. Once you spend a couple of
years (or even a couple of weeks) humping tapes around, forgetting to
swap them out, and generally being annoyed by the process, you start
looking at backing up via the network. We currently are using evault
which isn't cheap, per se, but your data is always available, they
handle all the incrementing, and if you have to you can recover it
from anywhere in the world.

Again, it's not the apex of penny pinching but if you have a few bucks
to throw at it every month it will make your life a lot easier. I
haven't worked with any of the other online backup companies but I
have been very happy with evault's customer service and
responsiveness. They seem to be both reliable and professional.