If I would like to restart the SQL server ,should i turn off replication first? If yes then distribution and then Log reader ?
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.