x

what type of Replication error?

hi we are using snap shot replication in our server last week we have received the following error

The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074

if any one knows what kind of error it should be kindly inform me and how to solve this???
more ▼

asked Dec 10, 2012 at 02:35 PM in Default

askmlx121 gravatar image

askmlx121
2.5k 69 74 77

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

ok thanking you for your response.

how to set the interval based on the frequency as u mentioned.

My snapshot replication have following type of subscription never expire.

see figure:alt text

Note:

I recently re initilized the subscription.

it can it make the problem now? if yes means what is the solution...

more ▼

answered Dec 11, 2012 at 08:10 AM

askmlx121 gravatar image

askmlx121
2.5k 69 74 77

Under the Instance name, there is a folder named Replication. Right click on this folder and check distributor properties. There you can set the transaction and history retention. In the above screenshot it does mention that they might get de-activated, so I'm not sure bout that, but I have tried setting the retention intervals in distributor properties and has worked for me...
Dec 11, 2012 at 10:19 AM DharmanDave
(comments are locked)
10|1200 characters needed characters left
This means that the subscriptions have expired as they were in idle state for a while. They will have to be re-initialized. In the distribution properties, check for transaction and history retention. By default it is 3 days for transactions and 2 days for history retention. If there has been no activity for this period of time, the subscriptions will expire. You can set this interval based on the frequency with which you are going to distribute data using the snapshot replication. I have tried and tested this solution with Transactional replication. Hope it helps you with Snapshot replication.
more ▼

answered Dec 10, 2012 at 04:38 PM

DharmanDave gravatar image

DharmanDave
550 7 10 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x306

asked: Dec 10, 2012 at 02:35 PM

Seen: 860 times

Last Updated: Dec 11, 2012 at 10:19 AM