第11章 备份和恢复.pptVIP

11.2备份数据库 11.2.2 执行完整数据库备份 2．利用Transact-SQL语句创建完整数据库备份 完整数据库备份是通过BACKUP DATABASE语句来执行的，其简单语法形式如下： ?BACKUP DATABASE {database_name | @database_name_var } TO backup_device [ ,...n ] [ WITH ?????[ BLOCKSIZE = { blocksize | @blocksize_variable } ] ????? ?????[ [ , ] DESCRIPTION = { text | @text_variable } ] ?????[ [ , ] DIFFERENTIAL ] ?????[ [ , ] EXPIREDATE = { date | @date_var } ??? ??| RETAINDAYS = { days | @days_var } ] ?????[ [ , ] PASSWORD = { password | @password_variable } ] ?????[ [ , ] { FORMAT | NOFORMAT } ] ?????[ [ , ] { INIT | NOINIT } ] ?????[ [ , ] { NOSKIP | SKIP } ]