 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / August 2006Merge Replication-Pull Subscription-Error?
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).......  SignatureCheers 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? SignatureHilary 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 > Hi all, > I have a issue with merge replication. I have setup replication [quoted text clipped - 40 lines] > This is all the message it displayed in the job history.....please help me > what is wrong. (i feel there is something with timestamp)....... Hi Hilary I did not get any other message apart from. this is the only message appears every 5 minutes. SignatureCheers > 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? [quoted text clipped - 43 lines] > > This is all the message it displayed in the job history.....please help me > > what is wrong. (i feel there is something with timestamp)....... 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 SignatureHilary 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 > Hi Hilary > [quoted text clipped - 54 lines] >> > me >> > what is wrong. (i feel there is something with timestamp)....... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.