sql server replication:
In SQL 2000 right click on your agent in the merge agents folder and select Agent Properties, and then Steps, double click on Run Agent, Then in the command box hit the end key and type -QueryTimeout 300. Close down the dialog and stop and restart your agent. In SQL 2005, right click on the Replication Folder to launch Replication Monitor and expand your publisher tree, click on your publication in the left hand pane, and then right click on your subscription in the right hand pane. Select View Details, and then select the action menu. Select Merge Agent Job Properties, click on the Steps tab, and click on run agent, click on Edit. Make the change as with SQL 2000. -- 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] "jaylou" <jaylou@discussions.microsoft.com> wrote in message
news:79A363D5-2AF3-4F1F-B61B-442F8F99E7F7@microsoft.com...
> Hi all,
> I have one out 20 merge replicaion that just hangs and never ends at step
> 2
> which is the run agent step.
> I added -Output "E:\ReplStepLogs\repl.txt" -OutputVerboseLevel 2 to my
> run
> agent step of the job. In the file I get the below error over and over.
> I
> am not sure what query timeout this is referring to. I have my remote
> query
> timouts on both server set to 0 (unlimited) remote logins are set to 60
> for
> both as well.
>
> TIA,
> Joe
>
> The merge process failed to execute a query because the query timed out.
> If
> this failure continues, increase the query timeout for the process. When
> troubleshooting, restart the synchronization with verbose history logging
> and
> specify an output file to which to write.
> 2007-06-18 04:46:33.504 OLE DB Distributor 'SQL1': {call
> sys.sp_MSadd_merge_history90
> (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
> 2007-06-18 04:46:33.519 Percent Complete: 0
Hi all,
I have one out 20 merge replicaion that just hangs and never ends at step 2
which is the run agent step.
I added -Output "E:\ReplStepLogs\repl.txt" -OutputVerboseLevel 2 to my run
agent step of the job. In the file I get the below error over and over. I
am not sure what query timeout this is referring to. I have my remote query
timouts on both server set to 0 (unlimited) remote logins are set to 60 for
both as well.
TIA,
Joe
The merge process failed to execute a query because the query timed out. If
this failure continues, increase the query timeout for the process. When
troubleshooting, restart the synchronization with verbose history logging and
specify an output file to which to write.
2007-06-18 04:46:33.504 OLE DB Distributor 'SQL1': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
Thank you very much. I need to find a SQL 2005 replication book. This is my first replication I have to manage. When it works it is great, but when it doesn't it nice to have this comunity to help out :) [quoted text, click to view] "Hilary Cotter" wrote: > In SQL 2000 right click on your agent in the merge agents folder and select > Agent Properties, and then Steps, double click on Run Agent, Then in the > command box hit the end key and type -QueryTimeout 300. > > Close down the dialog and stop and restart your agent. > > In SQL 2005, right click on the Replication Folder to launch Replication > Monitor and expand your publisher tree, click on your publication in the > left hand pane, and then right click on your subscription in the right hand > pane. Select View Details, and then select the action menu. Select Merge > Agent Job Properties, click on the Steps tab, and click on run agent, click > on Edit. Make the change as with SQL 2000. > -- > 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 > "jaylou" <jaylou@discussions.microsoft.com> wrote in message > news:79A363D5-2AF3-4F1F-B61B-442F8F99E7F7@microsoft.com... > > Hi all, > > I have one out 20 merge replicaion that just hangs and never ends at step > > 2 > > which is the run agent step. > > I added -Output "E:\ReplStepLogs\repl.txt" -OutputVerboseLevel 2 to my > > run > > agent step of the job. In the file I get the below error over and over. > > I > > am not sure what query timeout this is referring to. I have my remote > > query > > timouts on both server set to 0 (unlimited) remote logins are set to 60 > > for > > both as well. > > > > TIA, > > Joe > > > > The merge process failed to execute a query because the query timed out. > > If > > this failure continues, increase the query timeout for the process. When > > troubleshooting, restart the synchronization with verbose history logging > > and > > specify an output file to which to write. > > 2007-06-18 04:46:33.504 OLE DB Distributor 'SQL1': {call > > sys.sp_MSadd_merge_history90 > > (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} > > 2007-06-18 04:46:33.519 Percent Complete: 0 > >
Don't see what you're looking for? Try a search.
|
