Setting Up a Hot Backup Between Two SQL Servers

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.

See also  How College Students Can Shape the Future of Tech Responsibility

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist