Database Replication Act As Backup?
Posted on 2004-08-20
At work, we're using an Access 2002 database, split into a front & back end. Occasionally, we'll get a network hiccup, resulting in "disk or network error". Actually, we get them quite often. Usually, we just close and restart the database, but occasionally the back end will be corrupted. We can restore it from the previous night's tape backup, but then we lose the day's work and need to re-enter it all.
We were wondering if we could use database replication as a form of constant, incremental backup. Could we set up our database back end to replicate, then just copy the replica if the functional back end gets corrupted? That might result in a much smaller loss of data, right? Just an idea.