Database Backup To Alternate Location


J

Jerry Penna

Hi Everyone ~

I've noticed a problem with the my database backups. I've been trying
to backup the database to another register, off of the register with
the database, but the backup saves to the register with the database
as opposed to the register that I'm taking the backup from. This
offers no level of protection since if my database hard drive crashes
I lose the backup too since they are on the same drive.

Currently, I go to register #2's Store Manager, select backup
database, select the c:\ drive on register #2 (this shows the path and
file system on register #2), but the backup saves to register #1 which
also contains the database.

I want to configure Store Manager to backup the database opposite the
register with the database so that the backup and the database are on
separate disks.

How can I configure the system to save the backup to register #2 from
within Store Manager without having to use other utilities to copy the
backup across the network?
 
Ad

Advertisements

J

John M.

We do this outside of RMS. I created a batch file that calls SQL statement
that backs up the database to a file location I specify - I use a directory
on that system. The job then acquires a network on another system (via "net
use"). I then copy the backup file to that system, release the mapped
drive, then do the same to a 2nd system. This way I've been able to back
the file up to 3 different systems.

An added benefit of this is that I can connect to one of my systems at the
store from home, do a file transfer to my home system, restore the file on
my system, then crank up a copy of RMS Manager there. This has me looking at
yesterday's file which is more than enough for a lot of reports and things I
do at home with the business.
 
J

Jerry Penna

Sweet! Can you share the steps and the batch file? I'm familiar with
this on Unix/Oracle, but not NT/SQL Server. I'd appreciate seeing
what you have since I have a similar set up with my two store
registers and my home office computer. I've been able to vpn to the
non-database register at the store, but Microsoft told me that the
dongle blocks the SQL Server Enterprise Manager from recognizing the
register with the live database. Connecting to old copies of the
database on the non-database register doesn't do me much good, so I'd
love to understand you setup.

Currently I'm just copy the db onto a cd and recovering that backup to
a new database to do what you are doing over the network.

I'd appreciate seeing your procedure and batch file.

Thanks

Jerry Penna
 
Ad

Advertisements

J

Jeff

Jerry,

Go into CustomerSource and find article 836406 in the KnowledgeBase.
 

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

Top