Summary: Started replication April 1 of 4M xact / day publishing system to subscribing system. Performance was good. Latency was ~ 5-7 seconds. May 10 we noticed that the DB was behind (latency was 12 hours). All performance cou...more >>

HI, currently publisher and distribution is in sandiego and 8 subscribers is in losangeles. this weekend we are planning to do reindexing on all the servers.but at the same time we are planning to move distribution from sandiego to losangeles so that we dont see any delays from distribution t...more >>

Can anyone tell me if it's possible to manually configure log shipping in SQL2005? Our scenario: We would like to use our STANDBY server as a QA server and then roll the updates/changes/etc. into our PRODUCTION server via tran logs from the STANDBY server. Because of the size of our data...more >>

We have a database on SQL Server Express which is a subscription to a database on a SQL Server Workgroup. When main database (publication) will rise 4Gb, could we sincronize it? or the 4Gb limit of Express edition will not allow it? If it will not work, what should I do? Buy a Workgroup ver...more >>

Hello All, I have a pair of replicated databases. Data comes from my publisher into the subscriber, which fires a customised repl stored proc, which inserts data into a different table, that is then replicated back to the original database. My first replication is working. Data is getting i...more >>

Hello, I have a Server with 4GB of RAM and 2 64-Bit Intel Xeon Processors. I have about 400 GB of Free Hard Disk Space on a RAID 5 SCSI Hard Disk. I am attempting to do snapshot replication to a remote server. Every time that I start the job, the server goes to a crawl. There are no in...more >>

In my company, we have a central database and 4 remote databases. the central database replicate same database into 4 remote database in parallel. the replication is transaction replication and the data is input in the central database and replicated into remote databases. there are some tr...more >>

We are attempting to set up transactional replication publication, all parties using SQL 2005 Developer Edition with SP2. Right now there is only one database with only one table that's being published (@261 records, database size @221MB). Size is due to the data being mainly multimedia files su...more >>

Hello, I would like to know if instead of running sp_addscriptexec at the publisher in a merge replication architecture, is possible to run a .Net program to create the indexes at the subscriber during the installation. Thanks for your help, car....more >>

I'm trying to setup transaction replication from a SQL2k server to SQL2k5. The 2k5 server will have a pull subscription, everything else runs on the 2k server. Both servers are running W2k3. The wizard created a number of views, one of which the snapshot us unable to process. The wizard gener...more >>

Replication (transactional, I think) on our SQL Server 2000 was discontinued years ago, apparently by disabling the jobs and deleting subscriptions and publications. It apparently was not properly disabled. The distribution server now no longer exists, and so when I now attempt to disable ...more >>

One of our clients set up merged replication between two SQL Servers. Replication occurs every ten minutes. A problem occurs when they capture employee information through a web application affecting several tables that the information in some of the tables "disappears". What would be the best...more >>

What am I missing? Permissions? Credentials? Connectivity? Anonymous Merge Replication between MSDERelA/Windows Synchronizer Client (Win XP Pro) and SQL Server 2005 Publisher. Can create Publication on Server and Create Subscription on Client. When attempting to Synchronize, it connects, th...more >>

I have two servers config'd for merge replication (server A is SUB, server B is PUB) When insert on server B table1 occur, I need trigger to exec snapshot, followed by merge replication jobs. The jobs exist on server A. I know how to create triggers, but not clear on how to trigger a SQL job ...more >>

I'm having a problem with transactional replication. The problem arises when applying a snapshot to a subscriber. The 'Action if name is in use' property of the articles is set to 'Delete data. If article has a row filter, delete only data that matches the filter' I filter the articles by...more >>

I have 20GB of database and almost 380 articles, I want to implement the Transactional replication, when I try to configure the Transactional replication so it configure perfectly but the data is not displayed on subscription, can any buddy tell me what I am doing wrong. When I try to publi...more >>

Hi, I need to migrate 3 replicated databases to new servers running SQL2K on Windows 2003 standard, each server exist in different state with continues merge replication. Since the Databases around 40GB with big number of BLOBS I'm planning to follow these steps 1-setup all the servers loc...more >>

I am pretty new to replication and have been setting it up in a test environment using the test databases delivered during the sql install (northwind and pubs). I noticed that when I would setup Transactional Replicational (NON – updateable subscriber) that the primary keys would NOT come...more >>

Where in BOL, KB, MSDN, etc. can I find SQL Server 2005 versions of the details of how to configure IIS, FTP, Firewall, AD, and so on for Anonymous Merge Replication over the Internet? Running SBS 2003 Premium / SQL 2005 as Publisher. How do I get the Publication listed in the Active Directo...more >>

Are there any books available for 2005 replication and data Mirroring? The one on amazon does not have any good reviews from customers... -- Thanks and God Bless, ThomBeaux...more >>

I recently started having an issue with a distribution agent I have setup. I am doing a simple transactional replication of a production database to another server at a different location. A few days ago I started to receive the error message " Error 14262:The specified@job_id('5E6241B8-55E2...more >>

Hi Everyone We are running Merge replication and the Distributor and Publisher are located on the same server. Recently I tested our backup,and restored our published database, on comparing the live version and the restored version I found that there were quite a few system tables missing ...more >>

Hi I have log shipping setup on 2 servers - A and B. Both are SQL Server 2000 and the size of the database is 95Gb. The average transaction log is around 100Mb A ships to B and B is also the monitoring server. The schedule is set to ship every 15 minutes. Everything works fine, however...more >>

I'm testing DB mirroring in high safety mode without a witness server. When I try to simulate a complete failure of the principal server (I stop the principal SQL Server service) I can't get the mirrored DB's to come online. The status is stuck in "mirror, disconnected/in recovery" I don't...more >>

Hi, I've a SQL2000 server with an instance. I wanna replicate this istance in another server on my lan. How can I do this? Thanks ...more >>