April 1, 2008 at 7:06 am
SQL Server 2000 doing transactional replication to one Database offsite.
Had a problem with the Publishing Server overnight and now it is back up and replication will not start. getting this errror:
The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
How do I reinitialize?
April 1, 2008 at 10:53 am
You might try going to Replication Monitor, and using the tree go to the Publishers, select the server, then the database. Next on the right hand side where the subscriptions are, right click and from that menu select Start Syncronizing.
Have you tried that?
April 1, 2008 at 10:54 am
...and, if you start the syncronizing process, the databases will be unavailable during the process, which can be serveral hours based on the size of your databases.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply