SQL Server Performance

Replication

Discussion in 'General DBA Questions' started by NewDBA, Mar 12, 2004.

  1. NewDBA Member

    If I would like to restart the SQL server ,should i turn off replication
    first?

    If yes then distribution and then Log reader ?
  2. Twan New Member

    No need to turn off replication. It will sort itself out when the server restarts

    Cheers
    Twan
  3. satya Moderator

    IF the MSSQLServer & MSSQLAgent services are stopped then no replication process will take place until they are back online without any problems.

    Keep an eye on SQL server error log for information.

    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