all groups > sql server replication > august 2006 >
You're in the

sql server replication

group:

Merge Replication-Pull Subscription-Error?


Re: Merge Replication-Pull Subscription-Error? Hilary Cotter
8/31/2006 12:00:00 AM
sql server replication: This could be a generic job status message. Are you getting an error other
than this message? If so what is the error message and number?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



[quoted text, click to view]

Merge Replication-Pull Subscription-Error? Vikas
8/31/2006 2:01:01 AM
Hi all,
I have a issue with merge replication. I have setup replication
between 2005 and 2000 SQL Server. But, i cannot initiate replication bcaz
"JOB HISTORY" says the following:

step ID 1
Server Store_Server
Job Name Centre_Server_CentreDB_CentrePublication_Store_Server-0
Step Name Run agent.
Duration 00:00:00
Sql severity 0
Sql Message ID 0
Operator Emailed
Operator Paged
Retries Attempted 0

Message
Executed as user: Stores\username 2006-08-30 16:17:34.175 Microsoft SQL
Server Merge Agent 9.00.1399.06 2006-08-30 16:17:34.175 Copyright (c) 2000
Microsoft Corporation 2006-08-30 16:17:34.175 2006-08-30 16:17:34.190 The
timestamps prepended to the output lines are expressed in terms of UTC time.
2006-08-30 16:17:34.190 User-specified agent parameter values:
-Publisher Centre_Server -PublisherDB CentreDB
-Publication Centre_Server_Publication
-Subscriber Store_Server\Instancename
-SubscriberDB StoreDB
-SubscriptionType 1 -SubscriberSecurityMode 1
-SrcThreads 1 -HostName 9972
-SubscriberLogin -DestThreads 1
-HistoryVerboseLevel 1 -Distributor Centre_Server
-ExchangeType 1 2006-08-30 16:17:34.206 Connecting to subscriber
Store_Server\instancename 2006-08-30 16:17:34.268 Connecting to Distributor
'Centre_Server' 2006-08-30 16:17:34.518 Initializing 2006-08-30 16:17:34.534
Connecting to Publisher 'Centre_Server' 2006-08-30 16:17:34.690 Retrieving
publication informa

This is all the message it displayed in the job history.....please help me
what is wrong. (i feel there is something with timestamp).......

--
Cheers
Re: Merge Replication-Pull Subscription-Error? Vikas
8/31/2006 8:43:02 AM
Hi Hilary

I did not get any other message apart from. this is the only
message appears every 5 minutes.
--
Cheers



[quoted text, click to view]
Re: Merge Replication-Pull Subscription-Error? Hilary Cotter
8/31/2006 4:08:47 PM
can you enable logging and post the log here. Here is a kb article
discussing logging.

http://support.microsoft.com/default.aspx?scid=kb;en-us;312292&sd=tech

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



[quoted text, click to view]

AddThis Social Bookmark Button