22,211
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
USE MyDB
GO
BACKUP DATABASE MyDB
TO TAPE = '\\.\tape0'
WITH FORMAT,
NAME = 'Full Backup of MyDB'
GO
随后,可以使用该备份重新建立 MyDB:
USE master
GO
RESTORE DATABASE MyDB
FROM TAPE = '\\.\tape0'
GO