Hi When setting up a new replication, can I take 2 non identical databases and set up the replication and all changes the differences will be updated OR For full consistency it is necessary to start off with identical databases Thank you for your advice, Samuel ...more >>

One of the options when setting the Transaction replication is 'List in Active Directory' What does that mean? Thank you, Samuel ...more >>

Hello, Every time that I try to enable Distribution (Right Click Replication and select 'Configure Distribution') I get the error "SQL Server is unable to connect to server SQLSRV\SQL. SQL Server replication requires the actual server name to make a connection to the server.....". This se...more >>

I am looking for clarification on Microsoft stance that SQL 2005 can replicate from an Oracle database. Some of the literature says that you have to have Enterprise in order to perform Transactional Replication. Is it just Transactional Replication that requires Enterprise or is it all types. ...more >>

Log Reader Agent failed with error message "Step did not return any output". The errorlog states that " Could not connect to server 'GSPCVDB02' because 'distributor_admin' is not defined as a remote login at the server." I obviously have a linked or remote server problem but cannot determine fr...more >>

This is the 2nd time this has happened: 1) I add a couple of tables the published articles for tranactional replication 2) I run the snapshot agent 3) The snapshot agent creats the schema and bcp files 4) The subscription agent fails because it can't find the INSERT, UPDATE, and DELET st...more >>

We currently have a production installation of SQL Server 2000 Enterprise Edition that has a 40 gig database that is hit heavily. I am setting up another installation of SQL 2000 to host a read only copy of the production database to strictly run reports. The data will need to be updated onc...more >>

Hi, I'm trying to transfer data from an SQL 2000 box to a new SQL 2005 server. On the old server the database is setup for replication and has a publication. The new SQL 2005 is set-up for replication. I restore the database and in the SQL Magement console I can see the various publications...more >>

We have SQL Server 2005 Standard Edition with several (around 75) replication subscribers (SQL Server Express). After applying Service Pack 1 to the Publisher, about 80% of the subscriptions became invalidated. Simply reinitializing the subscription did not work. The entire subscription had ...more >>

Hi All, We are going to upgrade to SQL 2005 in the next couple months. We are not sure which version (either standare or enterprise) yet. Here is the situation. We have two servers, SQLSERVER1(internal user) and SQLSERVER2(web user). Both servers have the exact same data. We want to configu...more >>

Hi All, We are running SQL2KSP4 and have 40+ subscribers (anonymous) using merge replication. We added a subscription to a machine, and when we try to synchronize it we receive: Invalid subscription type is specified. A subscription to publication 'xxx' already exists in the database w...more >>

I have a program that uses merge replication between SQL server 05 and SQL Server Mobile Ed. The program creates the mobile db and subscription on first run, and syncronizes the data. This works fine. I am trying to get it to syncronize again when the user has edited the data, but I keep get...more >>

Hello, Does anyone know if, when you create more than one database instance in SQL Express, each instance can have a 4GB size limit or is the limit on the combined size of all your instances? Thankyou, Lauren...more >>

I am doing a snapshot replication between SQL server 200 and SQLexpress. When I sync I get the following error: Could not drop object 'Events' because it is referenced by a FOREIGN KEY constraint.. I went into the "Events" table and removed all the foreign keys, but the error persists. Also...more >>

The distribution agent fails with the following error : Cannot insert the value NULL into column 'cmdstate', table 'MSreplication_queue'; column does not allow nulls. INSERT fails. (Source: <ServerName> (Data source); Error number: 515) {call sp_addqueued_artinfo (1, N'tablename', N'serve...more >>

I want to verify this. We have a publication that is having issues and isn't letting their subscriptions replicate over. Until we fix the publication issue we want to switch from retention period 14 days to subscriptions never expires. If I set the publication to subscription never expires wi...more >>

I'm trying to put together a small install package of what is required to use the SQLMERGX.DLL merge replication control in SQL 2005, but it can't see the REPLRES.RLL file. I've placed it in the correct location, (C:\Program Files\Microsoft SQL Server\90\COM\Resources\1033), but I still get...more >>

Hi, While trouble shooting another problem, my Profiler/Trace process recorded this error "Lock:timeout" for one of my replication agents. The timeout error occured when the replication agent was doing something with this table, MSrepl_commands, in the 'distribution' database. The research tha...more >>

Hi all, We are planning to have transactional repllication for 8 tables(indexed-view rep) and 30 tables regular transactional replication against a very frequently used database. My question is that 1. It's transactional replication hit a lot of performance? 2 Could we use snap-shot repli...more >>

I have a Merge replicated table that is phisicaly in sync. The confict viewer shows 230,000 conficts. How dow we get the conficts cleared in an automated fashion....more >>

Hi All, I wonder how I can pursue a blocking problem caused by SQL Replication. We are having a performance issue on one of our busy sql server 2000 (build 818) machines. There is tran.repl. Publisher db and subscriber dbs are on the same box. We have seen this problem after we moved sql...more >>

I'm getting these two errors that are stopping my transaction replication: Another log reader is replicating the database. The process could not set the last distributed transaction. This is the setup: 5 servers replicating with immediate updating and transactional replication. 1 central s...more >>

Hi: I have a publisher database which is replicating (transactional) to database on a subscriber. This database on subscriber is used by webpages for reporting. Lately, I am seeing lot of blocking (sql timeouts) on subcriber database which degrading the performance of webpages. I monit...more >>

I am looking for a workable alternative to using GUIDs as the PK in tables that are included in a replication system where there are multiple remote locations and a central database with all the remote and central databases requiring to be synchronised, so there is two-way replication. The use...more >>

I read about No-Sync initilization.I tried it out. I am using transactional replication.I used sp_scriptpublicationcustomprocs after pushing subscription.It was working also .I got some problem in my SQL Server so I reinstalled server.Then I again tried same thing.This tme what happen custom s...more >>

We have 2 instances of SQL Server 2005 running on 2 seperate machines. One instance is configured as a publisher and the other instance is configured as a subscriber. Mobile clients need to connect to the publisher Database for synchronizing of data stored in the tables. In the event of a ...more >>

Can anyone tell me if I can apply SP4 to a standby server while the primary server stays on SP3? Unfortunately, the standby database is in the same instance as the Test system. I'd like to run the Service pack on the Test system before applying it to the production database (the log ship...more >>

Hi I am having a problem setting up replication between my Sql Server 2000 box and Sql 2005 Express. Obviously when you set up the replication subscribers in the GUI it will only display other Sql Server 2000 boxes but not any Sql 2005 boxes. I just want to push the data from my Sql 2000 b...more >>

Greetings folks, I googled my problem and came up with no prior examples, so it might be a new bug. Turns out you can't publish a table using transactional/updatable replication if a column in the table has a space in the name, and if that column is also the primary key. I did a quick wri...more >>

Hi,, I need to replicate some 2 tables in a db -- table transactional replication. These 2 tabbles have insert triggers. Do I need to disable/delete the trigger in subscribe tables? Thanks ...more >>

I am testing a transactional replication with an updatable subscription on SQL Server 2005. The the publisher, subscriber and distributor are all on the same server. On issuing an update statement on the subscriber, I receive an error: The server principal "repllinkproxy" is not able to ...more >>

Is there a way to create a procedure possibly that we can delete data in a database that has been replicated to another server's database without it replicating the deletions on the replicated server? If so, how in SQL Server 2005? We are wanting our front-end sql server to handle all the loa...more >>

I have a client that wants to setup a SQL mirrir database on a physically remote server to his primary system. This will involve the databases talking over the internet through a PIX hardware firewall. The question is what ports on the firewall will have to be opened to allow the SQL databa...more >>

Hi Thanks to Paul for telling me about the tablediff cmd line tool - it does exactly what it says on the tin and gives me a quick and dirty report that all my data is synchronous. However, a couple of the tables in the datbases that im comparing are pretyy big - 30 GB or so, and the tool ti...more >>

I have noticed that when I add a new Column (SQL Server 2005) that coulumn is automatically added to replications. But if I don't want the column replicated, I have to go to the replication properties and uncheck the column. That again forces me to create a new Snapshot. Is there a way to add...more >>

Hi, Thanks for all the reponses yesterday regarding replication tables of diff schema. I understand now. Now we have 3 tables out of 56 in diff schema. I need to replicate the whole databse. What should I do? replication all tables one by one? Or i could do replication database and 3 addti...more >>

Hi, I am using merge replication on SQL 2000 which only push filtered data to each subsriber. This works just fine. But when I change one parameter which tells that certain row should no longer exists it doesn't delete it in subscriber database. Is there any other way to delete those row...more >>