We have transactional replication between two MS SQL Server 2008 R2. Our servers were rebooted because of failure of a hard drive.
I have an updatable transactional replication set with SQL Server 2008. Everything is working fine. I added a new table to the existing publication thru sp_addarticle followed by sp_addsubscription. A
I need to set up a one-way transactional replication from a SQL Server 2005 database to MySQL 5.1 Database.
I\'m very new to SQL Server. I just had someone transfer my entire database from Access to SQL Server and I\'m trying to get up to speed.
Replication related issue, I am explaining my architecture . I have created , its transactinal replication process
Transactional Replication on SQL Server 2005 Enterprise x64 (SP3). I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the p
I\'m using SQL Server 2005 to create a replication copy of the main databases, so that the reports can point to the replication copy instead of locking out our main databases.
I\'ve got transactional replication configured from a database called DBProd to another database called DBWarehouse ; everything works fine, and transaction are usually replicated instantaneously to t
I have 12 databases totaling roughly 1.0TB, each on a different physical server running SQL 2005 Enterprise - all with the same exact schema. I need to offload this data into a separate single databas
My web app uses ADO.NET against SQL Server 2008. Database writes happen against a primary (publisher) database, but reads are load balanced across the primary and a secondary (subscriber) database. We