！！！由于计算机设置的差异，路径根据自己情况进行修改！！！

数据库备份和恢复

例13-1

/*例13-1创建逻辑备份设备*/

EXEC sp_addumpdevice 'DISK','student_backup','C:DataBaseBackupstudent_backup.bak'

例13-2

/*例13-2完整备份示例，使用物理备份设备*/

BACKUP DATABASE Student

TO DISK ='C:DataBaseBackupStudent.BAK'

例13-3

/*例13-3差异备份示例*/

BACKUP DATABASE Student

TO Student_backup

WITH Differential

例13-4

/*例13-4事务日志备份示例*/

BACKUP Log Student

TO DISK='C:DataBaseBackupStudent_log.BAK'

例13-5

/*例13-5文件和文件组备份示例*/

BACKUP DATABASE Student

FILE ='Student'

TO DISK='C:DataBaseBackupStudent_file.BAK'

例13-6

/*例13-6恢复完整备份示例*/

RESTORE DATABASE Student

FROM DISK='C:DataBaseBackupstudent.bak'

例13-7

/*例13-7恢复差异备份举例*/

RESTORE DATABASE Student

FROM DISK='C:DataBaseBackupStudent.BAK'

WITH NoRecovery

RESTORE DATABASE Student

FROM Student_backup

例13-8

/*例13-8恢复事务日志备份示例*/

RESTORE DATABASE Student

FROM DISK='C:DataBaseBackupStudent.BAK'

WITH NoRecovery

RESTORE DATABASE Student

FROM Student_backup

WITH NoRecovery

RESTORE log Student

FROM DISK='C:DataBaseBackupStudent_log.BAK'

WITH NoRecovery

例13-9

/*例13-9恢复文件备份示例*/

RESTORE DATABASE Student

FILE='Student'

FROM DISK='C:DataBaseBackupStudent_file.BAK'