Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Read more

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

Read more

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

Read more

0 comments, 245 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, 297 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.
 
Thanx.
Vinay

Read more

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

Read more

0 comments, 311 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, 274 reads

Posted in Vinay Thakur on 2 September 2009