The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
469 views

SQL Server 2008R2 Transaction Replication Stop and Restart but continue log backups

In a database that is currently being replicated I want to stop the replication (stop the log reader process) for a period of time though I want to continue to take log backups on that same database. ...
0
votes
1answer
250 views

If a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?

Thanks in advance for any help. I'm setting up a new Microsoft SQL Server replication and I have the Distributor and Subscriber running on the same server. The Publisher is on a remote server (as it ...
-1
votes
2answers
127 views

SQL 2012 Server Database Transaction Replication performance issue [duplicate]

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented ...
1
vote
0answers
521 views

SQL Server distribution agent cleanup job causes blocking

I am using SQL Server transactional replication, and have noticed that on a daily basis all of the publications for a distributor are being blocked when the distribution agent cleanup job executes. I ...
1
vote
1answer
161 views

Is replication less resource intensive than high frequency reads?

I am beginning the development of a new web application which needs to be designed to scale from the word go. I am looking into database replication and the concept of master/slave replication (or ...
0
votes
2answers
2k views

SQL Server 2008 R2 Replication log reader could not execute sp_replcmds

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on ...
0
votes
2answers
696 views

How to move the files of a replicated database (SQL Server 2008 R2) to a different drive

I would appreciate if someone could help me with the following problem: We use two SQL Server 2008 R2 databases under transactional replication: transactional publication with updatable ...
1
vote
1answer
350 views

sql server peer to peer replication - have the agents running as NT AUTHORITY\NETWORK SERVICE?

On a test rig, I'm trying to get SQL Server 2005 peer to peer (transactional) replication working, with the replication agents running under the NT AUTHORITY\NETWORK SERVICE account. Before this I ...
1
vote
2answers
115 views

Any reason to replicate SQL Server database for reporting?

We are upgrading our ERP application to run on SQL Server 2008 R2. It currently runs as a file-based system in it's own Server 2008 virtual machine. SQL Server will be installed into that VM. We ...
0
votes
1answer
62 views

SQL Server Subscriber Migration

We're currently have one way transaction replication from a SQL Server 2005 OLTP publisher/distrbituor to two subscribers (one SQL 2005 and the other SQL2008 R2). Replication security is via the SQL ...
1
vote
1answer
344 views

SQL Server 2008 SP1 Transactional Replication of a Partitioned Table Generates StackDump

I have a partitioned table that is published for transactional replication. The SWITCH operations on this table appears to replicated to the subscriber even though the options to ...
0
votes
1answer
85 views

Transactional Replication from SQL Server 2008 to 2000

I has transactional replication from my server1 (MS SQL 2000) to server2 (MS SQL 2000) in another company (and on different network) and it worked OK. Instead of using real name of server2, I used ...
0
votes
1answer
35 views

Using a subscriber database as a backup

I am trying to set up a transactional replication database on two MSSQL 2008 Standard servers. We need to be able to query off of the subscriber database, but we would also like to be able to use the ...
0
votes
1answer
274 views

SQL 2008 R2 Bi directional replication

I'm looking for the right replication for my case: I can't use P2P replication because one of my SQL's is Standard. I have 2 SQL 2008 R2 and want to create a bi-directional replication. What are my ...
1
vote
1answer
119 views

Monitor SQL replication publishers from subscriber

I have transactional replication with many publishers(50+) and one central subscriber(data collecting). Is there some way(feature of SQL server, 3th party tool) how to monitor all publications from ...
0
votes
1answer
150 views

SQL Transaction Replication prevents procedure with distinct on varchar(max)

When I'm adding one procedure article to the Publication the I get this error: The text data type cannot be selected as DISTINCT because it is not comparable the proc is a simple select distinct ...
1
vote
1answer
216 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
0
votes
1answer
146 views

What is causing Error 15165 in my MSSQL Transactional Replication subscription agent?

Microsoft SQL Server 2008 (SP1) Standard running on Windows 2008. Bidirectional transactional replication is set up between two servers. One of the subscription agents just started getting error ...
1
vote
2answers
2k views

SQL 2008 R2 replication error: The process could not connect to Distributor

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server ...
0
votes
1answer
2k views

SQL Server 2008 - Performance impact of transactional replication?

I'm planning to set up transactional replication for a 100Gb SQL Server 2008 database. I have the distributor and publisher on the same server, and am using push subscription. Should there be a ...
1
vote
1answer
557 views

SQL Server - VMWare Install - Transactional Replication causing 100% CPU

I am having severe trouble with a SQL Server - in particular, with transactional replication. We used to have a Windows 2003 physical machine, with SQL 2000. We call this “WebDB” The server was ...
0
votes
1answer
1k views

Replication doesn't start after reinitializing in MS SQL 2008 R2

After subscription had been marked for reinitialize, a new snapshot was generated. Log reader and queue reader agents are running. But when we try to turn on the synchronizing, we're getting the ...
0
votes
1answer
400 views

Creating indexes on tables filled from transactional replication - SQL 2005

I've got two SQL 2005 servers, one OLTP [let's call it SQLA] and one used for reporting [SQLB] to reduce load on SQLA when people run crazy queries. Our main database is replicated from SQLA to SQLB ...
2
votes
1answer
579 views

Adding new article to transactional replication gives error at subscriber

I have a updatable transactional replication set with SQL Server 2008. Everything is working fine. I added a new table to the existing publication through sp_addarticle followed by ...
0
votes
1answer
476 views

SQL 2005 Replication Error - Upgraded SP3

I recently upgraded my SQL 2005 server to SQL 2005 SP3. I have replication from SQL 2005 to SQL 2005 both are standard edition. During the upgrade I experienced no issues and the replication that was ...
0
votes
2answers
555 views

Options to handle corrupt msdb ldf file

Specs: We're using SQL Server 2005 with transactional replication. Our MSDB .LDF file has recently become corrupted, causing the MSDB db to be marked as 'suspect'. We read a bunch of stuff online ...
1
vote
1answer
2k views

Table modifications while running db replication (MS SQL 2008)

I'm running SQL Server 2008 Std with a database that is being published in a "Transactional Publication" to a single subscriber. We are unable to make any changes to the tables on the publisher ...
0
votes
1answer
44 views

Do I need to disable access to a publisher database when setting up SQL Server 2000 Transactional Replication?

I have a production database i.e. where there are constant updates and I've configured this to be published to another server using Transactional Replication. When I configure transactional ...
1
vote
0answers
91 views

Problem with MSDE 2000 5 minute keepalive over ISDN

We have a SQL Server transactionally pushing replicate data to an MSDE 2000 SP3a subscriber over ISDN. Prior to a recent upgrade to bring us to the MSDE 2000 level we pushed to MSDE 1. We are finding ...