Can anyone point me to a set of documented steps on how to clean up the following mess? Three days ago a developer (not me) deployed some changes to a production database by restoring from a backup created on another server. The problem is the production database was set for replication. No...more >>

Thanks for your response. I don't know how to do pass-through authentication across domain (particularly using SQL2k replication), I thought that would require a trusted account on both sides. I have been trying using the sql account and although I can connect to the subscriber using the acc...more >>

Dear all, I try to setup a replication between a database TEST on a server myServer into an SQL express database myDB on a Vista office PC machine. For that I define my SQL server to be a publisher of my database TEST and then on my Client PC under sqL express I define a new subscription b...more >>

Hello, There is a @identity_range parameter, which controls the identity range size initially allocated both to the publisher and to subscribers in sql server 2005 merge replication. I need to assign different identity ranges for publisher and subscribers. Is it possible to achieve it? The @...more >>

Hello, I have a problem with a MergeReplication. I have installed the Publisher and the Distributor. Then I created a MergePullSubscription. But when I want to generate the Snapshot I get the error: Message: Error in the Replication-Agent while creating the folder 'xyz' Stack: in Mi...more >>

I located the following titles and dates of courses being held in Chicago: 2071 Querying Microsoft SQL Server 2000 with Transact-SQL 04-05-07 2071 Querying Microsoft SQL Server 2000 with Transact-SQL 05-14-07 2071 Querying Microsoft SQL Server 2000 with Transact-SQL 07-16-07 2072 Admin...more >>

Can you push over non-trusted boundary? Hello All, Is it possible to use a Push Subcription (Transactional) pushed over non-trusted domain boundary? I've tried a lot of things without luck. Bill Millett ...more >>

I've got a publisher, distributor and subscriber on different servers and I want to move all 3 to different servers. Is there a way to restore the publishing database on the new publisher, the subscribing database on the new subscriber and then continue replication? knowing, of course, that...more >>

Hi Gurus, I have a default on a column that disappears every time I reinitialize replication. This is transactional replication to an updatable subscriber on SQL Server 2005. Yes, replication of defaults is turned on, and *most* of my column defaults do, in fact, replicate to the subscriber...more >>

I didn't actually see this but my customer swears: Merge replication subscriber sql 2000 sp3a had the jobs disappear from the agent for about 10 hours and the publisher said it could not connect. This morning the jobs are back and replication was able to be started manually. Help....more >>

I have 3 retail sites running MSDE and I want to aggregate sales data at a separate SQL Server. I run a VPN and I guess I need to use merge replication to a full SQL Server Database. My questions are 1. Is the central server the publisher or subscriber 2. The three sites tables are identic...more >>

I am trying to limit the downloaded records per merge session over my less reliable links. Under SQL2000 I could set MaxDownloadChanges in the agent profile to 1500, but in SQL2005 this value is limited to 300 max. Has anybody run into this issue before? Why was it changed from SQL2000 to SQ...more >>

Hi; I have a push suscriptions server that need acces to Internet (publisher) through proxy server computer. So I need configure proxy server account in Sql Server Suscriptions machine, because it run without desktop user sesion. How can configure it? Thanks in advanced M. Barro ...more >>

On my distribution server, I have a failed replication (the big red X) for a server that had hardware failure a couple of weeks ago. We were able to bring this client up on a separate server and have re-replicated them. Now I need to get rid of the failed replication however when I try to simp...more >>

Hi, There are 18 Transactional Publications, one for every subscriber. In these publications there are certain tables where the data practically do not change. The data in these publications is transferred to all subscribers identically. There is one Merge publication, wit...more >>

SQL Server 2000 sp4 on Windows 2003 All of a sudden, receving error message: The snapshot for this publication has become obsolete. The snapshot agent needs to be run again before the subscription can be synchrnoized. The snapshot was run on 11/27/06 and hasn't been run again (no need to ...more >>

What is the cleanest way to setup Replication Publication such that only table schema is published and no data. I cannot see a property for this under Article Properties for tables. Do I have to setup a row filter to return no rows? Thank you. ...more >>

I had set up some Snapshot and Transactional replication in the past but would like to see if following is possible. Is it possible to do either snapshot or transactionl replication between tables with 2 different table structure? Lets say I have a tableA which i like to replicate to TableB. ...more >>

SQL Server 2005, Merge replication How NOT to mark inserted/updated records for replication (they should 'stay' on the server where they got inserted/updated) ? Thanks....more >>

SQL Server 2005 & Express All, What is a best practice for generating snapshots in my merge replication topology? In my topology subscriptions will be coming and going over time. There will be @150 users with new employees coming online over time. Some of the users share hardware and s...more >>

I want to split transactions in transaction replications SQL2k, in case if the transaction is too huge. I think about setting MaxCmdInTran to 1000000 for logreader and similar for distribution agent. In current DB schema such transactions should never occur. But in case if the transaction hap...more >>

I am getting the following error and can not figure out how to fix it. = Please help. SQL Server Enterprise Manager could not configure 'SERVER1' as the = distributor for 'SERVER2' Error 18482: Could not connect to server 'SERVER1' because 'SERVER2' is = not defined as a remote server. ...more >>

Hi all I am developing a C#, CF2 and SQL Mobile app. I have the Merge replication all working well. The problem is that the First Sync when the Database is created on the Device takes a long time. Is there some trick that any one might know to speed this up? Something like Deploy ...more >>

I am setting up a replication of a database which has 364 tables. The size of this database is close to 150 GB. I have one server as publisher. I have another server which i am using for distributor as well as subscriber. Both servers are seperate physical servers. I tried replicating 2 ta...more >>

We have a replication configuration in which there is a Publisher/Distributor and 21 Subscribers. 15 of the subscribers are connected via a T1 -- the other 6 via fiber. The database is the backend of an application that has several bugs in it. Earlier this week, one of the bugs caused over...more >>

Problem description ----------------------- There is one central SQL Express database. And one (or more) SQL Express database(s) on remote locations. This approach is mandatory due to some application features later-on. The local database(s) on the remote location(s) will act as a sort of ...more >>

Hi I'm planning a rollback of SP4 as a mitigation option. Can anyone tell me if this is actually possible with transaction replicated databases? SP4 documents say to rollback you must disable replication (which deletes not disables) and use sp_detach on the databases. But SP4 updates replic...more >>

I'm new in the area of data replication.=20 I hope someone is willing to help me on this little thing I'm trying to = accomplish. Problem description ----------------------- There is one central SQL Express database. And one (or more) SQL Express = database(s) on remote locations. This appro...more >>

We have replication between two Microsoft SQL2000 servers. We took down replication (had no problem) then backed up the database (no problem). Tried to make some changes but had to delete the publication first and then we ran into some other issuse (not a big problem). So we decided to restore t...more >>

I have a SQL Server Enterprise Edition database TestDB1 with 23 tables that gets populated by replication from a mainframe server. (Inserts, Updates, Deletes) Now we have to move the data from TestDB1 to TestDB2 on the same SQL Server machine. (Same instance of SQL Server) TestDB2 will be u...more >>

Anyone know of a chart on the Microsoft Site that compares all the Replication types for SQL 2005? Trans Shipping, Mirroring, Publication and Subscription and all that stuff? ...more >>

Hi What are the gotchas on moving a Replication Distributor to new hardware/a new cluster? Kind Regards, T. Hagen...more >>

I'm getting this error message when trying to insert a row on some tables in my database. The identity range managed by replication is full and must be updated by a replication agent. The INSERT conflict occurred in database 'XXX', table 'tblContact', column 'Number'. Sp_adjustpublisheriden...more >>

Hi to all, How can I see the rate of snapshot Generation in my Merge Replication (SQL 2005 SPK1) ...more >>

Hi ng, during this night big (3GB) log file in my distribution database was corrupted, now my database is in suspect mode, is the any solution to recover database from this mode? for ex.: use bcp or something? i need this replication working... if anyone knows the solve please answer ...more >>