Browsing articles tagged with " transactional replication"
Apr
4
2012

SQL Server 2000 – The subscription(s) have been marked inactive and must be reinitialized

Error: The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.   Environment: SQL Server 2000 SP4 (valid for other SP versions as well)   Replication Type: Transactional Replication with Publisher and Distributor on one server and Subscriber on another Scenario: You have created subscription to non-expire subscription as below, #img1# And still from time to time you see the subscriber marked inactive error and your […]

Mar
12
2012

Troubleshooting transactional replication timeout error in SQL Server 2000

Timeout error is mostly encountered in merge or transactional replication scenarios where data needs to be synced at regular time intervals, now sometimes due to network issue or bad data replication start failing with timeout errors, now to troubleshoot them follow below steps, Source: http://www.mssqlcity.com/Articles/Replic/troubleshooting_replication.htm and http://support.microsoft.com/kb/312292 First, when you encounter timeout error, go to distribution agent SQL job (in case of push subscription, agent job will be present on distributor server and in case […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: