Solved

SQL 2005 server Merge replication - no Merge properties or agent ??

Posted on 2007-03-26
2
379 Views
Last Modified: 2012-05-05
I'm using SQL 2005 server SP2 on an SBS2003R2 server and SQL 2005 Express server on a Windos XP pro SP2 workstation. The SQL database is merge replicated on the XP workstation but I can't seem to gain access to the MergeAgent properties or find where to set a schedule (I want to replicate hourly).

When the merge, pull subcription was set up it only allowed 'on demand' synchronisation (no schedule could be established) I have read that one should be able to adjust the properties of the merge job but there is no "Job Folder' or server agents list displayed within the SQL Server Managment studio Express.

Can anyone tell me what I need to do to expose these properties, they must exist since I can synchronise through the synchronise application which is native to XP but this does not allow hourly scheduling.

I also notice that the sqlserveragent  is not running at the subscriber. I would expect it to be running wouldn't I????

Hope someone can help???

Regards
Trevor
0
Comment
Question by:TrevorWhite
  • 2
2 Comments
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18794872
Checkout this topic in SQL Server 2005 Books on Line:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/449a2f57-fcbd-4478-8f21-2c646d801699.htm

Specifcally:

SQL Server Express does not include SQL Server Agent

If you are upgrading to SQL Server Express Edition (SQL Server Express), you must reconfigure replication synchronization because SQL Server Express does not include SQL Server Agent.

If you want to use pull subscriptions, you must synchronize them using Replication Management Objects (RMO), Windows Synchronization Manager, replication ActiveX controls, or by running the agent at the command line. For more information, see Replicating Data to SQL Server Express.

If you want to continue to use SQL Server Agent to run replication agent jobs, you must use push subscriptions or upgrade to a different version of SQL Server (all versions except SQL Server Express and Microsoft SQL Server Mobile include SQL Server Agent). With push subscriptions, the Distribution Agent or Merge Agent runs at the Distributor, so SQL Server Agent is available (SQL Server Express cannot be a Distributor).

I

0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18794893
So you could run the agent at the command line and schedule it with the AT scheduler.

You could also probably create a job on the publsher to run the merge agent on a schedule. I have not tried this but ti should just be a matter of specifying all the parameters for the agent in a job on the publisher and then scheduling that job.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DTS Connection Failed 7 70
How to share SSIS Package? 6 37
SQL Server - Set Value of Multiple Fields in One Query 10 25
Show Results for Latest DateTime in a View 27 25
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question