1
vote
1answer
149 views

Snapshot agent stuck at 48%

We are having to redo a publication/subscription and while running the snapshot agent it stalls at 48% with the message "The process is running and is waiting on a response from the server." ...
2
votes
1answer
716 views

Should snapshot agent continue to run in transactional replication?

We have transactional replication running for a large number of publications on sql server 2008 R2 2 node active/active cluster. I have noticed that the snapshot agent job runs hourly and it looks ...
4
votes
3answers
1k views

How to undo every change made to a database in a controlled environment?

I'm doing system testing of a product, and several tests are severely changing the data of a demo database. The data is quite complex to create queries which will undo the changes done by the tests; ...
1
vote
0answers
156 views

Transactional Replication times-out with Database Snapshot on subscription

I have a VLDB that is being replicated using transnational replication. The performance has been terrible, and the process frequently times out. After much investigation, including Service Packs and ...
5
votes
1answer
644 views

How can I determine the date of a snapshot in SQL Server 2008r2?

I am working on implementing an ETL process to load data into a warehouse. Part of this process is pulling data from our production server (Server P) to a staging server where the actual load into ...
7
votes
1answer
819 views

Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?

I am looking at snapshot replication between two servers. Here is what I have: 500GB database ~500MB nightly bcp loads ~50MB daily transactions I was asking other DBAs in the company about which ...
3
votes
1answer
187 views

SQL Server Snapshot Replication and SRDF compatability

Is there anything that breaks down if you use snapshot replication and then use SRDF for disaster recovery (DR) on the snapshot publisher? Specifically I am asking is: On the DR system, would the DR ...
8
votes
1answer
440 views

Are SQL Server Database writes slower with Snapshot Isolation?

I have a lot of deadlocks going on in my system. I would like to use Snapshot Isolation to fix them, but my DBA has reserves about it. One of his concerns is that Snapshot Isolation slows down ...