We have about 52 clients on SQL Server 2005 using anonymous pull
subscriptions (2 subs each).
One of these clients had an issue with disk space so we had to recreate the
subscriptions for the 2 databases. One subscription went fine but the second
is getting the following error:
The specified subscription type is invalid. Verify that the
-SubscriptionType parameter for the Merge Agent has been correctly specified.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201020
The -SubscriptionType parameter is set to 2. Nothing is different from the
other 100+ subscriptions we have created. I compared the working
subscription's step to the failing sub and they are identical except for the
db and pub name.
I have been unsuccesful in finding anything on the Internet. Does anybody
have a solution?
Thanks in advance!
can you try a subscriptiontype of 1?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"RichardD" <RichardD@.discussions.microsoft.com> wrote in message
news:6733A022-8948-4D15-A116-58A5C81CCA94@.microsoft.com...
> We have about 52 clients on SQL Server 2005 using anonymous pull
> subscriptions (2 subs each).
> One of these clients had an issue with disk space so we had to recreate
> the
> subscriptions for the 2 databases. One subscription went fine but the
> second
> is getting the following error:
> The specified subscription type is invalid. Verify that the
> -SubscriptionType parameter for the Merge Agent has been correctly
> specified.
> (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201020
> The -SubscriptionType parameter is set to 2. Nothing is different from the
> other 100+ subscriptions we have created. I compared the working
> subscription's step to the failing sub and they are identical except for
> the
> db and pub name.
> I have been unsuccesful in finding anything on the Internet. Does anybody
> have a solution?
> Thanks in advance!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment