Backup Suggestions

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. 


0
steve972 (3)
2/7/2007 8:59:54 PM
pos 14173 articles. 0 followers. Follow

9 Replies
212 Views

Similar Articles

[PageSpeed] 24

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. 
> 
> 
> 
0
tomg2938 (389)
2/8/2007 1:08:00 AM
This is a multi-part message in MIME format.

------=_NextPart_000_06D8_01C74AF4.14A9DAA0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 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

  "Steve" <steve972@gmail.com> wrote in message =
news:eKmOsrvSHHA.4028@TK2MSFTNGP04.phx.gbl...
  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>&nbsp;</DIV>
<DIV><FONT color=3D#008000>How serious are you? ;-)</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>A lot depends on your equipment and Operating =

System.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Second, we use internally and sell Symantec's =
Norton=20
Ghost for XP systems and&nbsp;Backup Exec System Recovery =
Windows&nbsp;Small=20
Business Server Edition&nbsp;(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.&nbsp; </FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</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&nbsp;main backup so the database backups get backed up onto the =
removable=20
drive.&nbsp; The removable drive gets replaced daily to weekly =
(depending on if=20
they remember!)&nbsp; 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>&nbsp;</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>&nbsp;</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>&nbsp;</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&nbsp;hard =
drives.&nbsp;=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>&nbsp;</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>&nbsp;</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).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</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" &lt;<A=20
  href=3D"mailto:steve972@gmail.com">steve972@gmail.com</A>&gt; wrote in =
message=20
  <A=20
  =
href=3D"news:eKmOsrvSHHA.4028@TK2MSFTNGP04.phx.gbl">news:eKmOsrvSHHA.4028=
@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.&nbsp; 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.&nbsp;=20
  Thanks for any <BR>feedback. <BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_06D8_01C74AF4.14A9DAA0--

0
cptsoft (1248)
2/8/2007 4:10:58 AM
I found a low cost solution for backups. The prices of external drives 
are very low. I got a 500gb drive for less than $200. I have 2 of these 
on my server. One backs up during the day and one at night. Within each 
of these drives I have a folder for each day. I now have a back up to go 
back 1 week and have 2 sources of information. I also have the same 
configuration on all of my PC's. I also have an external backup on each 
register that contains all of the software, updates and drivers 
necessary for a re-install.
I did not buy any software, I just use the windows software. Works great.

Jay

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. 
> 
> 
0
2/8/2007 12:18:13 PM
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. 
> > 
> > 
> > 
0
mickie (104)
2/8/2007 6:08:01 PM
I also back up to an external harddrive using a script for daily backups 
after we close. I also have Ghost installed(because of Jeffs 
recommendation)and have it set to run at midnight everyday. Not quite as 
good as backing up every hour, but it has worked for us.
Craig

"Jay" <jay.lindner@pobox.com> wrote in message 
news:O81h$t3SHHA.2256@TK2MSFTNGP02.phx.gbl...
>I found a low cost solution for backups. The prices of external drives are 
>very low. I got a 500gb drive for less than $200. I have 2 of these on my 
>server. One backs up during the day and one at night. Within each of these 
>drives I have a folder for each day. I now have a back up to go back 1 week 
>and have 2 sources of information. I also have the same configuration on 
>all of my PC's. I also have an external backup on each register that 
>contains all of the software, updates and drivers necessary for a 
>re-install.
> I did not buy any software, I just use the windows software. Works great.
>
> Jay
>
> 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. 


0
craig6967 (916)
2/8/2007 10:35:46 PM
What script do you use to backup hourly? and what script do you use for the 
daily backup?

Danny
"Craig" <craig@cctropicalparadisepets.com> wrote in message 
news:OPX37F9SHHA.5012@TK2MSFTNGP04.phx.gbl...
>I also back up to an external harddrive using a script for daily backups 
>after we close. I also have Ghost installed(because of Jeffs 
>recommendation)and have it set to run at midnight everyday. Not quite as 
>good as backing up every hour, but it has worked for us.
> Craig
>
> "Jay" <jay.lindner@pobox.com> wrote in message 
> news:O81h$t3SHHA.2256@TK2MSFTNGP02.phx.gbl...
>>I found a low cost solution for backups. The prices of external drives are 
>>very low. I got a 500gb drive for less than $200. I have 2 of these on my 
>>server. One backs up during the day and one at night. Within each of these 
>>drives I have a folder for each day. I now have a back up to go back 1 
>>week and have 2 sources of information. I also have the same configuration 
>>on all of my PC's. I also have an external backup on each register that 
>>contains all of the software, updates and drivers necessary for a 
>>re-install.
>> I did not buy any software, I just use the windows software. Works great.
>>
>> Jay
>>
>> 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.
>
> 


0
lane.dj (172)
2/9/2007 3:23:48 AM
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.

0
ElBorba (39)
2/9/2007 6:56:31 PM
This is a multi-part message in MIME format.

------=_NextPart_000_0209_01C7553A.0EFEEB40
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Danny,

What database are you running, MSDE/SQL 2000 or SQL2005/Express? The =
scripts are different.

As far as scheduling them, use the Windows Task Scheduler for either.

--=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

  "Danny" <lane.dj@gmail.com> wrote in message =
news:OxQh7m$SHHA.3592@TK2MSFTNGP03.phx.gbl...
  What script do you use to backup hourly? and what script do you use =
for the=20
  daily backup?

  Danny
  "Craig" <craig@cctropicalparadisepets.com> wrote in message=20
  news:OPX37F9SHHA.5012@TK2MSFTNGP04.phx.gbl...
  >I also back up to an external harddrive using a script for daily =
backups=20
  >after we close. I also have Ghost installed(because of Jeffs=20
  >recommendation)and have it set to run at midnight everyday. Not quite =
as=20
  >good as backing up every hour, but it has worked for us.
  > Craig
  >
  > "Jay" <jay.lindner@pobox.com> wrote in message=20
  > news:O81h$t3SHHA.2256@TK2MSFTNGP02.phx.gbl...
  >>I found a low cost solution for backups. The prices of external =
drives are=20
  >>very low. I got a 500gb drive for less than $200. I have 2 of these =
on my=20
  >>server. One backs up during the day and one at night. Within each of =
these=20
  >>drives I have a folder for each day. I now have a back up to go back =
1=20
  >>week and have 2 sources of information. I also have the same =
configuration=20
  >>on all of my PC's. I also have an external backup on each register =
that=20
  >>contains all of the software, updates and drivers necessary for a=20
  >>re-install.
  >> I did not buy any software, I just use the windows software. Works =
great.
  >>
  >> Jay
  >>
  >> Steve wrote:
  >>> 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=20
  >>> buy to start doing so...preferably a cost-effective solution.  =
Thanks=20
  >>> for any feedback.
  >
  >=20


------=_NextPart_000_0209_01C7553A.0EFEEB40
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.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Danny,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>What database are you running, MSDE/SQL 2000 =
or=20
SQL2005/Express? </FONT><FONT color=3D#008000>The scripts are=20
different.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>As far as scheduling them, use the Windows =
Task=20
Scheduler for either.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</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>&nbsp;</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).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</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>"Danny" &lt;<A =
href=3D"mailto:lane.dj@gmail.com">lane.dj@gmail.com</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:OxQh7m$SHHA.3592@TK2MSFTNGP03.phx.gbl">news:OxQh7m$SHHA.3592=
@TK2MSFTNGP03.phx.gbl</A>...</DIV>What=20
  script do you use to backup hourly? and what script do you use for the =

  <BR>daily backup?<BR><BR>Danny<BR>"Craig" &lt;<A=20
  =
href=3D"mailto:craig@cctropicalparadisepets.com">craig@cctropicalparadise=
pets.com</A>&gt;=20
  wrote in message <BR><A=20
  =
href=3D"news:OPX37F9SHHA.5012@TK2MSFTNGP04.phx.gbl">news:OPX37F9SHHA.5012=
@TK2MSFTNGP04.phx.gbl</A>...<BR>&gt;I=20
  also back up to an external harddrive using a script for daily backups =

  <BR>&gt;after we close. I also have Ghost installed(because of Jeffs=20
  <BR>&gt;recommendation)and have it set to run at midnight everyday. =
Not quite=20
  as <BR>&gt;good as backing up every hour, but it has worked for =
us.<BR>&gt;=20
  Craig<BR>&gt;<BR>&gt; "Jay" &lt;<A=20
  href=3D"mailto:jay.lindner@pobox.com">jay.lindner@pobox.com</A>&gt; =
wrote in=20
  message <BR>&gt; <A=20
  =
href=3D"news:O81h$t3SHHA.2256@TK2MSFTNGP02.phx.gbl">news:O81h$t3SHHA.2256=
@TK2MSFTNGP02.phx.gbl</A>...<BR>&gt;&gt;I=20
  found a low cost solution for backups. The prices of external drives =
are=20
  <BR>&gt;&gt;very low. I got a 500gb drive for less than $200. I have 2 =
of=20
  these on my <BR>&gt;&gt;server. One backs up during the day and one at =
night.=20
  Within each of these <BR>&gt;&gt;drives I have a folder for each day. =
I now=20
  have a back up to go back 1 <BR>&gt;&gt;week and have 2 sources of=20
  information. I also have the same configuration <BR>&gt;&gt;on all of =
my PC's.=20
  I also have an external backup on each register that =
<BR>&gt;&gt;contains all=20
  of the software, updates and drivers necessary for a=20
  <BR>&gt;&gt;re-install.<BR>&gt;&gt; I did not buy any software, I just =
use the=20
  windows software. Works great.<BR>&gt;&gt;<BR>&gt;&gt;=20
  Jay<BR>&gt;&gt;<BR>&gt;&gt; Steve wrote:<BR>&gt;&gt;&gt; I got my =
first wakeup=20
  call to take seriously the daily backing up of our <BR>&gt;&gt;&gt; =
databases;=20
  luckily I dodged a bullet this time.&nbsp; I have 1 HQ and 2 SO's.=20
  <BR>&gt;&gt;&gt; Does anybody have any suggestions what kind of =
hardware that=20
  I should <BR>&gt;&gt;&gt; buy to start doing so...preferably a =
cost-effective=20
  solution.&nbsp; Thanks <BR>&gt;&gt;&gt; for any =
feedback.<BR>&gt;<BR>&gt;=20
  <BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0209_01C7553A.0EFEEB40--

0
cptsoft (1248)
2/21/2007 5:57:05 AM
Jeff,
Am I going to have to change my backup scripts when I upgrade to Express? If 
so what would those changes be?
Craig
"Jeff @ Check Point Software" <CptSoft@Hotmail.com> wrote in message 
news:%23l%23D80XVHHA.4568@TK2MSFTNGP02.phx.gbl...
Danny,

What database are you running, MSDE/SQL 2000 or SQL2005/Express? The scripts 
are different.

As far as scheduling them, use the Windows Task Scheduler for either.

-- 

Jeff
Check Point Software

=====================================================

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
=====================================================

"Danny" <lane.dj@gmail.com> wrote in message 
news:OxQh7m$SHHA.3592@TK2MSFTNGP03.phx.gbl...
What script do you use to backup hourly? and what script do you use for the
daily backup?

Danny
"Craig" <craig@cctropicalparadisepets.com> wrote in message
news:OPX37F9SHHA.5012@TK2MSFTNGP04.phx.gbl...
>I also back up to an external harddrive using a script for daily backups
>after we close. I also have Ghost installed(because of Jeffs
>recommendation)and have it set to run at midnight everyday. Not quite as
>good as backing up every hour, but it has worked for us.
> Craig
>
> "Jay" <jay.lindner@pobox.com> wrote in message
> news:O81h$t3SHHA.2256@TK2MSFTNGP02.phx.gbl...
>>I found a low cost solution for backups. The prices of external drives are
>>very low. I got a 500gb drive for less than $200. I have 2 of these on my
>>server. One backs up during the day and one at night. Within each of these
>>drives I have a folder for each day. I now have a back up to go back 1
>>week and have 2 sources of information. I also have the same configuration
>>on all of my PC's. I also have an external backup on each register that
>>contains all of the software, updates and drivers necessary for a
>>re-install.
>> I did not buy any software, I just use the windows software. Works great.
>>
>> Jay
>>
>> 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.
>
> 

0
craig6967 (916)
2/21/2007 3:21:01 PM
Reply:

Similar Artilces:

How to BackUp Outlook email folders and messages
I am new to Outlook as I have been using Outlook Express instead. How do I backup the folders and messages in Outlook? Thanks in advance for any help. Jim. Thanks Scott. I am using Outlook 2000 SR-1 (9.0.0.3821). I don't understand about the "mode I am configured in". I am an individual and I use Outlook as my email manager for home use only (does that help?). I did a search on my C: harddrive for *.PST but got no results. Where would the folder normally be for these email folders and messages? TIA, Jim. "Scott Atkins[MSFT]" <scatki@online.microsoft.com> wrot...

Restoring 5.5 using windows backup?
I am backing up our exchange server 5.5 using my win2k workstation (exch admin installed) and I want to restore it to a another server with different name. Is this possible? if yes how? I tried restore the files but I don't know where to point it. Please advice, thank you you mean to a recovery server? yes, you can restore it to another Exchange server for recover purposes, if the server is configured correctly...see this: http://www.microsoft.com/Exchange/techinfo/administration/55/BackupRestore.a sp "im_tigerwoods" <im_tigerwoods@hotmail.com> wrote in message news:#...

Suggestion
I recently had a look at Circus ponies, a ON alternative for mac users. There you can also include a PDF file on a page. The nice feature is that you see the first page of the pdf file. Even you can flip the pages on this icon. This means that you do not have to open the PDF file to see what it looks like. You immeditaly see how the first page looks like because the icon itself is the first page of the PDF file and not the default red acrobat PDF icon. I hope we will have this in ON!!!! ...

Suggestion: Read-only PST files
Hi, Many people do archive their PST files on CDROM/DVD; so that they can reduce the clutter on their Hard Disk, However it appears that Outlook likes to treat all PST files as read/write. Therefore when one tries to point Outlook to a old PST file archived on read-only media (CD, DVD, etc) just to look at some old mails, Outlokk does not seem to allow it. The only choice you have is to copy (what might perhaps be huge) PST files to your hard disk. This is not user-friendly at all !!! I think there is a strong case for supporting a feature like "READ-ONLY PST files". If a...

Offline backup/restore
I have an offline backup of my Priv and Pub.edb files. How can I restore them? Thanks in advance 296788 Offline Backup and Restoration Procedures for Exchange http://support.microsoft.com/?id=296788 Thanks, Richard Roddy Microsoft Exchange Support This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- >Content-Class: urn:content-classes:message >From: <anonymous@discussions.microsoft.com> >Sender: <anonymous@discussions.microsoft.com> >Subject: Offline backup/restore >Date: Tue, 25 May 2004 06:01:44 -0700 >...

Windows 2003: Dynamic Filename for Backup Name
Hi, I am looking to schedule a regular backup in Win 2003 using the default backup utility. I would like the name of the backup file to be dynamic, with a date and time stamp. Date is more important than time; If I can get a filename with the date, but without a timestamp, that is fine. For example, today's backup should be Feb_11_2010_6PM_File_Backup, though Feb_11_2010_File_backup will do. Next week's today be Feb_11_2010_5_59PM_File_Backup, etc.. The specific date and timestamp format is not important to me. I am hoping that I can specify a filename such as &l...

Backup
Sir, I have created a database in msaccess 2003, in form i want to create a button and after clicking button backup should done automatically or a window should open showing place of location it is saving and file name with backup date) -- srinivas On Wed, 31 Mar 2010 03:34:01 -0700, Srinivas <Srinivas@discussions.microsoft.com> wrote: That is not easy, because a file should not be backed up while it is in use. Typically we backup files at night, while nobody is in the database, using a backup program or script that runs automatically. You do need to split your datab...

Automate backups for RMS? If so how?
Is there a way to automate backups for RMS? If so how? we use windows task scheduler to regularly run a batch file that contains an OSQL command that backs up the database. there is a post about this on the board, do a search for 'automating backup in RMS' and you will find it hth kevin ...

Corrupted Microsoft Money Backup file
I am trying to restore backup from my two floppies. However, one floppy has a bad track so I used a commercial software to extract the file. Now, Microsoft Money is complaining that it is a bad/corrupted file. The backup files have extension .mbf. Does anyone know if there is any way to recover these backup files? Thanks for your help In microsoft.public.money, khuss wrote: >I am trying to restore backup from my two floppies. However, one floppy has >a bad track so I used a commercial software to extract the file. Now, >Microsoft Money is complaining that it is a bad/corrupt...

flushing logs during backup
I have two storage groups and set up full backups on them weekly, plus daily incremental, both of which should be flushing committed logs. On one of the two stores, the logs are not being flushed after the backups, the other store does as expected. Both are in the same backup job using Backup Exec 10.0 with Exchange agent. -Peter and you're backing up the storage group, in both instances? If that's the case, and the backups are completely properly, I would contact the vendor... -- Susan Conkey [MVP] "Peter Lecki" <plecki2@ralotter.com> wrote in message news:gnsr...

USB2 2.5 external backup
After very useful help from this group earlier, I am now deciding which external drive to buy. I am converting to USB 2.0 but on seeing a number of sales sites often 2.5 drive is shown as laptop and 3.5 as desktop. As I have very little backup 40 GB would give me ample space. I have a desktop unit but would prefer a 2.5 would this be compatible with desktop setup. Regards Roger ========================================= ============================== Roger wrote: > After very useful help from this group earlier, I am now deciding which > external drive to buy. I a...

How can I import outlook backup file into entourage for mac?
I've just started using a new MacBook Pro with Office 2008 and Entourage - how can I import my old backup file with all my old emails etc. from my 'old' Office application? It may depend on what your "old" Office application was. Here is a link to the "Entourage" group. http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.mac.office.entourage C C wrote: > I've just started using a new MacBook Pro with Office 2008 and Entourage - > how can I import my old backup file with all my old emails etc. from my ...

problem with personal folders backup
Backed up (or so I thought) my .pst files using the personal folders backup utility for Outlook 2002. When I backed up the files, I ended up with a small (38 kb) backup file and a larger (67 MB) file labeled "Outlook backup" but with no file extension--it's simply listed as a data file, not a .pst file. I tried restoring from that file and opening it directly in Outlook to no avail. Even tried the inbox repair tool with no luck. Anyone encountered this before? Any way to recover this file? It contains a lot of important emails. Thanks! Open the backup addin from t...

Microsoft Office won't launch from backup clone
I've made a bootable backup clone of my entire hard drive onto an external firewire Lacie drive using SilverKeeper. When booting from the external drive, everything seems to work fine, except for Microsoft Office. On launch, Word bounces once in the dock then disappears. Same for Excel (I haven't tried the others). Is this some sort of anti-piracy measure, or have I screwed up my backup in some way? The whole point of having a bootable backup clone is that I could carry on working after a hard drive failure. But this throws a spanner in the works. Everything else seems t...

Best Practices Analyzer suggestions
When I run BPAT from a workstation, as suggested, I get two extra warnings: Primary DNS failed to respond, and DNS Host Record appears to be missing. On investigation, the DNS Host Record is not missing, and the Primary DNS does not fail to respond. Actually, the problem is that the primary DNS is configured as 127.0.0.1 Since this is not Best Practice, this should have been picked up by the BPAT. If it had been picked up correctly, then the two invalid warnings could have been suppressed. Even if the invalid warnings were not suppressed, if the DNS setting generated a warning, the t...

Setting up service call management -- suggestions, please
We are in the process of setting up service call management and I need some suggestions on the best way to set up some of the tables. Equipment would refer to the equipment we would be working on, but we don't sell this equipment, so why do we have to set it up in inventory? Can we set up a generic item in inventory that would refer to all equipment serviced and just use the other fields to detail out each piece or would it be better to set up an item for each model? I also notice that I can only set the equipment up to a customer and not to a ship-to. I really need specific equi...

DPM 2010 Cloud backup option
I would like to know if DPM 2010 has cloud backup option built into the product (not having to go with Iron Mountain CloudRecovery service). Can anyone help? Thanks Bill Hi Bill, This has been an ask from multiple customers who are interested in backing up data to cloud. We are interested in knowing more about your scenario and requirements around cloud backup. Can you drop me a mail at gauravgATmicrosoftDOTcom and we can discuss this in more detail? Thanks -- Gaurav Gupta | Program Manager | DPM This posting is provided "AS IS" with no warranties, and con...

Event ID: 602; Source: ESE... What do you suggest?
Hi All, Suddenly I started getting the event ids 602 of the source ESE in application log on the Exchange server (Exchange 2003)... Desription: Information Store (6488) Storage Group3: Database 'G:\EXCHSRVR\mdbdata\priv_2.edb': Background clean-up skipped pages. The database may benefit from widening the online maintenance window during off-peak hours. If this message persists, offline defragmentation may be run to remove all skipped pages from the database. For more information, click http://www.microsoft.com/contentredirect.asp. Could you please let me know your thoughts on t...

Proper way to backup Exchange 2003
Hello, We just installed Exchange 2003 and I am using Veritas' BackupExec with OFO and the Exchange Agent. I want to make sure my backup sets can actually restore the server. What files / directories / etc do I need besides the System State, the Exchange Databases and Exchange Transaction Logs? Your help is greatly appreciated. thanks, mitch You're basically correct, but personally I'd bin OFO. I'd recommend downloading the following document and reading the first few pages of chapter 2. In fact, I'd recommend reading the entire document! You won't regret i...

Standby Backup of a CRM 4 / SQL 2005 server
Hello all, I have 2 server machines of identical specs. Each one has SQL server 2005, and CRM 4.0 installed. SVR1 is our production server and is the Principal server for SQL mirroring, while SVR2 is our standby backup server and is the SQL mirror. During the installation of CRM Server on SVR2, we pointed it to an existing CRM installation (on SVR1). We are NOT using load balancing, or clustering, etc. Note1: In CRM deployment Manager, both servers are enabled, both have the role of CRM server, but only SVR1 has the role of SQL Server. I believe that since CRM SVR2 was pointed to SVR1, th...

RMS HQ Manager needs option to turn off backup question on exit
Everytime I exit RMS HQ Manager it asks if you want to backup your database. There should be an option to turn this off. We back up our HQ database nightly and with multiple users going in and out of HQ Manager every day this question gets annoying after awhile. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then clic...

How to backup and Restore Microsoft Exchange 2000 Standard?
Hello Microsoft Exchange gurus! I am currtently working through the company's disaster recovery plan and finding that many components of it are fatally flawed. What a surprise, eh? I'm now to the point where I can't continue, and after weeks of searching I am unable to find sufficient technical information to implement a solution. I am working through the DR scenario I've re-titled as "Full Microsoft Exchange Restore". In this scenario, for whatever reason, the existing Microsoft Exchange Server is no longer available. Maybe through a flood, maybe it was a fire, per...

Your suggestion?
I'm writing a small program on Win32 MFC where user can login to do something. Now I would like to implement the automatic logout when the user is logged in and there was no mouse nor keyboard activity for e.g. 10 seconds? Since there is a lot WM_x messages that mouse and keyboard produces I could listen to it's to much work and probably not so elegant. Must I use keyboard and mouse hook for this or you think there is a better solution? How to know if my app was in idle time when it comes to user input? Thanks for help! "blue" <blue@blue.blue> wrote in messa...

Backup/Restore
I am using Windows 98 SE and will be installing on a new drive XP Pro. I need to move files from old drive (to become d:)to new drive (c:). Can I just restore from my backup to the new drive? I particularly need MSN Explorer and Outlook. If I cannot just restore without restoring Windows, what do I need to restore? Thank you. Jim wrote: > I am using Windows 98 SE and will be installing on a new > drive XP Pro. I need to move files from old drive (to > become d:)to new drive (c:). Can I just restore from my > backup to the new drive? I particularly need MSN Explorer > and ...

Backup & exch services.
Hi, I am looking to do off line backups of my exchange server every week. i understand that the best way to do this is to switch all exchange services off, and then restart them after the backup. can anyone advise what sequance the services have to be stopped/started. e.g net stop..... net start... thanks Anish >>I am looking to do off line backups of my exchange server every week. Ew! >>can anyone advise what sequance the services have to be stopped/started. If you just want the store then you can dismount it and copy the file. If you want the transaction logs as w...