 Definition of problem :
|
| |
An SQL server used by a Web application managing the company's fixed assets. In the case of a breakdown of the machine on which the SQL server is installed, there is no way of avoiding one or more days' loss of data. |
|
| Proposed solutions : |
| |
1. Implementing a daily tape backup procedure. |
| |
Advantage : |
| |
- As the server already has a tape drive, there is no additional cost. |
| |
Disadvantages : |
| |
- If the server breaks down, the data cannot be accessed and the loss of data can be of up to 24 hours.
- If there is a fire or theft in the company's premises, the data is irretrievably lost. |
|
| |
2. Installation of a second server on which the databases are replicated every hour. |
| |
Advantages : |
| |
- This
replication server is not situated in the same geographical location
as the main server, which enables the data to be preserved in the
case of a fire or theft.
- The maximum loss in this case is one hour. |
| |
Disadvantages : |
| |
- It is necessary to have an additional machine (which can be less powerful than the source server).
- It is necessary to have a second SQL Server license. |
|
| Solution adopted : |
| |
The company adopted solution 2 which is the more appropriate since it enables switching to the backup server in the case of a breakdown of the main server while incurring the lowest data loss (maximum of one hour) so giving optimal utilization of the network's resources. |
