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 ...
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; ...
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 ...
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 ...
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 ...
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 ...
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 ...