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 >>

Here is my topolgy: I have one server acting as both publisher and distributor. The publisher has a one way transactional publication. This publication has two articles with blob columns, one is ntext and the other is an image (ItemDescriptions and ItemImages, respectively). Everytime I make a l...more >>

I simulating transactional replication on network with high bandwidth but with big latency (it is expected between Chicago and Singapore). I set 400 ms network latency and unlimited network bandwidth, with usage of network delay simulation software. Next I measure rates at which transactions a...more >>

Hello i have a an application developed in vb6.0 and back end sql server 2000. i have a batch file that i created to replicate the data from the sql server 2000 on my pc(local) to replicate on another sql server 2000 which is found on another machine and the batch file is working fine. i ...more >>

Hi All, We have a pub/dist server(A) and a subscriber(B). A is also being replicated to DR server C by Veritas at the same time. We would like SQL replication continue after moving to DR server C from A? Replication may not work properly since machine name on C is different than A. Do you ...more >>

I am using concurrent snapshot - transactional replication. If I need to add the column to the replicated table, do I need to drop and re-create subscription everytime? The database is about 20Gb, it takes up to 4 hours to re-create two subscriptions. Is there any easier way of changing the da...more >>

I have a single publisher and ten partitioned subscribers using merge replication. The subscription was accidentally removed from one of the subscribers yesterday. There have been lots of inserts and updates on all subscribers since the subscription was dropped. A number of articles use ide...more >>

Users use a inhouse app with Access 2000 backend. This isn't going to change, however the data in the Access file needs to sync nightly with a SQL database on a different server. Whats available to complete this task? ...more >>

During last couple of weeks some new Tables & Fields were added. SO both the time i have to re-intialize the Replication. my question is about LATENCY where i have seen for both the subscriber(SUB) for SUB-1 is 3.5 Hours & SUB-2 is 21 hrs. Size of the PUBLISHER DB is 18GB. AS Latency are in ...more >>

Hello All We are running Merge replication on SQL 2005 with Pocket PC Clients. My question is, can i script (T-SQL) the same function as if i rightclick on the Replication Publication, and select "Reinitialize All Subscripers" and then click on "Create New SnapShot" + "Upload Changes"? ...more >>

hi, this might be a stupid question to ask we have suppose Server A and Server B having p2p2 replication now if i do an update at exactly same time on the same row. now both server will send out each of its transaction and commit the others transactions. now both servers are in a invalid stat...more >>

Hi, We have set replication between two servers.In subscriber if i update any row, the transaction is in Msreplication_queue Table.But when it try to push to publisher it throws a error called "Invalid cursor state". I don't know where it is going wrong. what could be the cause of this err...more >>

Hi, We have an database which is about the file size of 730MB, this db is set configure with publisher and will always push data to our backup server database. When we backup this db, the database backup filesize is actually 85GB (full backup from SQL). Anyone has any idea why is my database...more >>

Hi guys - I noticed that some subscriber's databases have an incredibly small mdf file and a large ldf. As an example one mdf is 1.4 MB and the ldf is 250 MB. The 250 MB should really be the size of the mdf. What is going on? Thank you, Maer ...more >>

We are trying to setup merge replication on a virtual server, but it keeps failing. We have run "sp_helpserver", "sp_dropserver 'localmachinename'", and "sp_addserver 'virtualservername', 'local'" to ensure that SQL Server will use the virtual server name, but the setup still fails. We have also...more >>

Hi Everyone, I have a publisher on MSDE 2000 where I use merge replication. I want to upgrade MSDE to a full blown SQL Server Edition (probably standard). My question is if upgrading will in any way interfere with replication. Should I be able to upgrade and continue business as usu...more >>

We are doing a proof of concept of heterogeneous transactional replication from Sql 2005 to Oracle. I have some questions about the snapshot. Q1) If the schema at the subscriber has been intitialized why do you need to have the automatically created daily job that runs the snapshot? ...more >>

Hi All, We have a push transactional replication setup (one box is pub/dist, the other is sub), and it's moving to a new environment (the same domain). I have questions regarding the steps before the migration. - First weekend we have to move the publisher, and the subscriber at the foll...more >>

Hello, I have scenario where I use two servers: SQL 2K sp4, on Win2K3 sp1. One server is a publisher, the other a subscriber. The replication topology is Transaction Replication with 1 queued updating subscriber. The distribution agent resides on the publisher. Firstly, I am aware of...more >>

(using SQL Server 2000 Standard) I am trying to test a log shipping script. I still have my regular log backup routine executing every 2 hours until I finish working the kinks out of my log shipping system. I try to back up the transaction log to my device while still leaving the logs int...more >>

Hi I am using transactional replication to transform around 30 tables from a main office to about 30 back office installations. This workes very well with my transactional replication. But, there is a problem when it comes to the price tables. The prices can be different on each back office...more >>

I am trying to replicate from SQL 2005 to SQL 7 using transactional replication (I am able to do merge replication). I created a table with one column (two rows) that is also the PK. I use the wizard and take all the defaults for Transactional (except I specify accounts for logging into). I...more >>

Hi I'm using SQL Server 2000 Std Ed. and have a merge replication with 3 subscribers running. I want to merge a certain number of tables every 10 minutes and other tables only once a day. Please let me know if this strategy is viable. How do I implement this ? Thanks in advance Roman...more >>

Hello, I think I understand why one would use the "Not for Replication" option on an identity column. So, now the question is: When would I *not* use "not for replication?" (and Why?) 1. This setting needs to be set when the table is first created, so wouldn't I always set this option i...more >>

I have an application that uses Merge Replication. In my database design, before I created the merge replication publication, I modified the tables and set my identity columns to Yes (Not for replication) option. I am hitting a problem however, when I try to insert a new row in one of the ...more >>

I have an application that uses Merge Replication. In my database design, before I created the merge replication publication, I modified the tables and set my identity columns to Yes (Not for replication) option. I am hitting a problem however, when I try to insert a new row in one of the ...more >>

Is there a workaround for this limitation? I.E can I just use the column filters option when setting replication up to get around this? ...more >>

Hi I am having a project where i have to migrate a SQL Server database to another machine with higher configuration in same domain with different name as we follow certain naming convention so name will remain different from old server even after migration Scenario Server A(Old Serv...more >>

I have set-up several replications, all of them working on the same way. But on the last one a strange thing occured: It seems that when a conflict is solved by choosing to use the displayed data from the looser, I need to reseed the identity column. The replication is working on the merge mod...more >>

Hi folks, Setup: Transactional Replication on SQL2000 (SP4), PUSH Publication to multiple Subscribers Everything works fine in the current setup I've learned that I can easily ADD a new column to a table on the Publication with the sp_repladdcolumn, or via EM's Publication Props->Filter...more >>