SQL Server Performance

Old to New & Repl sp_'s

Discussion in 'Performance Tuning for SQL Server Replication' started by ginoitalo, Sep 24, 2004.

  1. ginoitalo New Member

    I have a Master/Slave transaction replication setup where the slave is read only. The master server is very old and I need to take it offline, Would it be ok just to stop the replication and use the slave#%92s copy of the DB as the master? (would any unforseen problems arise?)

    Is there a way to enforce a read-only subscription database but still allows replication to write to it?
  2. satya Moderator

    You need to reconfigure the replication process to take affect the new settings on slave server act as main server.

    Refer to books online for more information on replication 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.

Share This Page