资源描述:
《数据库实验5&实验6.doc》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、实验5:数据库备份与恢复备注:本实验是在自己电脑上面的Test1数据库上面进行操作的1.针对数据库stu创建完全数据库备份集stu.bak,目标磁盘为D:userstu.bak;BACKUPDATABASE[Test1]TODISK=N'D:usersstu.bak'WITHNOFORMAT,NOINIT,NAME=N'Test1-完整数据库备份',SKIP,NOREWIND,NOUNLOAD,STATS=10GO截图:2.在数据库stu中新建数据表ceshi,内容自定,然后针对数据库stu创建差异备份;BACKUPDATABASE[
2、Test1]TODISK=N'D:usersstu_new.bak'WITHDIFFERENTIAL,NOFORMAT,NOINIT,NAME=N'Test1-差异数据库备份',SKIP,NOREWIND,NOUNLOAD,STATS=10GO截图:1.向数据库stu的数据表ceshi插入部分记录,然后针对数据库stu创建事务日志备份;BACKUPLOG[Test1]TODISK=N'D:usersstu_records.bak'WITHNOFORMAT,NOINIT,NAME=N'Test1-事务日志备份',SKIP,NOREWIN
3、D,NOUNLOAD,STATS=10GO2.根据需要,将数据库恢复到数据库stu的最初状态;RESTOREDATABASE[Test1]FROMDISK=N'D:usersstu.bak'WITHFILE=4,NORECOVERY,NOUNLOAD,STATS=10GO3.根据需要,将数据库恢复到创建数据表ceshi后的状态;RESTOREDATABASE[Test1]FROMDISK=N'D:usersstu_new.bak'WITHFILE=5,NOUNLOAD,STATS=10GO1.根据需要,将数据库恢复到在ceshi表插入
4、记录后的状态;RESTOREDATABASE[Test1]FROMDISK=N'D:usersstu_records.bak'WITHFILE=6,NOUNLOAD,STATS=10GO2.针对现有数据库stu创建完全文件和文件组备份集stu_file,目标磁盘为D:userstu_file.bak;BACKUPDATABASE[Test1]FILEGROUP=N'PRIMARY'TODISK=N'D:usersstu_file.bak'WITHNOFORMAT,NOINIT,NAME=N'Test1-完整文件组备份',SKIP,
5、NOREWIND,NOUNLOAD,STATS=10GO3.在当前数据库中新建数据表ceshi2,然后针对数据库stu创建差异文件和文件组备份;BACKUPDATABASE[Test1]FILEGROUP=N'PRIMARY'TODISK=N'D:usersstu_file_chayi.bak'WITHDIFFERENTIAL,NOFORMAT,NOINIT,NAME=N'Test1-差异文件组备份',SKIP,NOREWIND,NOUNLOAD,STATS=10GO1.向数据库stu的数据表ceshi2插入部分记录,然后针对数据库stu
6、创建事务日志文件和文件组备份;BACKUPLOG[Test1]TODISK=N'D:usersstu_file_shiwu.bak'WITHNOFORMAT,NOINIT,NAME=N'Test1-事务日志数据库备份',SKIP,NOREWIND,NOUNLOAD,STATS=10GOBACKUPDATABASE[Test1]FILEGROUP=N'PRIMARY'TODISK=N'D:usersstu_file_files.bak'WITHNOFORMAT,NOINIT,NAME=N'Test1-完整文件组备份',SKIP,NORE
7、WIND,NOUNLOAD,STATS=10GO1.根据需要,将数据库以文件和文件组方式恢复到创建数据表ceshi2后的状态;RESTOREDATABASE[Test1]FILE=N'databasereporter'FROMDISK=N'D:usersstu_file_chayi.bak'WITHFILE=1,NORECOVERY,NOUNLOAD,STATS=10GORESTORELOG[Test1]FROMDISK=N'D:usersstu_file_shiwu.bak'WITHFILE=1,NOUNLOAD,STATS=10G
8、O11.根据需要,将数据库以文件和文件组方式恢复到数据表ceshi2插入记录后的状态;RESTOREDATABASE[Test1]FILE=N'databasere