SQL:使用备份向导、SQL命令、导出数据三种方式对已建立的数据库进行备份
SQL:使用备份向导、SQL命令、导出数据三种方式对已建立的数据库进行备份
题目要求
使用备份向导备份数据库 “DEMO_4_2_2_1”到考生文件夹“a.bak”下,截屏并导出备份设置界面(必须包括“源”、“备份集”、“目标”的设置),命名为“2.2.1a.jpg”。
解题步骤
T1、(1)使用备份向导方式
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzA5LzI4MTgvMjMxMjUxNDU3XzE0XzIwMjEwOTI5MDE1NTEwMzk2.jpg)
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzA5LzI4MTgvMjMxMjUxNDU3XzE1XzIwMjEwOTI5MDE1NTEwNjYx.jpg)
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzA5LzI4MTgvMjMxMjUxNDU3XzE2XzIwMjEwOTI5MDE1NTEwODk2.jpg)
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzA5LzI4MTgvMjMxMjUxNDU3XzE3XzIwMjEwOTI5MDE1NTExMTkz.jpg)
(2)备份到自建立的设备中
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzA5LzI4MTgvMjMxMjUxNDU3XzE4XzIwMjEwOTI5MDE1NTExMzk2.jpg)
T2、使用SQL命令方式
backup database DEMO_4_2_1 to disk ='E:\File_SQLServer\kaosheng\abc.bak'
T3、使用导出数据方式
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
赞 (0)