Monthly Archives: December 2009

Error Log:

Following steps happened when sql server starts… we can see that in error log:: 1. Build of sql server and platform as Microsoft Sql server 2005 version. Edition on OS. 2. Windows process ID (kpid): 3. Error log file location. … Continue reading

Posted in What I learned today | Tagged | 2 Comments

Remove Replication:

I blog on how to configure the replication here with commands and a separate blog for replication setup here. I might have discussed about how to remove replication on my earlier blog but would like to have separate blog for future … Continue reading

Posted in Replication | Tagged | Leave a comment

Transactional Replication Conversations –Must read

  Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must read a great blog : http://blogs.msdn.com/chrissk/archive/2009/05/25/transactional-replication-conversations.aspx Summary: log reader read the transactions(Changes) with sp_replcmds, for xp_replcmds. then log reader … Continue reading

Posted in Replication | Tagged | 2 Comments