Can you reinitialize the subscriptions with a new snapshot and let me know the result?

Erin Ramsay (3/20/2013)

---

As a follow-up example.

I have a table, call it tableA, that contains 1 million rows on my publisher and uses 103 MEGs of data space.

tableA in the...

Please check the options in the article properties. Probably you have disabled the option not to replicate the delete statements.

http://www.mssqltips.com/sqlservertip/2520/options-to-not-replicate-sql-server-delete-commands/

:unsure:

Oh I planned to setup peer-peer on SQL server only. I am not sure how to setup replication to MySQL. Haven't explored new features of 2012.

Actual thought is to seperate reads and writes traffic to different servers. If it doesn't work we can move back to the actual server. I also thought of using peer...

reason- for reporting purpose and to save money on license fees.

Please go through this link- answer is here.

http://www.mssqltips.com/sqlservertip/1564/database-mirroring-automating-failover-for-multiple-sql-server-databases/

Is your DBmirroring setup in synchronous mode or asynchronous mode?

Perry,

One more doubt on the cluster setting? Do we have to go with the default node majority or node and disk majority as we will be adding the second node...

Perry, In our envi we just have one node ready for installation....

Thanks Gila.

Let's assume i made one of the filegroup as read only. For the first time i need to restore the primary as with partial, recovery to make the db...

http://www.mssqltips.com/sqlservertip/1823/troubleshooting-slow-sql-server-replication-issue-due-to-distributor-database-growth/

Thanks Gila.

We are not archiving this table. Just adding rows to it which is causing more issues. As the table is growing bigger and bigger. So as said in my...

Hi,

I am also looking for the same, did you get the list of monitoring parameters you are going to be monitored and the thresholds- if you have any can you...

Does any one has done this earlier? please give some insight. Thanks