December 1, 2003 at 1:24 pm
I have the following message for one out of 6 subscribers to the same publication.
The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
This subscription won't let me start resynchronizing. Does reinitialized mean I must start the snapshot replication Agentt?
I tried to test doing this in our dev environment. What I want to happen is that after I start the snapshot I only want the inactive subscription to get the new snapshot and not the other 5 since they seem to be fine.
Will starting the snapshot agent cause all 6 to be reinitialized? Or just the ones I want done?
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
December 1, 2003 at 1:28 pm
As near as I can tell it was marked inactive at about 2:34PM today. What would cause it to get marked as inactive?
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
December 1, 2003 at 2:02 pm
Usually because there were transactions targetted for the subscriber that were never distributed. Usually when a sub expires you run a new snapshot and you're back in business.
Andy
December 1, 2003 at 3:01 pm
I am planning to mark that subscription for reinitiallization and then start the snapshot. Unfortunately I must wait until 9PM to do this so I don't empty and/or drop the tables while our clients are using them.
Hopefully everything will go smoothly. Our DBA is on vacation until the end of December and that leaves me as the acting DBA until his return. One of my weakest points is replication.
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
December 1, 2003 at 3:04 pm
Another question. I can easily mark a subscription for reinitialization and then start the snapshot agent. My question is, after I do that will the subscription allow me to start synchronizing? In our dev environment it automatically does this because the subscription is synchronizing when I tell it to reinitialize. However, in our production environment ths subscription is not synchronizing right now and won't start.
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
December 2, 2003 at 5:43 am
Once the snapshot is applied the subscriber should automatically get changes after - assuming both logreader and distribution agent are running.
Andy
December 2, 2003 at 7:55 am
Thanks. I was working on this last night in between sending e-mails to you. I got replication working again around 10PM. Everything seems fine this morning.
Robert W. Marda
SQL Programmer
bigdough.com
The world’s leading capital markets contact database and software platform.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
December 3, 2003 at 9:39 am
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply