|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-the-complete-course-about-backup-and-restore/
课程评论：没有评论
课程名称：SQL Server：完整的备份与恢复课程 课程概述：您是否知道如何有效地进行备份？您是否制定了一个有效且稳健的备份策略？您是否听说过尾日志备份（TAIL LOG BACKUP）？本课程分为两个部分： 第一部分是初学者的基础知识，内容包括： - 如何简单地进行备份和恢复。 - 讨论备份日志和差异备份，以及在备份策略中为何必须实施这些措施。 - 理解在备份中使用WITH INIT的意义，并学习如何使用WITH STOPAT选项进行时间点恢复。 - 探讨不同的数据库完整恢复模型（FULL、SIMPLE和BULKED LOGGED），以及这些对备份的重要性。 第二部分为高级内容，涉及： - 多文件备份时的性能优化。 - 使用CHECKSUM避免备份损坏的重要性。 - 使用BACKUP WITH COPY ONLY避免中断备份链。 - 如何进行页面或LSN的恢复，避免长时间的恢复过程。 - 使用TAIL LOG BACKUP恢复未保存的日志。 - 使用备份压缩节省磁盘空间，以及如何利用WITH MIRROR选项进行备份的同时复制。 - 恢复系统数据库（如Master、MSDB、model、TEMPDB）。 - 使用RESTORE WITH STANDBY在每次恢复间隔查看数据。 - 最后，了解如何从快照恢复，以及进行备份所需的权限和备份元数据的查询。 为什么要开始学习SQL管理？SQL Server 是当前市场上非常抢手的技能。管理SQL Server 意味着您将拥有一份全职工作。每个演示都不超过10分钟，以保证学习的高效性。此外，SQL Server 的简便性使您能够迅速在特定领域内掌握技能。参加本课程将帮助您在技术上超越同事或在求职面试中脱颖而出，我们对此深信不疑。
Did you know that you can perform with your BACKUP?Are you sure you have an effective and robust BACKUP strategy in place?Have you ever heard of the TAIL LOG BACKUP ?This course is divided into two chapters: The first part, is the beginner's level part, where we will discuss the:How to make very simply a BACKUP and a RESTORE.Discuss the BACKUP LOGS and DIFFERENTIAL BACKUP, and why it is absolutely necessary to implement them in your BACKUP strategy.Understand the interest of the WITH INIT in a BACKUP, and learn how to make a restoration in time with the WITH STOPAT option.And finally, we will see the different full recovery model on a database(FULL,SIMPLE and BULKED LOGGUED), and why this is (very) important for our BACKUPs. The second part, which is longer, is the part of a more advanced level, we will discuss: The performance when doing a BACKUP on several files.Avoiding corruption on BACKUPs with the CHECKSUM, and understanding the importance of BACKUP WITH COPY ONLY, to avoid breaking the BACKUP chain during the day.To discover that you can make a RESTORE of a page, or from a LSN, to avoid losing hours of RESTORE, in case of server crash.Recover unsaved logs, in case of server crash, with the power of the TAIL LOG BACKUP.We will discuss the BACKUP WITH COMPRESSION, to save disk space, which can be significant, and the simultaneous copy of BACKUP with the WITH MIRROR option.We will also see how to restore system databases (Master, MSDB, model, TEMPDB).The RESTORE WITH STANDBY, which allows to examine the data between each RESTORE.And to finish, we will see how to make a RESTORE from a SNAPSHOT, see the necessary rights, to make BACKUP, how to consult BACKUP metadata.Why start SQL administration?SQL Server is one of the skills very actively sought after on the job market.Administering an SQL server today is ensuring that you have a full-time job.No demo is longer than 10 minutes (so it won't be too soporific). Moreover, SQL Server, because of its simplicity, allows you to quickly become competent in very specific areas.Following this course will help you to stand out technically from your colleagues, or during a job interview, I guarantee it.
