Please enter search query.
Search <book_title>...
Veritas NetBackup™ for Microsoft SQL Server 管理指南
Last Published:
2018-04-15
Product(s):
NetBackup (8.1.1)
- 介绍 NetBackup for SQL Server
- 安装 NetBackup for SQL Server
- SQL Server 智能策略的实例管理
- 配置使用 SQL Server 智能策略的 SQL Server 备份
- 配置 NetBackup for SQL Server
- 执行 SQL Server 的还原
- 将 SQL Server 数据库重定向到其他主机
- 还原多数据流 SQL Server 备份
- 使用 VMware 备份保护 SQL Server 数据
- 关于使用 VMware 备份保护 SQL Server 数据
- 使用带有 Snapshot Client 的 NetBackup for SQL Server
- 保护高可用性 (HA) 环境中的 SQL Server
- 关于使用 NetBackup 保护 SQL Server 可用性组
- 关于 NetBackup for SQL Server 与数据库镜像
- 备份和恢复的概念
- 使用具有多个 NIC 的 NetBackup for SQL Server
- 利用客户端和批处理文件配置使用旧式 SQL Server 策略的备份
- 关于结合使用批处理文件和 NetBackup for SQL Server
- 关于 &; 日程表属性
- 备份只读文件组
- 使用 dbbackex 执行用户控制的操作
- 使用 bplist 检索 SQL Server 备份的列表
- SAP 环境中的 SQL Server 备份和还原(旧式 SQL Server 策略)
- 故障排除
- 关于用于排除 SQL Server 故障的调试日志记录
- SQL Server 的灾难恢复
- 附录 A. 批处理文件示例
- 附录 B. 多路复用的备份
- 附录 C. 注册授权位置
用于从文件组备份、多个文件备份和事务日志备份分段执行数据库还原的脚本
此示例显示了在“还原 Microsoft SQL Server 对象”对话框中生成的完全数据库还原的脚本。
OPERATION RESTORE OBJECTTYPE FILEGROUP DATABASE "DatabaseR" OBJECTNAME "PRIMARY" # The following image is type: Filegroup NBIMAGE "ca.MSSQL7.CA\SECOND.fg.DatabaseR.PRIMARY.7.001of001.20140701095634..C" SQLHOST "CA" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CA" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE FILEGROUP DATABASE "DatabaseR" OBJECTNAME "DBR_FG2" # The following image is type: Filegroup NBIMAGE "ca.MSSQL7.CA\SECOND.fg.DatabaseR.DBR_FG2.7.001of001.20140701095425..C" SQLHOST "CA" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CA" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File1" # The following image is type: File NBIMAGE "ca.MSSQL7.CA\SECOND.fil.DatabaseR.DBR_FG1_File1.7.001of001.20140701100824..C" SQLHOST "CA" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CA" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File2" # The following image is type: File NBIMAGE "ca.MSSQL7.CA\SECOND.fil.DatabaseR.DBR_FG1_File2.7.001of001.20140701100908..C" SQLHOST "CA" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CA" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File3" # The following image is type: File NBIMAGE "ca.MSSQL7.CA\SECOND.fil.DatabaseR.DBR_FG1_File3.7.001of001.20140701100953..C" SQLHOST "CA" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CA" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE TRXLOG DATABASE "DatabaseR" # The following image is type: transaction log NBIMAGE "ca.MSSQL7.CA\SECOND.trx.DatabaseR.~.7.001of001.20140701100030..C" SQLHOST "CA" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CA" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE TRXLOG DATABASE "DatabaseR" # The following image is type: transaction log NBIMAGE "ca.MSSQL7.CA\SECOND.trx.DatabaseR.~.7.001of001.20140701110015..C" SQLHOST "CA" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CA" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE RECOVERED ENDOPER TRUE