Solved

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

Posted on 2007-03-26
2
372 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
Comment Utility
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
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

771 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

11 Experts available now in Live!

Get 1:1 Help Now