What exactly is "sync with backup"? It appears to me to
be a common phrase used to define a process rather than a
name for a feature of SQL Server. We are trying to set up
a secondary server to switch to in case the production
server fails on us. We need to keep the secondary server
synchronized with the production server with as little
delay as possible. We have been attempting to use
replication to do this but so far replication has proven
to be rather unreliable. Somebody here on this newsgroup
told me once that we should probably not be using
replication for this purpose and suggested we do a "sync
with backup" but that was a new phrase to me. I have
searched for information on "sync with backup" with no
success so I am now assuming that is a process rather than
a feature of SQL Server. I now suspect it means to create
a batch job that runs periodically on the backup server
and restores the databases on the backup server from
backup files on the production server. Correct? Our two
servers do not reside in the same network domain, in fact,
they do not even reside in the same town. Is my
assumption as to the meaning of "sync with backup" ,
correct? If not, what does "sync with backup" mean?
TIA,
Darwin