SQL Server Performance

Replicate two disconected computers?

Discussion in 'Performance Tuning for SQL Server Replication' started by behari, Aug 25, 2004.

  1. behari New Member

    Hello,
    is it possible to replecate two coputers which are not connected, for instance: they do not have internet connections and they are not connected through cable?. I mean to transfer data with CDs( copy data from one computer to another) manualy and then to execute syncronisation.
  2. satya Moderator

    Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases for consistency and connection must be available in order perform those set of activities.

    In your case you can deploy BACKUP/RESTORE method by copying backup file to the media and restore on the other server.

    REfer to books online for BACKUP & RESTORE topics.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. behari New Member

    yes, but let's say that bothe databases change data, in this case if you do backup on one side and restore in another side, it will overwrite changes made from destination Database, I mean to syncronise changes of bothe databases.
  4. sundeip New Member

    In this case when changes are being made in both database , u must go for merge replication.
    and if setup of replication is not possible then in this case u restore the data with a different name and do the BATCH Processing.



    Sandy

    (DB Developer)
  5. satya Moderator

    True, if the both database needs a synchronisation with different data then you require replication topology. Otherwise this BACKUP/RESTORE would work to keep the other database as a standby.

    For this type of replication refer to the books online for 'Online/Offline Applications ' topic.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. xpthinker New Member

    Replicating machines that has no network connections is possible, using backup and restore processes. But ensure the restoration point for each machines has no activity on current databases.

    xpthinker

Share This Page