Vinay Thakur

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 to test the DR plan I uninstall \INSTANCE6 (goto CONTROL PANEL->ADD AND…

0 comments, 601 reads

Posted in Vinay Thakur on 29 September 2009

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:

1. make a log shipping enable for the publisher

2. Backup plan

Take…

0 comments, 615 reads

Posted in Vinay Thakur on 14 September 2009

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 how log reader works.

Before going for troubleshooting and issues…

0 comments, 111 reads

Posted in Vinay Thakur on 8 September 2009

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) we get and replication fails. some of them which I know…

0 comments, 159 reads

Posted in Vinay Thakur on 8 September 2009

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

0 comments, 191 reads

Posted in Vinay Thakur on 3 September 2009

Replication

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

2. Create and configure the snapshot replication
sp_addpublication

3. create and…

0 comments, 177 reads

Posted in Vinay Thakur on 3 September 2009

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 : 10132009:Sql server 2005 introduce to create our own Synonym. check… Read more

0 comments, 172 reads

Posted in Vinay Thakur on 2 September 2009

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog

Archives: September 2009

Impact of uninstall instance on replication.

Transaction Replication Backup/Restore or DR

Transaction replication info

Replication troubleshooting.

How Log reader works- replication

Replication

Data Type Synonyms