第一章 概览
........................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... .................4
1.1
简介
...................................................................................................4
1.1.1 SQL Server
备份
.....................................................................................4
1.1.2 SQL Server
恢复
.....................................................................................5
1.2 SQL Server
定时备份支持功能
...............................................................6
第二章 限制性列表
........................ . . . . . . . . . . . . . . . . . . . . . . . . . . . . ... ......................7
第三章
SQL Server
备份环境检查
........................ . . . . . . . . . . . . . . . . . ... ................8
3.1
备份前置条件检查
................................................................................8
3.1.1
数据库状态检查
.......................................................................................8
3.1.2
身份验证
................................................................................................8
3.1.3
客户端版本
.............................................................................................8
3.2
介质服务器检查及配置
.........................................................................9
第四章 定时备份最佳实践
........................ . . . . . . ... .................... ... ... ........10
4.1 SQL Server
定时备份最佳实践
.............................................................10
4.1.1
命名规则说明
........................................................................................10
4.1.2
定时备份任务建立
.................................................................................10
4.2 FAQs
...............................................................................................16
第五章 定时恢复最佳实践
........................ . . . . . . ... .................... ... ... ........22
5.1
浏览恢复应用场景及恢复方式选择
.......................................................22
5.2 SQL Server
定时恢复最佳实践
.............................................................22
5.2.1
普通恢复注意事项
.................................................................................22
5.2.2 SQL Server
双机环境恢复注意事项
..........................................................23
5.2.3
恢复步骤
..............................................................................................23
5.3 FAQs
...............................................................................................25
评论