Win a copy of Kubernetes in Action this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Replication of data in SQL Server  RSS feed

Ranch Hand
Posts: 527
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Reqt. is to replicate data in two DB servers(using Publication & Subscription in SQL Server2000) as data is synchronized , initially I fetch data from First DB server, if its down I go for Secong DB server and fetch the data and vice versa as this procedure continues throughout my application and so need to ping everytime I open a connection to DB server and check whether its running.
So, is there any other alternative to test whether connection object is alive to proceed to other server.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!