Remote Backup?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Icarus
    #1

    Remote Backup?

    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
    Tags: None
    • Jerry Boone
      #2
      Re: Remote Backup?

      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@NO SPAMreardenweb. com> wrote in message
      news:ssaarv03e4 vuhf1sc5eh4grqv gsts1p4ag@4ax.c om...[color=blue]
      > 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[/color]


        Comment

        Previous template Next
        Working...