Solved

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

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

680 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