|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-backup-and-recovery-for-beginners/
课程评论：没有评论
课程名称：初学者的Microsoft SQL Server备份与恢复 课程概述：SQL Server的备份和恢复功能为保护存储在SQL Server数据库中的关键数据提供了必要的保障。为了最小化灾难性数据丢失的风险，您需要定期备份数据库，以保存对数据的修改。一个经过良好规划的备份和恢复策略能够有效保护数据库免受各种故障导致的数据丢失。您将通过还原一组备份并恢复数据库来测试您的策略，从而更好地应对潜在的灾难。 为什么要备份？备份您的SQL Server数据库、在备份上执行测试还原程序，并将备份的副本存储在安全的外部位置，可以有效防止灾难性数据丢失。备份是保护数据的唯一方式。有了有效的数据库备份，您可以从多种故障中恢复数据，包括： - 媒体故障 - 用户错误（例如，误删除表） - 硬件故障（例如，损坏的磁盘驱动器或服务器永久丢失） - 自然灾害 通过使用SQL Server备份到Azure Blob存储服务，您可以在与本地位置不同的区域创建离线备份，以便在自然灾害影响本地位置时使用。此外，数据库的备份还可用于常规管理目的，例如将数据库从一台服务器复制到另一台服务器、设置Always On可用性组或数据库镜像，以及归档。 本课程将帮助您掌握SQL Server备份与恢复的基础知识，提高您对数据安全和灾难恢复的应对能力。
The SQL Server backup and restore component provides an essential safeguard for protecting critical data stored in your SQL Server databases. To minimize the risk of catastrophic data loss, you need to back up your databases to preserve modifications to your data on a regular basis. A well-planned backup and restore strategy helps protect databases against data loss caused by a variety of failures. Test your strategy by restoring a set of backups and then recovering your database to prepare you to respond effectively to a disaster.Why back up?Backing up your SQL Server databases, running test restores procedures on your backups, and storing copies of backups in a safe, off-site location protects you from potentially catastrophic data loss. Backing up is the only way to protect your data.With valid backups of a database, you can recover your data from many failures, such as:Media failure.User errors, for example, dropping a table by mistake.Hardware failures, for example, a damaged disk drive or permanent loss of a server.Natural disasters. By using SQL Server Backup to Azure Blob storage service, you can create an off-site backup in a different region than your on-premises location, to use in the event of a natural disaster affecting your on-premises location.Additionally, backups of a database are useful for routine administrative purposes, such as copying a database from one server to another, setting up Always On availability groups or database mirroring, and archiving.
