sql server replication: MS SQL replication issues -- sql server replication

MS SQL replication issues

jayanuk
10/28/2003 10:50:07 AM

sql server replication:

Hi,

We are having a merge replication in play. It has been in play for past
1 and a half years working smoothly. At times we have weekly maintance
wherein we drop and recreate the publication and subscription. Currently
we are getting an error on the subscriber "The process could not query
row metadata at the Subscriber."

Any help would be appreciated. The database size is around 4GB.

--

MS SQL replication issues

Ray D
10/30/2003 12:18:54 AM

Can you show detailed information on encountered error?

(add -OutputVerboseLevel 2 to the agent's parameters)

[quoted text, click to view]

Re: MS SQL replication issues

TSVK [MSFT]
11/2/2003 5:00:06 PM

Can you get more information with -OutputVerboselevel 3 or profiler trace at
publisher/subscriber?

Usually the problem is related to QueryTimeout. Is that true in your case?
Can you try increasing the timeout. Also some best practices would be to
reindex the merge system tables and reduce metadata to alleviate perf
problems.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
OR if you wish to include a script sample in your post please add "Use of
included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.