!!!由于计算机设置的差异,路径根据自己情况进行修改!!!数据库备份和恢复例131 例131创建逻辑备份设备 EXECspaddumpdeviceDISK,studentbackup,C:DataBaseBackupstudentbackup。bak 例132 例132完整备份示例,使用物理备份设备 BACKUPDATABASEStudent TODISKC:DataBaseBackupStudent。BAK 例133 例133差异备份示例 BACKUPDATABASEStudent TOStudentbackup WITHDifferential例134 例134事务日志备份示例 BACKUPLogStudent TODISKC:DataBaseBackupStudentlog。BAK 例135 例135文件和文件组备份示例 BACKUPDATABASEStudent FILEStudent TODISKC:DataBaseBackupStudentfile。BAK 例136 例136恢复完整备份示例 RESTOREDATABASEStudent FROMDISKC:DataBaseBackupstudent。bak例137 例137恢复差异备份举例 RESTOREDATABASEStudent FROMDISKC:DataBaseBackupStudent。BAK WITHNoRecovery RESTOREDATABASEStudent FROMStudentbackup例138 例138恢复事务日志备份示例 RESTOREDATABASEStudent FROMDISKC:DataBaseBackupStudent。BAK WITHNoRecovery RESTOREDATABASEStudent FROMStudentbackup WITHNoRecovery RESTORElogStudent FROMDISKC:DataBaseBackupStudentlog。BAK WITHNoRecovery例139 例139恢复文件备份示例 RESTOREDATABASEStudent FILEStudent FROMDISKC:DataBaseBackupStudentfile。BAK