数据库实验5实验

实验5：数据库备份与恢复备注：本实验是在自己电脑上面的Test1数据库上面进行操作的1. 针对数据库stu创建完全数据库备份集stu.bak，目标磁盘为D： user stu.bak；BACKUP DATABASE Test1 TO DISK = ND:usersstu.bak WITH NOFORMAT, NOINIT, NAME = NTest1-完整数据库备份,SKIP, NOREWIND, NOUNLOAD, STATS = 10GO截图：2. 在数据库stu中新建数据表ceshi，内容自定，然后针对数据库stu创建差异备份；BACKUP DATABASE Test1 TO DISK = ND:usersstu_new.bak WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = NTest1-差异数据库备份, SKIP, NOREWIND, NOUNLOAD, STATS = 10GO截图：3. 向数据库stu的数据表ceshi插入部分记录，然后针对数据库stu创建事务日志备份；BACKUP LOG Test1 TO DISK = ND:usersstu_records.bak WITH NOFORMAT, NOINIT, NAME = NTest1-事务日志备份, SKIP, NOREWIND, NOUNLOAD, STATS = 10GO4. 根据需要，将数据库恢复到数据库stu的最初状态；RESTORE DATABASE Test1 FROM DISK = ND:usersstu.bak WITH FILE = 4, NORECOVERY, NOUNLOAD, STATS = 10GO5. 根据需要，将数据库恢复到创建数据表ceshi后的状态；RESTORE DATABASE Test1 FROM DISK = ND:usersstu_new.bak WITH FILE = 5, NOUNLOAD, STATS = 10GO6. 根据需要，将数据库恢复到在ceshi表插入记录后的状态；RESTORE DATABASE Test1 FROM DISK = ND:usersstu_records.bak WITH FILE = 6, NOUNLOAD, STATS = 10GO7. 针对现有数据库stu创建完全文件和文件组备份集stu_file，目标磁盘为D： user stu_file.bak；BACKUP DATABASE Test1 FILEGROUP = NPRIMARY TO DISK = ND:usersstu_file.bak WITH NOFORMAT, NOINIT, NAME = NTest1-完整文件组备份, SKIP, NOREWIND, NOUNLOAD, STATS = 10GO8. 在当前数据库中新建数据表ceshi2，然后针对数据库stu创建差异文件和文件组备份；BACKUP DATABASE Test1 FILEGROUP = NPRIMARY TO DISK = ND:usersstu_file_chayi.bak WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = NTest1-差异文件组备份, SKIP, NOREWIND, NOUNLOAD, STATS = 10GO9. 向数据库stu的数据表ceshi2插入部分记录，然后针对数据库stu创建事务日志文件和文件组备份；BACKUP LOG Test1 TO DISK = ND:usersstu_file_shiwu.bak WITH NOFORMAT, NOINIT, NAME = NTest1-事务日志数据库备份, SKIP, NOREWIND, NOUNLOAD, STATS = 10GOBACKUP DATABASE Test1 FILEGROUP = NPRIMARY TO DISK = ND:usersstu_file_files.bak WITH NOFORMAT, NOINIT, NAME = NTest1-完整文件组备份, SKIP, NOREWIND, NOUNLOAD, STATS = 10GO10. 根据需要，将数据库以文件和文件组方式恢复到创建数据表ceshi2后的状态；RESTORE DATABASE Test1 FILE = Ndatabasereporter FROM DISK = ND:usersstu_file_chayi.bak WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 10GORESTORE LOG Test1 FROM DISK = ND:usersstu_file_shiwu.bak WITH FILE = 1, NOUNLOAD, STATS = 10GO11.根据需要，将数据库以文件和文件组方式恢复到数据表ceshi2插入记录后的状态；RESTORE DATABASE Test1 FILE = Ndatabasereporter FROM DISK = ND:usersstu_file_files.bak WITH FILE = 1, NOUNLOAD, STATS = 10GO实验6：导入导出数据1.导入数据 将excel中的数据导入到数据库：insert into student select * from OPENROWSET(MICROSOFT.JET.OLEDB.4.0,Excel 5.0;HDR=YES;DATABASE=E:HTML项目校友管理系统学生表.xls,sheet1$)2. 导出数据将excel中的数据导出道excel表格： 3.实验心得数据的导入与导出在大型数据库应用中十分常见，数据的批量导入，能方便用户操作，方便高校，批量数据导出，一方面可以及时备份数据库中的内容，另一方面能帮助用户导出所需要的内容，方便查看和打印，这种数据库与excel之间实现导入与导出的代码，是我从网上找到的，发现真的很实用和方便，也不容易出差错。但是在导入的过程中一定要注意excel的格式，不然就导不进去，同时需要将这行代码运行exec sp_configure show advan