Hi Chandra
I do not get any error messages at all, they just will not
restart, I am running on them on continuous
Thanks
Steve
[quoted text, click to view] >-----Original Message-----
>Hi -
> When you tried to restart, were you getting
any error message?
>If so, what is the error message?
>how are you running the agent? On schedule or continuous ?
>
>Regards,
>Chandra
>--------------------
>||Content-Class: urn:content-classes:message
>||From: "Steve" <anonymous@discussions.microsoft.com>
>||Sender: "Steve" <anonymous@discussions.microsoft.com>
>||Subject: Merge Agents will not restart
>||Date: Fri, 6 Feb 2004 01:23:54 -0800
>||Lines: 5
>||Message-ID: <b77901c3ec92$f0bf11e0$a001280a@phx.gbl>
>||MIME-Version: 1.0
>||Content-Type: text/plain;
>|| charset="iso-8859-1"
>||Content-Transfer-Encoding: 7bit
>||X-Newsreader: Microsoft CDO for Windows 2000
>||Thread-Index: AcPskvC/fcrHBWYNTYq6lciyRIZTEg==
>||X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>||Newsgroups: microsoft.public.sqlserver.replication
>||Path: cpmsftngxa07.phx.gbl
>||Xref: cpmsftngxa07.phx.gbl
microsoft.public.sqlserver.replication:47042
>||NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
>||X-Tomcat-NG: microsoft.public.sqlserver.replication
>||
>||I have 14 merge agent jobs that are replicating to two
>||different SQL 2000 servers, They all run OK on their
own
>||but when i try to run them all together it will not let
me
>||restart more than 8 of them. They all run under the
same
>||user name. has anyone come across this before?
>||
>
>.
Hi,
By default, SQL Server is limited to 100 simultaneous merge agents running.
This is much higher than the 8 agents you can run. Please check this
registry entry and verify that the value for the merge agent is high enough.
HKLM\Software\Microsoft\MSSQLServer\SQLServerAgent\Subsystems
If the value is set to 100, there may not be enough resources on the server
to start all the merge agents at the same time. SQL Server Desktop Edition
(MSDE) is limited in the number of simultaneous connections, so you might
be hitting that limitation.
Regards,
Shirley
SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.