示例5.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 14 行

USE sampleDB
GO
EXEC sp_addumpdevice 'disk', 'testDevice2', 'd:\testDevice2.bak'
GO
BACKUP DATABASE sampleDB TO testDevice2

BACKUP DATABASE sampleDB TO testDevice2 WITH INIT

BACKUP DATABASE sampleDB TO testDevice2 WITH NOINIT

USE sampleDB
GO
BACKUP DATABASE sampleDB TO testDevice,testDevice1
GO