Where to start troubleshooting the failure of schema to replicate from one server to the next.? -- Sandy Wood Orange County District Attorney...more >>

Help. I am having a hard time getting the snapshot agent to run when I create a distrubution/publication and then a subscription. I followed the following tutorials: http://msdn2.microsoft.com/en-us/library/aa337475.aspx I have both SQL Server 2005 developer and Express on my development bo...more >>

how to you measure Latency in pull or push sub/publist architecture? Do you have a set of scripts which use to monitor and setup the replication environment? ...more >>

I'm getting some records coming up in the conflict viewer which havn't been inserted because there is a "Violation of the Unique key constraint". But if I join the conflict table to the target table on the primary key I get no result so keyfld in the conflict table is unique. Can anyone expl...more >>

I have two sql server instances on two different machines with the same db; on the first machine some tables need to be copied on the second machine, and on the second machine some other tables need to be copied on the first; all the tables are related with the others in some way. It is possib...more >>

Hi Guys, I have question regarding replication. I have 30000 rows data that need to replicate from server A to Server B. It might last 2 hours to finish it. My question is that can I select from tables in server B that were replcated from server A? I cannot put nolock in query statement. I am...more >>

Hi, I want via email to monitor transactional replication status such as still running, have some problem during retry, or re-initialize, etc. instead of login to Microsoft SQL Server Management Studio in SQL Server 2005 (SP1). I think those information should get from msdb, does anyone done ...more >>

we are running sql200 and i am trying to do a transactional replication, i recieve the following error message during snapshot creattion The process could not bulk copy out of table '[dbo].[syncobj_0x4336423045343434]'. The error detail follows: I/O error (torn page) detected during rea...more >>

Hi, Can anyone please provide me with a step-by-step explanation on how to replicate data (snapshot replication) from a table in a SQL Server 2005 database to a table in a MySQL database through an ODBC connection? I have already created a publication, but have not succeeded in successfully ...more >>

I'm developing on SQL Server 2005 and our application needs to be 'replicable'. I can see how this is done using a RowGuid and marking to be used for replication, no problem. My question, however, is if I should make this rowguid column the primary key in the tables in our database. Will it...more >>

Hi Guys, Am very new to replication and would like to request some advice about solving the following problem. I have a main database running on Sql Server 2005 Standard. A copy of this database is also running on Sql Server 2005 Express on 3 laptops used by reps in the field. The reps make...more >>

Hi, We are in the process of configuration replication for our 64-bit clustered sql 2000 environment. We run into this very common error, in the first step itself ('Cofnigure publisher, subscribers and distribution from EM'). At this point we didn't even select any subscribers. Just conf...more >>

Hello, We are decommissioning a cluster and moving all the databases to a new cluster. The issue is, the distribution database. Is it possible to move the distribution database without dropping the publications and subscriptions ? If it is possible, please let me know how to do it. Thank...more >>

I have a very large and very active table which I want to replicate to another server. How can I set-up a Publication for this table and avoid the locking during the initial snap-shot in SQL 2005? SQL 2000 allowed configuring replication without generating a snap-shot - assumed data was al...more >>

Hi I get the error: "A failure occurred when accessing 'tabelle1_2.sch' due to an operating system error [53=''] during Web synchronization. Ensure that the -InternetLogin user when using basic authentication and the user running the merge when using Windows integrated authentication has...more >>

Hello, New to SQL Replication. Have SQL 2000 and wanted to replicate my business & core databases to a server at another site to increase availability. Is SQL replication able to keep my business application running without end users ever knowing that one of the serves went down or are ...more >>

Hi guys, I have issue related transaction replication and trigger. In my company, we have transaction replication and then there are some triggers in the tables in subscriber server. When the data replicated into table, then fired the trigger. Recently, it causes performance issue when data b...more >>

Any suggests on Agent is suspect error? MJ...more >>

Dear All, When I am synchronizing the merge push subscription, receiving following error Cannot find the identity range allocation entry for the Subscriber in the MSmerge_identity_range table. Reinitialize the subscription. What could be the cause of message, and is there some way so I can ...more >>

Merge Replication Web Sync - Pull subscriptions publisher and distributor: SQL Server 2005 X64 build 2221 clients are SQL Express builld 2047 We have 3 of our clients that received the following error at the end of a merge. SessionStatistics: ============================ UploadInserts:...more >>

I have to move a SQL Server 2000 database from drive to another on the same server because we are running out of space. I know the easiest way to accomplish this is to detach the database, move the .mdf & .ldf files, and reattach the database. However, this database is being replicated, which ...more >>

I got 2 servers running, Dev and Production The Production one is the one that the users run on and it's working with a Access adp project The Dev one is the migration project that evolve and use VB as interface. So my test are made on the Dev version but, the way it work now is i copy m...more >>

I am wondering how to set up replication. Say you have a very slow connection to a subscriber, so you want to minimize the amount of data piped across the network. The subscribers only need the data updated once a day. The publisher and distributor are on the same server, but the subscribe...more >>

Publisher: Windows 2000 SP4 SQL Server 2005 SP1 Subscriber: Tablet XP SP2 SQL Server Express SP1 Topology: Dynamically filtered partitions Subscriber Pull subscriptions All, Is this behavior by design?? In my publication database I have a one to many relationship between a ma...more >>

We have a Disaster Recovery lab set-up here...sort of a SAN box...which allows us to play with data and replicate disaster recovery. Our DBAs are not onsite and are not too helpful. We have to get some data into our database and need to stop replication in order to do so. Is there someone o...more >>

Environment: Merge Replication Publisher: SQL Server Enterprise 2000, SP 4. Subscriber: SQL Server Enterprise 2000, SP 3a We ran into an issue when creating a subscription the other day. When we tried to drop everything we got the folloiwng error message: "Could not drop one or more ta...more >>

Hi all We are using a pull publication what works well. After a time, maybe next day, the publication must be reinitialized again. The duration property of the publication does not define a final date. I could not find other properties controlling the activation state. Is this a securit...more >>

In 2005, when we use transactional replication and want to initializing a Transactional Subscription Without a Snapshot, it says we can do so with a backup. So I just want to know ifchanges made after the backup was completed will roll over as part of the replication or do we have to apply ...more >>

Hi guys, I used sa to setup the replication and reset sa password today. I got error in snapshot agent after that. can you tell me how to reset snapshot so that I can restart the snapshot? Thanks....more >>

we are running sql 2000 and are trying to replicate our production database from 1 sql 2000 server to another sql 2000 server. We had been doing this successfully for some time, but we had to reinitialize our snapshot and now we recieve the following error during the snapshot.... The proces...more >>

Hello, The computer name of one of the subscribers was changed and now the sychronization does not go through. It is not possible to changed back and I would like to know if there is an easy way to get the subscriber back to work. Thanks, car....more >>

Hello everyone, I'm looking to get a list of publications on a given SQL Server instance via RMO. I can't seem to find any information on how to do this. What I need is, given a server name or existing connection, find out if the machine is a publisher and if so, get a list of its publication...more >>

Hello I have noticed that if I have a joined filter on one table and then I insert a new row from the subscriber to that table,and then Synchronize,the other subscribers get this row as a deletion when they synchronize, if the filter is filtering that row for them. Is there a way to prevent...more >>

I have been messing around with Replication on MS Virtual Server. Set up a Distributor on a seperate machine from the publication database. For some reason unkown my Distribution database went in Suspect Mode. Finally got rid of it using sp_dropdistributiondb @database = 'distribution' Now...more >>

Hi, I have a four servers in bidirectional transactional replication (publisher, publicator and subscriber), the problem is when I to be activate the subscription with one server, the transactional process in the client application (.Net) fails and send me an error. ...more >>

Hello, I've a merge replication in SQL Server 2000 with one publication, where all the articles are tables. Some of these tables have IDENTITYs and I've choised SQL Server auto identity range. When I delete a subscription all replication tables and information related to the replication is...more >>

Hi, SQL 2000 ENT; SP4. Thre setup here is two databases, each with over 600 tables. Each table has a UID column that is an IDENTITY (1,1) column. Thge databases are on a SQL Cluster and we want to replicte to a DR Server. I setup transactional replication and create a publication and ...more >>

this link http://msdn2.microsoft.com/en-us/library/ms179344.aspx say this: " The principal server writes the transaction to the database and, concurrently, sends the log record to the mirror server. The principal server waits for an acknowledgement from the mirror server before confirmi...more >>

Hi, I 've a sql server 2005 standard edition SP2 x64, configure with transational replication. I've enabled alert 14150 "Replication: agent success". The problem is that this alert is not send to the windows aplication log. It looks like it never happen, but replication runs ok. In the his...more >>

Hi, SQL Server 2000 on Windows 2003 server. We have been replicating between databases on the same server using snapshot replication for some time without any problems. Last night however the "Replication Distributor" part of the procedure which runs this command.. -Publisher TANDOOR...more >>

I have a table that I need to replicate twice. Once as part of an updating subscriber transactional publication and once as a plain transactional repliaction. This table has an identity column, which is causing the problem. If I set the identity management to false, it complains that it co...more >>

I've got a republishing scenario. 3 databases: - Main (central db with all customer data) - Comp1 (serverside db with only Company 1 data) - MobComp1 (mobile SQL db with same data as Comp1) Between Main and Comp1 I got a Merge replication with row filters (to select the Company 1 data). ...more >>

Hello everyone, I am involved in a scenario where there is a huge (SQL Server 2005) production database containing tables that are updated multiple times per second. End-user reports need to be generated against the data in this database, and so the powers-that-be came to the conclusion that a...more >>

Hello I have an issue on Deleting rows on Publisher. I want to keep a 2 months old transaction data both on my Publisher and on the Subscribers as well, so eatch night a process is run on the publisher that deletes 2 months old data, so actually eatch night I have a deletion of 1 days data...more >>

How to find the snapshot job name using TSQL?...more >>

Ok guys, it's my first day on a job, I need a quick answer, and I'm not a full time DBA. Refresh my memory. I have a SQL Server 2000 (SP3) server with multiple databases of uncertain size (probably a few gig at least.) I need to duplicate this entire server (all databases, users, permissio...more >>

Is it possible to have pregenerated snapshots for anonymous subscribers (SQL CE)? ...more >>

I need to write an application to perform a CRm type function. I want to store the data in a SQL 2005 DB on Windows server 2003. I then want to be able to sync the data with several laptops so that they can work standalone. The sync could be peformed on a LAN or via VPN through Broadband. Ca...more >>

Hi, I'm receiving the error "The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated." I'm using tranactional replication with no-sync initialization. How can I manage to run my replication normally again? I've trie...more >>

Hi, I have a mirrored databased, which is in FULL recovery mode. I take log backups every 1 hour and db backups every night. However, the log file keeps increasing and due to mirroring I can’t shrink the log with shrinkfile. Is this the recommended set-up for mirroring, am I trying to be ...more >>