Monthly Archives: September 2009

Impact of uninstall instance on replication.

Hi,   Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.   I have 6 instance on my box(yeah its true). and so many replication from one instance to other. and … Continue reading

Posted in Replication | Leave a comment

Transaction Replication Backup/Restore or DR

Hi,   Want to discuss on DR plan or Backup restore plan for transactional replication (here I will discuss on PUSH T replication).   Distribution database plays a very important role in Transactional replication.   The DR plan would be: … Continue reading

Posted in Replication | Tagged | 4 Comments

Replication troubleshooting.

Hi All, Continue on Transaction replication discussion: Today I would like to share some of the  important ways of handling/troubleshooting replication issues which i come across and learned during my work on Transactional replication.   There are some common issues(errors) … Continue reading

Posted in Replication | Tagged | 5 Comments

Transaction replication info

Hi,   To continue with the replication discussion, on my last post i discussed on some important commands and sp’s for how to configure the replication and its steps.. (I will be discussing only about Transactional Replication). and also about … Continue reading

Posted in Replication | Tagged | Leave a comment

How Log reader works- replication

Just saw the the answer by michael Hotek for how log reader works on replication: looks very great:  http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d2d2e1c6-01ee-439b-93e8-e31c77c0cd28/     Thanks Michael Hotek for sharing this valuable info to all.   Thanx. Vinay

Posted in Replication | Tagged | Leave a comment

Replication Configuration and Basics

Hi, Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction replication, and might also 2005/2008   >>Cust steps to configure replication(Transactional). 1. Configure the server /database for replication sp_replicationdboption … Continue reading

Posted in Replication | Tagged | Leave a comment

Data Type Synonyms

Today on sql server central QOD. very interesting question on Data Type Synonyms… http://www.sqlservercentral.com/questions/Programming/67390/ We can use the synonyms data type also for declaring data type… e.g.. varchar(20) would be equivalent to char varying(20) interesting isn’t it…. http://msdn.microsoft.com/en-us/library/ms177566(SQL.90).aspx   Edit … Continue reading

Posted in Computers and Internet | Leave a comment