What is standby server in SQL Server?

What is standby server?

  • Standby server is the type of server which is brought online when primary server goes offline and the application needs continuous availability of the server.

There are three types of standby servers:

Hot standby: Hot standby method is a method of redundancy in which the primary and secondary backup systems run simultaneously so the data also present in secondary server in a real time and this way both system contains identical information.

Warm standby: Warm standby is a method of redundancy in which the secondary system runs in the background of the primary system. Data is mirrored in the secondary server at regular interval, so in this method sometimes both servers don’t contain the exact same data.

Cold standby: Cold standby is the method of redundancy in which the secondary server is only called when the primary server fails. Cold standby systems are used in cases where data is changed infrequently or for nor critical applications.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s