Before continuing on to the article, I will consider the subtitle headings as follows.sql server 2015
Why is Database Mirroring Used?
What are the pre-requirements for mirroring?
Database Mirroring Configuration and Implementation.
Mirroring Test and Monitoring
Database Failover
Result
Before continuing on to the article, I would like to explain some technical English terms that I will use in the article beforehand.
Disaster: Used for disaster, unexpected errors and situations
Disaster Recovery: Disaster recovery and recoverysql server 2015
High Availability: High Availability Maximum servicesql server 2015
Principal: Used for the master server and database that hosts the source database.sql server 2015
Mirror: Used for the server and database where the copy of the source database will be kept.
Witness: A server that monitors Principal and Mirror servers and allows roles to be changed at any time of interruption.sql server 2015
Endpoint: A specific Object created on the network so that both servers can communicate.
1. Why is Database Mirroring Used?sql server 2015
Database mirroring is a solution that Microsoft has developed for SQL Server to provide unexpected failures, catastrophic failures in disaster situations, and high availability.
Microsoft first introduced this technology with SQL Server 2005. Therefore, this technology is not available in pre-release versions of SQL Server 2005. The Database Mirroring event is actively being used with SQL Server 2005/2008/2008 R2.
The Database Mirroring event is mainly used to maintain a mirror database on the mirror server in case the server is unable to service the database in the event of failure such as server failure, database corruption, disk corruption, and etc., which can occur in the source database by keeping an active copy of a database on a different server.
Zero data loss, Mirroring is the main goal in the Failover Cluster, Maximize service and business continuity. Another area where Mirroring technology is used is reporting.sql server 2015
To reduce the system load on OLTP systems Reporting teams can be redirected to the mirror database, which will reduce the workload on the main server. Of course, this situation is very overly intensive in order to relieve the database of transaction-receiving databases. One thing to note here is that the Mirror database is in the readable mode after the Snapshot is taken, but it can be reported in this way.sql server 2015
Why is Database Mirroring Used?
What are the pre-requirements for mirroring?
Database Mirroring Configuration and Implementation.
Mirroring Test and Monitoring
Database Failover
Result
Before continuing on to the article, I would like to explain some technical English terms that I will use in the article beforehand.
Disaster: Used for disaster, unexpected errors and situations
Disaster Recovery: Disaster recovery and recoverysql server 2015
High Availability: High Availability Maximum servicesql server 2015
Principal: Used for the master server and database that hosts the source database.sql server 2015
Mirror: Used for the server and database where the copy of the source database will be kept.
Witness: A server that monitors Principal and Mirror servers and allows roles to be changed at any time of interruption.sql server 2015
Endpoint: A specific Object created on the network so that both servers can communicate.
1. Why is Database Mirroring Used?sql server 2015
Database mirroring is a solution that Microsoft has developed for SQL Server to provide unexpected failures, catastrophic failures in disaster situations, and high availability.
Microsoft first introduced this technology with SQL Server 2005. Therefore, this technology is not available in pre-release versions of SQL Server 2005. The Database Mirroring event is actively being used with SQL Server 2005/2008/2008 R2.
The Database Mirroring event is mainly used to maintain a mirror database on the mirror server in case the server is unable to service the database in the event of failure such as server failure, database corruption, disk corruption, and etc., which can occur in the source database by keeping an active copy of a database on a different server.
Zero data loss, Mirroring is the main goal in the Failover Cluster, Maximize service and business continuity. Another area where Mirroring technology is used is reporting.sql server 2015
To reduce the system load on OLTP systems Reporting teams can be redirected to the mirror database, which will reduce the workload on the main server. Of course, this situation is very overly intensive in order to relieve the database of transaction-receiving databases. One thing to note here is that the Mirror database is in the readable mode after the Snapshot is taken, but it can be reported in this way.sql server 2015
0 yorum:
Yorum Gönder