Solved

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

Posted on 2007-03-26
2
376 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now