i have a replication "rep1" which is done for a table named "customer" i have to have another replication "rep2" done for 2 tables name "customer" and "supplier". Both publications is found on the same machine that is machine A and both subscriptions is found on mahine B The replication rep1...more >>

Does anyone know if MSDE can use replication of any kind? I'm looking to gather up many tiny databases and pull them into a larger 2000 box that is Processor licensed. I read that you can set up replication manually using scripts, but the document didn't go into much detail. ...more >>

Hello When i am Synchronizing(SQL2005 merge replication) I can see the duration of the Synchronization on the Replication monitor and i can see that lets say an "initial loading" of the database with lots of data is taking 4 minutes but on the handheld if i take the time of the Synchroni...more >>

I am using trasactional push replication on 2005. So, first I do this: EXEC sp_addarticle @publication = N'azDSS', -- Change value with the name of the publication we wish to add to @article = N'tbPhxSrvrpf', -- Change value with the name of the article we are adding @source_owner =...more >>

I need to take backups of all DBs in the server into another serve, which should be done automatically once a particular period of time(say 30 mins or 2 hrs or 5 hrs etc..). Please help me to do so with step by step explanation. iI am new to SQL Server. -- Regards Angelin Enita.A ...more >>

I've completely removed replication from the publisher/distribution server and reconfigured a number of times, however my Windows CE 4.21 4.21 Windows Mobile 2003 Second Edition (Pocket PC 2003 SE) still triggers an error on calling : SqlCeReplication.Synchronize() "A request to send dat...more >>

http://support.microsoft.com/kb/902320/en-us This article is titled "The Snapshot Agent fails and a "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION" error message may be logged in the Snapshot Agent log in SQL Server 2000" and is exactly the problem that I have. Howe...more >>

Hello I have a database of 52 replicated tables . I am using several filters on my Merge Replication and I can synchronize my handhelds just fine. The problem is that after some updates of the my main database(SQL 2005) when i try to synch the handhelds i get an 28549 error for a table. ...more >>

Hi i need to know how would it be possible to configure SQL 2005 and 7 to replicate with each other. SQL 7 will need to be the publisher and SQL 2005 will be the subscriber. SQL 2005 will not update back any data to SQL 7 but just read the changes made and store it into the sql 2005 databas...more >>

Snapshot Error Details: ----------------------------- Invalid object name 'sysarticles'. Invalid object name 'sysarticles'. (Source: SQLServer2B (Data source); Error number: 208) -------------------------------------------------------- Thanks! Michael...more >>

I have 3 SQL server 2000 involved in Replication which will need to be upgraded to SQL 2005 Publisher Distributor Subscriber Can I upgrade the 3 servers without interruption of replications meaning I would not need to reinitialize my subscription. Thanks, Omran ...more >>

Other than the following constraints on "Concurrent Snapshot Processing", is there any reason NOT to check the "Concurrent access durning snapshot generation" option? Known Constraints: --Must run log reader agent after snapshot generation --Primary key or unique constraint must be contai...more >>

Hi, I am getting the following error when trying to insert a record into a table at a subscriber. Table '[dbo].[Customer]' into which you are trying to insert, update, or delete data is currently being upgraded or initialized for merge replication. I droped replication at suibscriber an...more >>

Hi, We currently have Merge Replication setup on a Sql Server 2000 running on Windows 2000 Server as publisher. Same configuration servers (45 units) are acting as Subscribers. We want to replace one of our subscriber servers and run on Windows 2003 server/Sql2000 configuration. What issues ...more >>

Hi, Help me to take live back ups of my db in one server into another server... -- Regards Angelin Enita.A ...more >>

I just talked to Microsoft and I was told to do push subscriptions instead of pull, to run the distribution agents on the distributor. I have come across different resources that say otherwise... What is the best approach with a distributed topology. Thanks!...more >>

Yesterday, we attempted to add a new table to an existing publication. We then created the table on the subscriber and populated it manually. We expected that replication would then take over the data flow to this table. This morning, I found that the log reader had failed with the following: ...more >>

I am trying to work out what the difference is between the above and merge replication. Does anyone know what the difference is?...more >>

hi, i have been playing around with the custom resolver for merge replication. i have a merge publication with 1 article having non overlapping partitions dynamic partitions going to a single partition. i have 2 subscriptions which had row tracking enabled. i changed the resolver to microsoft s...more >>

Hi, I have a merge replication with two sql server 2000 sp3. The schedule of the merge is periodic every 10 minutes. Though no change has taken place in any of two databases, always massive insertions take place by the suscriptor. Why?.That I must do?. Thank you in advance and sorry for my ...more >>

After many pain staking hours, I have rebuilt my replication setup so that we are now running our publisher on one server and our distributor on another as recommended by Microsoft. Although data QC seems to show that the data is replicating fine... Replication monitor (running on the publish...more >>

We currently run MSSQL 2005 with updatable transactional replication. I would like a compare MySQL to MSSQL when it comes to replication. I have several people telling MySQL replication smokes MSSQL replication. Does anyone know of any good articles on this subject? Thanks in advance, Br...more >>

The "Disable Publishing and Distribution' wizard fails. It corresponds to the tsql use master exec sp_dropdistributor @no_checks = 1 go The error is Msg 208, Level 16, State 1, Procedure sp_MSmergepublish db, Line 103 Invalid object name 'dbo.sysmergesubscriptions' ...more >>

I setup a merger replication publisher/distributor on the sql server 2000. The users with pc have sql express 2005 loaded. When i set the subscriber through the wizard on the sql express i get the following error: Error: For merge publications, the version of the subscriber must not exceed ...more >>

I setup a merger replication publisher/distributor on the sql server 2000. The users with pc have sql express 2005 loaded. When i set the subscriber through the wizard on the sql express i get the following error: Error: For merge publications, the version of the subscriber must not excee...more >>

I've noticed that the Distribution db is not present on a fresh instance of SS05, but then apparently is created on creation of a replication publication or subscription. Does anyone know, is it safe to delete the Distribution db ? ( Assuming no publications or subscriptions are present on...more >>

I am using SSMS : For a Sql Server 2005 merge replication publication with SQL Mobile 2005 subscribers, repeatedly deleting and recreating the publication has led to a state where SQL is unable to recreate the publication, and also is not able to create a publication of another table. T...more >>

For SS05 : Which system sprocs recreate all replication related tables ? Also, the order in which to run the sprocs. Thanks. ( I'm assuming that all publications and subscriptions have been deleted ). ...more >>

Hello, I am inquring for suggestions on how develop for an application. We currently have a SQL Server 2005 database that is set up as a publisher. It has SQL Mobile subscribers. We have a custom application that is able to read and write to that Mobile Database on the PDAs. We have also pr...more >>

Hi, Is there any way in SQL 2000 to have a confilct resolver which does not update either the Publisher or the Subscriber, but waits for intervention to decide which is the winner? Thanks, Natalie ...more >>

SQL 2005 Replication Monitor Question.... Is there any way of sorting the publications with in the publishers so that they are grouped by their name rather than in the order they were added?? To quote Hilary....'Its on days like this I pine for Enterprise Manager' AHIA, Larry.... ...more >>

I'm working on setting up replication on a database in SQL 2000 and get the following error: Implicit conversion from data type text to nvarchar is not allowed. Use the CONVERT function to run this query. (Source: MYBACKUPSERVER (Data source); Error number: 257) Why would this occur? I do...more >>

hello, I have a big problem with quereader agent, the agent was stopped since 3.00 am of today, when i try to start it tries to deliver the transaction in the queue to the publisher and after 10 tries goes in a strange loop and there is no way to stop it. In every retry of the service a unh...more >>

Hi all, I'm implementing Business Custom Logic Conflict Resolver. My confict resolver works just fine. But I have the following problem. When UpdateConflictsHandler executes I receive as parameters only publisherDataSet and subscriberDataSet. In this datasets I receive actual data towa...more >>

What are the implications of restoring a roughly 50 gig database daily to another server versus setting up the entire database for a replication subscription from the production server? -- Regards, Jamie...more >>

Hi, It has been a while that I have been struggling with an issue of Identity Range. I have manually assigned Identity Ranges to the table. Inspite of assigning a good range of 1000 records after adding only 100 records the table says that it is out of identity range. Why is that? Ple...more >>

Hi, I'm hoping for some insight into this problem. We have Merge Replication setup over FTP and has been working without issues. The last database update we generated a new snapshot and has cause problems since. The snapshot generates fine. When we synchronize uses get the infamous "The schem...more >>

Using SQL Server Agent as the Snapshot Agent account is not a recommended best security practice. If a domain account is used, what rights and permissions should it be granted ? ...more >>

Is it possible to have 2 database on 2 SQL servers and replicate between them both. ie. Each server being a subsribed and a publisher. If so how do you maintain data integrity between the two ? Si...more >>

I am on SS05/SSMS on WXP SP2. I've created a Replication Local Publication: this is a merge replication publication of the Northwind Orders table. In SSMS, I right-click the publication, but the "Configure Web Synchronization" menu choice is not available. Could this be due to SS05 bein...more >>

I was looking at performing replication and would like transactional replication...but my system says my licence does not allow for transactional replication. Does anyone know how to get this enabled? Do I need to buy another licence or a different kind of licence? Thx for replies. Bill...more >>

Running SQL Server 2000. I removed the subscription and publication from a database but the database is still showing that it is being replicated. I have checked the tables in the distribution database and that database is not listed. Anyone lese ver have this problem or now of a solution. -- ...more >>

For a configured local publication, how to edit the snapshot agent security settings ? ...more >>

Hello, I am using Replication Monitor for SQL 2005. I can't seem to find the Tracer Token tab. I clicked on a particular publication in the left pane of the Replication Monitor, the right pane will have two tabs: All Subscriptions, Warnings and Agents, but I can't see to figure out how to mak...more >>

We have an application that we need to replicate but the suppliers say that their application does not support SQL replication. Can anyone recommend a good third party replication tool ? Also if the application does not support SQL replication would this mean that a 3rd party tool couldn`t be ...more >>

Hi We've got a problen in a customer with SQL Server 2000 SP3 and merge replication with PocketPC We have some triggers FOR UPDATE on the same field used to distribute in replication settings, so I suspect sometimes our triggers didn't work, and sometimes the first trigger that has been ...more >>

Hello, I have a merge Replication database with 50 tables. Almost all my tables have identity columns. Now the subscribers of this Publication database cannot "Insert" or "Delete" data on tables that have identity columns. My question is , Would it be better to set the "Not for Replication" o...more >>

Using SQL Server 2000 transactional replication which is running continously to populate our reporting server. We have a thrid party software which we need to use a interface to take a cvs file and import it into their database. The interface requires that it has exclusive access to the database....more >>

After running a merge replication consistantly for a couple of months, I needed to remove a table from replication so that I could modify the datatype on one of the fields (This table was really unnecessary on the subscribed db). I removed the table from replication by sp_MSunmarkreplinf...more >>

I am documenting our disaster recovery plans and I was wondering if anyone has any experience with failing over to a log shipping secondary in a replicated environment. If I log ship all user databases, and msdb, and distribution to a secondary server, all to an exact point in time (after d...more >>