You can do a snapshot replication.
Setup the Colorado server as a publisher and the Atlanta server as a
subscriber and setup the time you want the replication to occur.
--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Icarus" <ch*********@NOSPAMreardenweb.com> wrote in message
news:ss********************************@4ax.com...
Hi all,
I have an SQL server in Colorado and one in Atlanta. Is it possible in
SQL to mirror the two SQL servers? Meaning, once a day have the server
in Colorado send all changes made to the server in Atlanta? Or am I
looking at purchasing some type of formal backup software?
TIA