sp_addumpdevice 'disk','device1','c:/bak/device1.bak'
backup database demo
to device1
with name = 'full backup'
backup database demo
to device1
with DIFFERENTIAL,
name=' 差异1',
description='差异备份',
password='123'
backup log demo
to device2
with name='log1'
backup database demo
filegroup='primary'
--或
file=' 演示数据库_data'
to device2
with name='filegroup backup1'