Here is another customer question about Replication I thought worth sharing. I am using SQL Server 2008 64 bits. I have to change the location of the data file (i.e. MDF file). I was planning to detach and attach. DB is also using Transactional Replication so I can’t detach the DB. Is there any way
Read More »
Anurag Sharma | Microsoft SQL Server Escalation Services Log Reader fails with below error message The process could not execute ‘sp_repldone/sp_replcounters’ on ‘SQLGUY’. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 The log scan number (23:49:3) passed to log scan in database ‘PUBLISHER’ is not valid. This error may indicate data corruption or that the
Read More »
Rishi Maini | Microsoft SQL Server Escalation Services All about “Not for Replication” “Not for Replication” is a property which can be set for different objects like Check constraints, Foreign Key constraints, Triggers , Identity columns etc while using SQL Server Replication. Feature used when the DBA would like the transactions to behave differently when
Read More »
I wanted a quick way to execute a TSQL command against all databases. I was having hard time getting the sp_MSforeachdb to work and didn’t want to write a cursor, so I instead built a TSQL command which makes the commands I need to execute. Not fancy, but it got the job done. –Command to
Read More »
I was recently asked for recommendations for Merge Replication capacity planning project. While I spend most of my time tuning and troubleshooting Replication environments, I decided to post some thoughts on about stress testing and capacity planning. I hope this posting helps as you are designing your Merge Replication environment. Background Reading Merge Replication Performance
Read More »