Backup Suggestions


S

Steve

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.
 
Ad

Advertisements

T

Terrible Tom

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
 
J

Jay

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
 
M

Mickie

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
 
C

Craig

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
 
D

Danny

What script do you use to backup hourly? and what script do you use for the
daily backup?

Danny
 
Ad

Advertisements

E

ElBorba

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.
 
J

Jeff @ Check Point Software

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

What script do you use to backup hourly? and what script do you use for the
daily backup?

Danny
 
Ad

Advertisements

C

Craig

Jeff,
Am I going to have to change my backup scripts when I upgrade to Express? If
so what would those changes be?
Craig
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
=====================================================

What script do you use to backup hourly? and what script do you use for the
daily backup?

Danny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suggestion - Backups 1
Suggestion: Automatic Backup 1
Backup Strategy Suggestions 0
Backup Suggestions for Q2006 3
HQ Server crashed, no backup, suggestions? 5
Suggestions 2
Suggestions 5
Suggestions 2

Top