Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joed777
Starting Member
4 Posts |
 Posted - 2004-07-08 : 10:49:49
|
| My question is for SQL2000 and Transactional replication. Here is the scenario: The primary SQL Server node crashes or is shutdown without warning and then is restarted, and the both SQL server and SQLAgent services are set to auto start. Will replication restart automatically? If so, will it do any synchronize with the standby node?Thanks,Joe |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-08 : 19:35:16
|
| Yes replication will start back up. Some of the replication jobs are setup to start once the SQLSERVERAGENT is started. That's what causes replication to get back in sync.Tara |
 |
|
|
joed777
Starting Member
4 Posts |
Posted - 2004-07-09 : 10:51:13
|
| Thanks for the reply.Have a good weekend. |
|
|
|
|
|
|
Question regarding replication