?
Solved

Instant (remote) duplicate copy of data

Posted on 2005-03-23
15
Medium Priority
?
269 Views
Last Modified: 2010-04-03
We have a Windows 2000 server. Certain data is vital to us which means we would like to protect it from every possible disaster, instantly... no good just having a RAID system and nightly full backups (tapes kept off site), 'coz if there's a fire or flood during the night (before the backup is complete) then a whole day's work is lost.

We use a dbase database, which can only be backed up when all users are logged out - this happens every evening. However, we would like to go one step further so that each 'write' to the db, is also instantly synchronised/replicated somewhere else. This 'somewhere else' could be in other office in the same building, or even better, offsite i.e. over the internet?

I am after a solution/product which will sort this out for me. We are a small company (<20 users), so cost is a real issue... any thoughts, references (URLs) and suggestions are welcome - many thanks
0
Comment
Question by:omb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +4
15 Comments
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 13613179
Other than periodically kicking people off, I'm not sure you'll be able to do this.  If you ran an Enterprise database, such as SQL Server, you could replicate the database or do a number of other things periodically.  But this is not necessarily a cheap solution.
0
 
LVL 13

Expert Comment

by:gpriceee
ID: 13613760
Hello.  Check out the following tool to see if the export feature will work for you.  If so, you can import the data elsewhere.  As for realtime recovery, as leew states, SQL Enterprise, but you probably don't want to incur the major expense for 20 users.

You can export the data and then "ship" it to another location on a schedule.  Do you have a vpn?  Perhaps the president might want the data to be shipped to the home residence.

http://www.canadiancontent.net/en/jd/go?Url=http://www.degisy.com/database-workshop.php
0
 
LVL 11

Expert Comment

by:huntersvcs
ID: 13614103
Check out this link:

http://www.savvy.net/detail.asp?category_id=5&article_id=107

They claim even real time synchronization.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 3

Expert Comment

by:jannepm
ID: 13614158
If your database is for example Access, then you could use a software like Access2MySQL, URL: http://www.data-conversions.net/access-to-mysql-sync-converter.html
Price $49, it supports synchronization and it has scheduler so you can export your Access DB to some MySQL Server on the Internet for example every 15 minutes.

Depending your database you could use similar tools.
0
 
LVL 25

Expert Comment

by:kode99
ID: 13615605
You could try Acronis True Image,

  http://www.acronis.com/enterprise/products/ATIESWin/

You could do a full backup nightly then do repeated incremental backups through the day.  These can be done to a remote server.   This will not get you backups down to the transaction but it could be good for every half hour or so.  It all depends on how much data you have to backup and how long it will take to do the incremental.

I would want to test the backups just to be sure the tables are not corrupted.  I have seen it work fine with other database files but not dBase specifically.

I do not know the current state of dBase but I would wonder if you could actually set up your clients to write to two locations or create a 'client' that would copy from one database to a remote one.  Last time I used dBase it was a single user DOS app.  
0
 
LVL 13

Expert Comment

by:gpriceee
ID: 13730757
Hello.  Have you narrowed your possibilities?
0
 
LVL 3

Author Comment

by:omb
ID: 13986419
Sorry everyone for not responding for a while - yes, this project was put on hold. However, I am still very interested in the solution, so will review the above suggestions and come back with my comments.

Please do not close this call. Thanks again for everyone's patience.
0
 
LVL 3

Author Comment

by:omb
ID: 14068073
Hello everyone

At the moment I am evaluating / in discussions with the following:

Acronis True Image 8.0 Enterprise Server for Windows
http://www.acronis.com/enterprise/products/ATIESWin/

Double-Take
http://www.sunbelt-software.com/Double-Take.cfm
http://www.nsisoftware.com/pro/doubletake/FAQ/

LiveServ® for Microsoft Exchange
http://www.storactive.com/solutions/liveServ/

Drive SnapShot 1.3
http://www.drivesnapshot.de/en/index.htm

Backup for Workgroups
http://www.backup-for-workgroups.com/open-file-add-on.html

ViceVersa
http://www.tgrmn.com/index.htm?camp=goog_bac

BackupOnDemand Backup Software
http://www.caddais.com/BackupOnDemand.html

Database Workshop
http://www.canadiancontent.net/en/jd/go?Url=http://www.degisy.com/database-workshop.php

IPReplicator®
http://www.linkpro.com/iprep.htm

Network File Monitor Professional
http://www.file-monitor.com/index.html

SavvySafe ES-500
http://www.savvy.net/detail.asp?category_id=5&article_id=119

HP OpenView Storage Virtual Replicator
http://h18006.www1.hp.com/products/sanworks/vr/index.html

HP OpenView Storage Mirroring
http://h18006.www1.hp.com/products/storage/software/sm/index.html

HP OpenView Storage Data Protector
http://h18006.www1.hp.com/products/storage/software/dataprotector/index.html

Learn How Intel is Helping Deliver Affordable Easy to Manage Storage
http://www.intel.com/netcomms/technologies/storage/index.htm

I'll let you know how I get on. Has anyone got experience of any of these products? Any recommendations or total no-goers?

Many thanks
0
 
LVL 13

Expert Comment

by:gpriceee
ID: 14587429
interested
0
 
LVL 11

Expert Comment

by:huntersvcs
ID: 14587573
SavvySafe ES-500 (that I recommended) was one of the ones you were going to check out.  Any results back yet?  Split points, or have you decided on something else?
0
 
LVL 13

Expert Comment

by:gpriceee
ID: 14643637
I think the points should be split between huntersvcs and me.  We both responded as interested and we both offered viable solutions
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 14669715
PAQed with no points refunded (of 100)

modulo
Community Support Moderator
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question