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

I'm installing the SQL Server 2005 developper edition under Vista, and I'm getting the IIS not installed message. I did install IIS with all options including backward compatibility, and I have checked that IIS is running. What did I miss ?...more >>

Hi, I am running SQL 2000 SP4 EE on 2 servers (1 remote and 1 local) and both servers are serving only one resource hungry database. The data from certain tables in the remote server is being replicated on the local server continously via transactional replication. The transaction log files...more >>

Hello, this may be easy, I already have a successfully running transaction replication distributor on one server and a pull subscription on another. I basically need to add another pull subscription to another server the from the same distributor. After I successfully set up another pull sub...more >>