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.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved