What is the thought on replicating over WAN links. I have a DB hosted at an off-site ISP it is about 1.2 GB in size. I would like a local copy of the DB. So I would like to set up one-way replication. The ISP says that replication is resource intensive. We have a 768K Fractional T-1 they...more >>

Hi, I have a couple of queries I wonder if anyone can help me with. Merge replcation to Access with Merge ActiveX control. Using MSDE subscriber, takes about 30 secs to download schema and data.Using Access, takes about 5 minutes, and the file size is about 5 times what I would expect. Da...more >>

Environment: SQL Server 2000 sp3a Std Edition SQL Server CE 2.0 I recently made some schema changes to a SQL Server Merge Replication that resulted in the entire SQL CE database schema getting initialized (same as an initial snapshot). When the synchronization was initiated from the CE d...more >>

We are doing a preliminary requirements document for upgrading our SQL Server 2000 Servers to 2005. We are an ASP and we have over 2000 databases. Over 100 of these databases we offer transactional replication to our clients (subscribers). 1. When I run the SQL Server Installation for 2005 an...more >>

I am using transactional replication for a 100GB database that has 2 nosync subscribers. The pull subscriptions are segmented into like table groups. They all use a custom profile for the distribution agents that I tweaked over time to minimize latecy. In the last month I have noticed that 1 of t...more >>

I'm trying to achieve this by backing up the database on the Publisher immediately after I have configured publishing and restoring this backup on the Subscriber SQL Server. When I am configuring the Subscriber I clear the Initialize check box on the Initialize Subscriptions page of the New ...more >>

I found that , Log file was not being restored in standby server for the past 40 days. So i disabled all log shipping jobs which was running earlier. Last week I created a brandnew log shipping script with 2 jobs and enabled these 2 jobs, One job willl carry out database backup daily and move...more >>

1. Has anyone here done an 'inline server upgrade' . basically you install sql over itself and let it handle the upgrade process. (do you have to reinitialize publications?) 2. If i upgrade my publisher to 2005 will I need to also upgrade my distributors (these are separate machines on our ...more >>

Hi All, We plan to setup our prod databases to SQL Server 2005 and generate transactional replication on new 64 bit server. I have two questions deal with the tran replication: 1) In SQL Server 2000, I can choose the distribution agent profile as default agent profile or continue on data...more >>

Hi All, I was hoping for some advice about automating syncing of login ids at remote servers. I have implemented simple log shipping and that seems to be working fine, any ids created on the database are replicated to the standby database without issue, however any changes to the master databas...more >>

Hello, We have a trigger on a publisher that needs to update a different database on the server instance. The problem is that the trigger is being replicated to the subscribers who then error out as they do not have the other database on the client instance. Is there a way to not replic...more >>

Hello, I have a question on the subscriptions and type of replication to use. We have about 5 subscriptions to a published db setup as merge replication via the websync on sql2k5. We would actually like the subscriptions (all running sql express) to just download changes to the publishe...more >>

Some application insert record to MyTable using the bulk insert statement without the clause "With fire_triggers".In MyTable i need that the triggers fire. I can't modify the bulk insert statement. How i can fire the triggers on my table? thx...more >>

Started a new thread as my original was out of control. Quick description of problem.. We have had a server in LocationA for quite some time. The need arose recently to have a server setup in LocationB due to the bandwidth in location B is not wide enough to allow a direct access to Locatio...more >>

Hi, I'm having problems to download the initial snapshot from FTP, when the client is behind a firewall, I guess if I change the replication transfer mode on the FTP (Active / Passive) it could solve the problems, but I don't know even wich mode is SQL server using to download the snapshots an...more >>

Within Transactional Replication... Is this always a manual process or does it happen automatically in the background? ...more >>

Hi, I have a question on how to add a column in a merger replication? Actualy I know how to add a column in a publication for a merge replication What I need to know is how to create a foreign Key for that column Exemple : 01- I have a table myTable that is already in my publication as an...more >>

Hello, Currently we have a large production db (publisher) for a server app, and 2 subscribers, as disaster backups of the production db, each on a different server. It's my understanding that this replication is only one way, from publisher to the 2 subscribers. (I'm just a programmer an...more >>

Hi, We are using SQL Server 2000. We need to setup merge replication between server A & B using TCP/IP. These servers are behind a firewall. The connection between these servers can be done only using IP (class C) How to configure this. rgds, Soura ...more >>

Hi I am setting up Merge Replication using SQL Server 2005 with a single Subscriber. On both the Publisher and Subscriber I have a table where once a month data is migrated (horizontally partitioned) onto a secondary SQL Server and I do not want these deleted rows, as a result of the migra...more >>

Hi there, Please someone advise on this scenario (thankyou!) We have one SQL2000 Publisher/Distributor ("A"), Merge replication Pushing to two SQL2000 subscribers ('B' and 'C') (We do not update dat on subscribers). Works fine, we push every 10 mins or so. Now we have a new SQL2005 server...more >>

Hello All, Initially to start with I would say that I am not a fresher for SQL Databases but at the same time I am still learning.... So currently what I am looking at is to configure a replication between two SQL 2k SP3 servers. For e.g. Server A and Server B. Now Server A contains th...more >>

Hello All, I am trying to replicate data from a SQL Server (7.0) to another SQL Server using a one-way immediate push subscription. After executing, there are no errors in the Snapshot or Push agents, but two of the tables are missing in the subscription database. Where did they go? I can...more >>

Hi, I use a merger replication, and it was working find for 2 days Today I have an error which is in french because the subscriber OS is in french The error is : The process could not connect to the Distributor "SQLDIST" "Impossible de générer le contexte SPPI" MSSQLSERVER AND SQLSER...more >>

Hi, Can I just replicate some tables only instead of whole db? THnaks ...more >>

I need to bring over a new copy of my 100GB db to another server (2) to start replication. I've done this many times before, but this time to help speed up time I scripted the publications (I need to drop them because of a separate issue) using the generate script function and then after deleting...more >>

How can I view the publisher and subscriber conflict using VB 6.0 and SQL Server 2000? ...more >>

I keep getting this error "The schema script 'xxxxx.sch' could not be propagated to the subscriber." when i try to create a subscription on a SQL Server Mobile 2005 to a SQL Server 2005 publication. What is the cause of this error? ...more >>

Hello all I am getting an error 8198 when trying to replicate from one server. It says Could not obtain informaion about Windows NT user/group and username problem is the user it cannot obtain information about does not exist on either server. What else can cause this error...more >>

We are using SQL 2K with sp4 and use push subcription. The publisher database and the distribution database are on the same SQL server. I need to disable publishing and distribution so I can recreate the publication from scratch. I use SQL EM's Disable Publishing and Distribution wizard ...more >>

Hi, I am seeing lot of Stored Procedures named like Expand_% and Expand_%_PAL in my Publisher Database. I could not find any documentation on these Procedures in any Replication article. I would appreciate if somebody can explain! Thanks in Advance! Vikas Kohli...more >>

Hi, I have two publication set up for Merge replication. One for stored procs and views, and one for tables. The clients do Pulls. I have added a new stored proc. I need it to be added to my publication, and the subscribers need to get it. Do I have to blow away their subscriptions and t...more >>

Hi there, I am fairly new to SQL2000, however have been charged with providing a DR scenario. Having weighed up the various options, and taken Paul Ibison's advice, have opted for log shipping. The problem is that we already have standard in production, so am trying to massage the scripts i...more >>

Hello, The schema definition of base table 'dbo'.'CRWAppointment' at the Subscriber does not match the table in the Publisher database. Re-establish the subscription after recreating the base table to match the table at the Publisher. Please reply this post if you know the valuable infor...more >>

Hi all, I have encountered a strange problem as per below : ServerA - queued updating to ServerB I made some changes to the supplier i.e address , email , telephone# for 5 suppliers all the changes for address & email were replicated over however for the telephone# only 3 were successf...more >>

Gurus, I am planning to update SP3 to SP4 on a replicated server. A- Please correct me if i wrong in order. 1- Apply SP4 on Publisher / Distributor (on single box) 2- All subscribers. B- As per my knowledge there are no issues while applying SP4. Is there any known issue while applyin...more >>

We need to create a copy of a db with updates on the same publisher. Problem is that the publisher is already using a separate distributor server. Since you can only have 1 distributor per publisher we are in a bind here. We can't change the distributor because it's handling replication f...more >>

We are using SQL 2K with sp4 and a push transaction subscription. In the Publication properties, under the snapshot tab, there is a check box for 'Concurrent access during snapshot gneration', the default is not checked. 1. I am thinking about checking the box because the benefit is gr...more >>

I am using SQL2k with sp4 using push transactional replication. When I select 'configure publishing, subscribers and Distribution' from the SQL EM's tool menu\replication, under the distributor tab, there is the administrator link password, what do they use for password? When I set up repl...more >>

I am currently using SQL 2000 & using merge, transactional (one way) & bi-directional transactional. We have 18 servers. Are there any drawbacks of upgrading, one server at a time to 2005? What are some of the pros & cons of replication in 2005? Thanks, Larry... ...more >>

Hi, How well does sp_publication_validation work with articles that have columns filtered ? Will the checksums work? or am I limited to rowcounts only ? Thanks in advance for your help. SQL Dood ...more >>

Hi, What is the default password for distributor_admin when we setup merge replication? Regards, amit ...more >>