实验报告但数据库原理与应用
姓名：雷锋 班级：电商14003班 学号：141201003XX
[实验名称]：备份恢复
[实验日期]：2015年12月23日
[实验目的]：
[实验要求]：
实验内容1：对[学生管理数据库]作一个完全备份,创建一个新表TEST1,作一次差异备份,创建一个新表TEST2,作一次差异备份,还原数据库[学生]
1.给物理备份新建一个备份设备，给它设置一个逻辑设备名称 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image1.png","imgOriW":893,"imgOriH":524})
设置恢复模式为完整备份2.
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image2.png","imgOriW":893,"imgOriH":524})
做完整恢复模式下的完整备份：3.
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image3.png","imgOriW":893,"imgOriH":524})
4.创建一个新表Test1 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"215.73","dataType":"png","c":"word/media/image4.png","imgOriW":893,"imgOriH":348})
数据库原理与应用 实验报告但
5.做完整恢复模式下的差异备份 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.27","dataType":"png","c":"word/media/image5.png","imgOriW":893,"imgOriH":523})
6.创建一个新表Test2 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"215.13","dataType":"png","c":"word/media/image6.png","imgOriW":893,"imgOriH":347})
数据库原理与应用 实验报告但
7.再做一次差异备份 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image7.png","imgOriW":893,"imgOriH":524})
8.还原数据库
）完全备份的还原1（．
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image8.png","imgOriW":893,"imgOriH":524})
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image9.png","imgOriW":893,"imgOriH":524})
）差异备份的还原2（．
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image10.png","imgOriW":893,"imgOriH":524})
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image11.png","imgOriW":893,"imgOriH":524})
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image12.png","imgOriW":893,"imgOriH":524})
实验报告但数据库原理与应用 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image13.png","imgOriW":893,"imgOriH":524})
：观察该实验中，有多少种还原策略，为什么？问题1 有两种还原策略。 1（）完整恢复模式下的完整备份；（2）完整恢复模式下的差异备份
实验内容2：对[学生管理数据库]作一个完全备份,创建一个新表TEST3,作一次事务日志备份,创建一个新表TEST4,作一次事务日志备份,还原数据库[学生]
数据库原理与应用 实验报告但
1.作一个完全备份 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.27","dataType":"png","c":"word/media/image14.png","imgOriW":893,"imgOriH":523})
2.创建一个新表Test3 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"215.73","dataType":"png","c":"word/media/image15.png","imgOriW":893,"imgOriH":348})
数据库原理与应用 实验报告但
3.作一次事务日志备份 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.27","dataType":"png","c":"word/media/image16.png","imgOriW":893,"imgOriH":523})
4.创建一个新表Test4 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"215.73","dataType":"png","c":"word/media/image17.png","imgOriW":893,"imgOriH":348})
数据库原理与应用 实验报告但
5.作一次事务日志备份 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_12","w":"553.67","h":"324.27","dataType":"png","c":"word/media/image18.png","imgOriW":893,"imgOriH":523})
6. 还原数据库
）数据库的限制访问，选择允许访问数据库的用户1（．
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_2","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image19.png","imgOriW":893,"imgOriH":524})
Test3
）还原2（．
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_2","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image20.png","imgOriW":893,"imgOriH":524})
Test4
）还原3（．
数据库原理与应用 实验报告但 ![](https://wkrtcs.bdimg.com/rtcs/image?w=553.67&md5sum=6b299e1926d10e178e291a8aff1804e1&sign=962a5851b4&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=596&ipr={"t":"img","r":"r_2","w":"553.67","h":"324.87","dataType":"png","c":"word/media/image21.png","imgOriW":893,"imgOriH":524})
问题1：观察该实验中，有多少种还原策略，为什么？
有两种还原策略。
（1）完整恢复模式下的完整备份；
（2）完整恢复模式下的事物日志备份
[教师评语]：
本文来源：https://www.2haoxitong.net/k/doc/b681161da2116c175f0e7cd184254b35eefd1aba.html
文档为doc格式