配置好 2012 AlwaysOn High availability Group就想体验一下在辅助数据库做备份的新功能。在辅助服务器备份,这样可以减轻主服务器的负载(非常好的一项改进,以前Databasemirroring辅助数据库是不可以访问的)。
但是备份的时候却报错:
Backup databasetesttodisk
='c:\test.bak'
Msg 3059, Level 16, State 1, Line 2
This BACKUP or RESTORE command is not supported ona database mirror or secondary replica.
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
查了一下微软的网站才发现在辅助服务器备份有限制和局限性的:
·辅助副本只完全支持 BACKUP LOG。BACKUP DATABASE仅支持数据库、文件或文件组的仅复制完整备份。辅助副本不支持差异备份。
注意
|
仅复制备份不影响日志链。同样,仅复制备份也不清除差异位图。
|
·若要备份辅助数据库,辅助副本必须能够与主副本进行通信,并且状态必须为 SYNCHRONIZED或 SYNCHRONIZING。
·配置可用性组以支持辅助副本备份只会为要执行备份的位置创建备份首选项。
将脚本修改为Copy_Only选项备份成功:
backup databasetesttodisk
='c:\test.bak'withcopy_only
Processed 328 pages for database 'test', file'test' on file 1.
Processed 1 pages for database 'test', file'test_log' on file 1.
BACKUP DATABASE successfully processed 329 pages in0.140 seconds (18.327 MB/sec).
备份日志不需要Copy_Only选项:
Backup log
test to disk='c:\test.trn'
参考:http://msdn.microsoft.com/zh-cn/library/hh710053.aspx
分享到:
相关推荐
1、可以完好无损的备份你手机里的短信到SD卡,并且随时可以还原。 2、短信还原时,有重复检验功能,保证还原时已有的短信不会重复出现。 3、支持Android 2.2 ...- Dropbox support, needs Add-On v2.0+
backup and restore
db2 backup restore
Be instructed on backup and restore techniques and principles Understand the importance of a fully implemented backup plan in SQL Server Agent Integrate backup and restore techniques into an ...
rman backup and restore.
全面, 深入的讲解SqlServer数据库的各种备份和恢复策略和方案
Clonezilla for Win 8 and 8.1 Backup and Restore
Site Collection & Farm Backup/restore
RESTORE DATABASE命令还原SQLServer 2005 数据库
Easy Backup and Restore MySQL utility.
cognito-backup-restore试图通过提供一种将用户从cognito池备份到json文件,反之亦然的方法来克服此问题。 请注意:无法通过cognito获取用户密码,因此您可能需要要求他们使用ForgotPassword来恢复其帐户。 要求 ...
Java&C++ SDK for FusionSphere Backup&Restore
Symantec Backup Exec 2012 is a high-performance data management solution for Windows® servers networks. With its client/server design, Backup Exec provides fast, reliable backup and restore ...
I959_EFS_Backup_Restore_WIN
Informix V12.10--Backup and Restore Guide-285
Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the ...
FlashTool backup download format restore
this script it's just to create a backup or restore your database.
veeam_backup_9_5_u4_backup_restore_sql_pg_IT软件公司技术售前方案.pdf