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

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" <christopher@NOSPAMreardenweb.com> wrote in message
news:ssaarv03e4vuhf1sc5eh4grqvgsts1p4ag@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