Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 11, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Setting Up a Hot Backup Between Two SQL Servers

I want to set up a hot backup between two SQL servers on two different NT machines. In other words, if one of these servers goes down I want the second server to continue to work (transparently).

If this is possible, how do I change my client applications to work with this scenario?

Yes it is possible, but what happens to your client depends on how you accomplish it. You can do standby servers that receive hot backups from production, do clustering, or roll your own.

The transfer from server to server is seamless with clustering and log shipping because the application doesn't know that the server has changed. However, I have seen "roll your own" standby servers that require DBA intervention to bring them up, so that the change in server name clobbers the app's data source.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date