示例5.sql

SQL基础教程上的一些源码

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