Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people have no idea about what to consider when establishing a good database backup and recovery strategy. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

When establishing a good database backup and recovery strategy, you need to consider the following points:

1. Never back up the database to the local disk

We back up the SQL Server so that we can restore the data if the server crashes. If SQL Server crashes, especially if there is a hardware or serious operating system failure, we will need to be able to recover as soon as possible, and the local drive may not be available. Backing up to a network share is much safer, which allows you to immediately restore the backup to another server and come back online more quickly.

two。 After backing up the database to a file share, back up the share to tape

Nowadays, tape drives are fast enough that suppliers like to say that DBA should use tapes directly. Technically, they are correct: tape backup and restore speed is not a bottleneck. However, the number of drives available is limited, and tape drives are not always idle when DBA needs to be restored immediately. On the other hand, disk backups are always available.

3. Justify the cost of network sharing by reducing licensing costs and simplifying backup

Storage area networks (SAN) and backup administrators will need cost justifications for new dedicated arrays that are used only for SQL backups. That's it: dedicated arrays will recoup costs by eliminating the need for backup agents on each SQL Server. This will leave them with only one backup strategy: back up everything on the network share once a day and move it to another location as soon as possible. You don't have to worry about the peak load or which server is running on schedule, just back up the network share.

GoDadly cloud

After reading the above, have you mastered what you need to consider when establishing a good database backup and recovery strategy? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.