SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2009

Impact of uninstall instance on replication.

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…

Read more

0 comments, 1,462 reads

Posted in Vinay Thakur on 29 September 2009

Transaction Replication Backup/Restore or DR

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

Read more

0 comments, 1,595 reads

Posted in Vinay Thakur on 14 September 2009

Transaction replication info

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…

Read more

0 comments, 643 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…

Read more

0 comments, 620 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:
Thanks Michael Hotek for sharing this valuable info to all.

Read more

0 comments, 765 reads

Posted in Vinay Thakur on 3 September 2009


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
2. Create and configure the snapshot replication
3. create and…

Read more

0 comments, 689 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...


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....



Edit : 10132009:Sql server 2005 introduce to create our own Synonym. check… Read more

0 comments, 571 reads

Posted in Vinay Thakur on 2 September 2009