The client production server CPU starts thrashing. Task manager indicates that SQL server is gobbling CPU cycles. Having a look at the replication monitor, it is obvious that indivual synchronisations to the mobile devices are taking significantly longer expected. Observing an indivual sync...more >>

I am using MSSQL 2005 with Transactional Replication Is there a way to replicate Users and all the User Mapping settings? Thank you in advance. ...more >>

I'm very new on the project here. We had a transactional replication machine fail over night with the following event log message. SQLSERVERAGENT - " Microsoft SQL Server Replication : The C:_Program Files_Microsoft SQL Server_80_COM_distrib.exe executable is terminating abnormally because i...more >>

Hi everyone, We have transactional replication between a data entry and reporting servers. Now, in addition, we added another subscriber which is a test server. This new subscriber has a strange problem that stopping and starting a distribution agent can cause a subscription to be marked in...more >>

Hi All, I setup a replication from one SQL 2000 server (A) to another (B). Before creating a replication I scripted a database on a server A and ran a script (successfuly) on the server B. It created all tables, views, sps, etc. After a snapshot had been generated and synchronization be...more >>

Hi Guys, Trying to fathom out my replication issues... Got two boxes running SQL Server 2000, reporting version 8.00.2162. Trying to set up Merge replication between them, using FTP. Publisher/Distributor is Windows 2000, Subscriber is Windows 2003. SQL Server and the Agent are both runni...more >>

Dear All, I am trying to put distirbuter and subscriber on the same SQL Server Machine. I achieved to enable the remote distributer on my server 2.I was able to enable server1 as a publisher. I wanted to create my publication on my server 1 and use the server 2 as a distributer and the subscrib...more >>

Dear All, I am very new to SQL Server replication, currently I am using SQL Server 2005, could any body please inform me where can I get the step by step guidance for building a DB replication.. Please advise.. Thanks & Regards Winanjaya...more >>

When i configured snapshot replication for the database. It was done accordingly but in replication alerts i found series of alerts like: 1. agent custom shutdown 2. agent failure 3. agent retry 4. agent success 5. expired subscription dropped 6. Subscriber has failed data validat...more >>

I'm having severe troubles getting replication to work reliably from SQL Server 2000 to Oracle. I've configured the replication to work periodically rather than continuously. The basic issue is that every time the replication is activated, an attempt is made to create the table msrepl7, and sinc...more >>

...more >>

Hi , This is from BOL : where it said it can improve on the performance on Generating & Initializing snapshot How to set the – UseInprocLoader property (Enterprise Manager) On the server where the Distribution Agent or Merge Agent is running, expand the Replication Monitor node, click the...more >>

Hi, I'm running SQL Server 2005 Standard edition. In SQL Server Management Studio when I right click on replication and select New I can only create a Subscription. Why can I not create a publication? Thanks, Aidan ...more >>

We have developed a mobile system that use merge replication for SQL Mobile to SQL 2005. Previously we have developed mutliple mobile systems using merge replication for SQL Ce to SQL 2000. Based on the knowledge we had gathered over about 4 years, we applied the synchronisation parameters ...more >>

Hi there, We are currently reviewing upgrading our Transactional Replication from SQL 2000 to SQL 2005. Out test environment consists on SQL 2000 Publisher, SQL2005 Distributor, SQL 2000 Subscriber, and a SQL 2005 Subscriber across 4 different servers. We successfully configured a transact...more >>

Hi: I want to add an article to existing publication using Transactional Replication. If I run the snapshot agent, will it run just for that article or for all the articles in the publication. I only want to run for article because other articles are huge and it will create performance pr...more >>

I know that I should just try this, but I thought I'd ask anyway. I set up db mirroring between 2, 2k5 servers. The mirror dbs are in a (Mirror, Syncronized, Restoring...) state. If I had restored the dbs on the Mirror server using STANDBY, would the database be accessable in read-only mode ...more >>

Hi All, I setup a transation replication. Everything seemed to go very smoothly when I set it up. When my snapshot ran it failed due to this error: "The process could not create file '\\RP3\MSSQL\MSSQL\REPLDATA\unc'." Access denied. can someone tell me what account runs the Repl agent and ...more >>

Hi, What are all those procedure ending with _pal? sp_sel_FBB67B0A93364BEDE88DF94B39ED4222_pal Is that come from a replication? I use to have a replication on that database and I drop the replication Does those procedures should be deleted If Yes can I just deleted One by One or Is th...more >>

Hi, I'm in the midst of performing a replication on SQL 2005, however i'm not too sure how CPU intensive is the replication service. Does anyone know whether do 2 CPU enuf for replication purposes....more >>

i want to write an application to collect information about how many transactions does not currently not replicated to subscriber at the time of call. where and how can i find these information ?...more >>

Hi, I have setup replication but it's not very stable i.e sometimes the connection is bad, in this case will using bcp & bulk insert help to allow me to transfer the data faster ? i have tried to use the following commands : bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_...more >>

Simply a curiousity thing, as it seems somewhat a pointless setting, so I'm wondering if anyone knows why the default Identity ranges are set at 100? I cannot envision a scenario in the real world where 100 would do anything but create more problems down the road. ...more >>

Dear all, I would like to replicate the data from HQ to the other region. This region only have dial up access to the internet. In order to make the 2 database between HQ and other region syhcronized, i am thinking about using database replication of sql server. Few questions i would like to ...more >>

Hello, In SQL Server 2000, there is an option to not lock the tables (articles) contained in a publication when a snapshot is taken. I do not see the option to set this in SQL Server 2005. Does it automatically not lock the tables when taking the snapshot? Or am I just not finding where to...more >>

Hi, In SQL 2000, if the replication is down, how can I have it automatically backup? There is going to have a long down time if the operation can't reach the server right away. Any help will be appreciated. Thanks in advance! Lisa...more >>

I will be snapshotting quite a few million rows (100 million + ) and want to get it completed fast. Will be using transactional replication Where can I specify the -UseInprocLoader and-MaxBCPThreads settings for the snapshot and distrib agent ? What parameters should I provide ? I have a 4...more >>

Bonjour, J'ai un développement à réaliser qui comporte une saisie déportée sur des sites distants. Les données doivent être mémorisées sur le poste de travail de l'utilisateur. Une ligne VPN sera installée entre les différents sites et un serveur centralisé au siège. Si la liaiso...more >>

SQL 2000 sp4 on publisher and subscriber The publication is a filtered merge, publication has been working fine, replaced subscriber box with new blade server - same pc name/same ip/same sql name, SQL 2000 sp4. 3 replicated databases - 1 small merge, 1 small transactional, 1 large merge I set...more >>

Acording SQL Server 2005 Books Online: http://msdn2.microsoft.com/en-us/library/ms173543.aspx [...]If your application has immediate-updating Subscribers, sp_publication_validation may detect spurious errors.[...] We are using transactional replication with queued updates on SQL Server 200...more >>

Hello, I'm trying to install a transaction replication and get this error by start of the snapshot-agent: 1224 The requested operation cannot be performed on a file with a user-mapped section open. Both servers are sql2000 with SP4. A test-replication with northwind works. The proce...more >>

Hi, Anyone knows which editions of SQL 2005 support peer-to-peer replication? Thanks in advance ...more >>

Hi , My snapshot agent was suddenly showing the above message and when i tried to look into the agent's history it did not show me any error details . i simply right-click the snapshot agent and --> start agent and the error disappears but what cause that error ? appreciate ur advise...more >>