Distributor/Publisher and Subscriber: Windows Server 2003 SP1 SQL Server 2000 SP4 Distributor/Publisher and Subscriber created through SQL Server wizardry. Asked for initial Snapshot to be created immediately. It wasn't. Snapshot Agent shows as "Never started". Right-clicking on the Snap...more >>

I'm running dev edition of sql2k5 on a Windows 2003 sp 1 pentium 3 with 512 megs ram. I am trying to evaluate if my company wants to migrate to 2005. In doing so, I am setting up transactional replication with queued updating subscribers. Both the publisher and single subscriber machines ha...more >>

Hey gang, I am trying to add a column to a replicated table and am a bit confused at the syntax that goes into the Column definition. I need to add a datatype which in design view on other tables looks like: DefaultTimeDataType (char) with a length of 8 But according to the "Add Column...more >>

If I truncate a replicated table, will replication freak out in any way? Will the truncate get replicated? I want to delete the primary table and not replicate the changes. Is truncation the best method?...more >>

Hi to all I have a merge replication over a database on sql 2005 How can i keep the log file of the database small in size without messeing my replication? Thanks is Advance Savvas Christodoulou ...more >>

Hi ive been having masive problems setting up replication between to sql 2005 whgrp boxes. following advise from here Im now following these steps: 1. Create publication and select ‘copy full text indexes’ to true 2. Create replica database, and tick to allow full text replication and...more >>

Hi! My user defined functions have permissions setup on a primary server. Two users are allowed certain access. When I am replication the whole database to another server those permissions are not being replicated (despite of the fact that those users are defined on a destination server). I...more >>

Hi I am having transactional replication between SQL Server 2005. However by data is not getting replicated to subscriber database. When I look into Replication Monitor under "Publisher to Distributor History" it gives message as - 'No replicated transactions are avaialble' and no actions ...more >>

Hi, every morning my replications down in timeOut and i can Restart ! Why replication TimeOut ? and how can repair this ? Thank's ...more >>

I am doing a project to migrate a replication program from SQLServer 2000 to SQLServer 2005. This program is used to replicate SQLServer's data to an ODBC/DSN subscriber. The programing can not successfully replicate SQL to ODBC, I have check the error-log , it seems that, SQLServer pull SQLs ...more >>

I am doing a replication program for replicating SQL SERVER 2000's data to an ODBC subscriber in pull mode using Microsft SQLDistribution ActiveX Control, my code is like /* initialization some properties of the SQLDistribution object */ hr = ::CoCreateInstance(CLSID_SQLDistribution, NULL, CLSC...more >>

Server 1--Publisher/Distributor: Both Windows Server 2003 SP1 Both SQL Server 2000 SP4 Used "Configure Publishing and Distribution Wizard". Used "Create Publication Wizard". Used ToolsàReplicationàPush Subscription to Others. Server 2--Subscriber: Both Windows Server 2003 SP1 Both SQL Se...more >>

Hello there, I have pull type of replication setup. I see the error in Distribution Agents as Invalid Column name "XXX" and the error number is 207. Any ideas how I can troubleshoot this problem? Thanks in advance...more >>

I replicate data between SQL Server 2000 and SQL CE 2.0 mobile devices. I have configured my table in question to have 1,000,000 for the publisher range size and 100 for subscribers. I left the default of 80 for the percentage where a new range is assigned. The table's primary key field is ...more >>

We are using transactional replication on SQL Server 2005 SP1 When we add new article snapshot agent create a snapshot of all articles which takes too much time but I want only snapshot of new added article. Is it possible to create snapshot of only new added articles and apply it at subscrib...more >>

Hi, We are planning to move our production database to a test server and were thinking what would be the right way to do it? We want to replicate the data nightly. Would peer-to-peer replication be the way to do it? Thanks, Abhi ...more >>

Hi, We have two SQL 2000 boxes connected with transactional replication. The publisher has a trigger on one of the tables that checks the inserted date format and changes it as needed. That works. The problem is that replication fails to move those records over, and it looks it is grabbing...more >>

Hi Im trying to set up SQL replication between two SQL 2005 Workgroup ed boxes - Its a Mail archive (created by GFI mail Archiver Program) that I am trying to replicate for Disaster Recovery Purposes. Im a newbie so Im taking a tiny step forward, hitting a wall, Googling for half and hou...more >>

What's the best way to delete data on a published database and NOT have the changes replicate to the subscribers for a particular transaction? We have transactional replication setup. I need to delete about 100,000 records but I don't want the changes to flow through to the replicate side on ...more >>

I've noticed that the msmerge_history table in the subscriber is very large compared to the size of the actual database. How do I clean up this merge replication history? I don's see the agents tasks ("subscription cleanup at publisher" or "history cleanup at the distributor") descirbed in...more >>

Hello, I took over a project a few months ago, and I am not a replication person at this time. I tried to truncate the log file using standard tsql but was not able to because the DB is under replication. Ideally, I would like to turn off the replication, detach the DB, delete the log fi...more >>

Hi, We have around 4 regional servers and 220GB database is in replication amidst all four. There is no filtering of published data (as every server needs everything). We have decided to go with merge replication as updates can happen in any server and conflict resolution is also needed. Mos...more >>

Hi, I've been tasked with investigating different methods of achieving database redundancy. In doing so, I'm currently in the process of writing a test application to prove that Database Mirroring in SQL Server 2005 is a suitable solution. Of the established requirements I'm finding dif...more >>

Cross-posting from SQLServerCE newsgroup We are implementing a Pocket PC application that will require frequent updates (effectively a server push) and are considering Merge Replication between the SQL servers. I am trying to get figures as to the "background" data volumes involved, that...more >>

I want to setup merge replication, I get my database with data and all its objects on the machine which is going to be Publisher and Distributor. I create the Database with Table and its primary keys on Subsriber Machine. I have not yet created the Foreign key relationship on subsriber wh...more >>

Hi Folks, I am having a database on SQL Server 2000, I want to get this database on SQL Server 2005, To do this we have our Create table scripts of the database, and Alter Table Script to apply the constraints like Foreign key and unique key which we run after creating the table. I r...more >>

Hi, I am in need of knowing which type of replication is the best to use in SQL server. My application runs at the server place and there are client processes running in remote which gets connected to this server process . The server application updates the DB. There is a sub ...more >>

I've setup a Merge Replication between SQL Server 2005 (Publisher) and SQL Server 2005 Mobile Edition (Subscriber). This works just fine over HTTP. I now want to run this using SSL and I can't get it to work. I run Configure Web Synchronization Wizard with these selections: - SQL Server Mob...more >>

I'm trying to move a database from MySQL to SQL 2000 Server, but I succeed only partially. Especially the primary indexes are not transferred. I'm doing this because I have a database model developed with fabForce.NET DBDesigner which is then transferred to MySQL (with a few problems) Sinc...more >>

We are having a problem where someone will change the date on a computer, for whatever reason, and if a replication sync starts while that date is changed then the replication will not run again until the date hits that changed date. Meaning if the date is 7/1/2006 and someone changes the da...more >>

Hi, All the documentation I see says that it should be possible to make transactional replication work with database mirroring in SQL2005 but I can't get it going. >From what I read, setting the -PublisherFailoverPartner parameter on the Snapshot and LogReader agent should take care of ever...more >>

Hi, Following is the code snippet class RDA { private static string _serverName = "seed"; private static string _databasePath = @"My Documents\rda.SDF"; private static string _localConnectionString = "Data Source=" + _databasePath; private static string _internetUrl = "http:...more >>

I've setup Merge Replication with SQL Mobile and I've noticed conflicts in the Conflicts Table. I've setup the Conflict Resolved to be DateTime(Later Wins). The problem is when I have conflicts I have to manually go in and click 'Accept Winner' or 'Accept Loser'. I thought the idea was tha...more >>

Hi I have publisher and Subscriber in place and its working fine. Now I have to add new column in one of the article in publisher. How to replicate this schema changes to subsriber using Transactional Replication? Regards Makarand...more >>

Hi, I'm trying to subscribe from one instance (S1) to two publishers (P1 and P2). When S1 first subscribes to P1 and then to P2, only three triggers are created in the S1 for my table. These triggers belong to P1. Therefore when a change is made on S1, it is propagated only to P1. When S1 s...more >>

Hi, I have just started on a new project and have the responsibility of setting up the SQL Server replication architecture. I wonder if anyone can give me advice on the way to go? We have a setup of 6 SQL Server 2005 servers which should all be replicating to each other, connected to these...more >>

Hi, I have a desktop system that uses merge replication with one pull subscription. For my app that runs on the subscriber, I have code to get the subscription job's status and restart the job if it's not running, using sp_help_job and sp_Start_Job. It would be useful if I could also tes...more >>

Hi, i have problem with reinitialization with the merge subscription, i made the mistake and i clicked REINITIALIZE ALL SUBSCRIPTIONS, now after running merge agent trying to apply new snapshot, how can i undo this operation? how can i unmark all subscriptions for reinitialization? t...more >>

Has anyone had problems with applying SQL 2005 SP1 and "Cumulative hotfix package (build 2153)" to the publisher/distributor and not subscribers? Or does anyone know if there are build conflicts between a patched publisher/distributor to a RTM subscriber? The reason I ask is that I have pe...more >>

Hi everybody, I wish to manage the process of transactional replication between two SQL databases using a c# written tool(or any other possible language, does not differ). More accurately, I have a database in my server, and I want to have the program to be run from another computer and doe...more >>

Hi, Does adding a new column to an article need the whole of publication to be re-sent to the subscriber in Transactional replication or this change can be propagated like Merge replication? What about adding a new article to the publication? Thanks in advance, Leila ...more >>

Hi, I want to perform replication between three servers (one publisher and two subscribers). These three have the same database structure but they have their own data. It means that I cannot apply the snapshot of one to the other because the receiver will loose its own data. What's the best so...more >>

Greetings, I have a SQL 2000 server setup as a publisher and distributor for transactional replication. I created a pull subscription from my SQL 2005 box and everything looks fine. It's been running for two days now and has not updated any of the data on the 2005 box yet. Is there an issue u...more >>

Hi all, We don't know database very well and we are using both MS SQL 2000 and MySQL from our hosting company. So far, we are lucky for not experiencing any problems. But we wish to know how could we "replicate" or "backup" the database (if possible) and the data (including tables, if p...more >>