Full-house

1. SP_HELPDEVICE 查看服务器上每一个设备的相关情况。
2. SP_addumpdevice ‘disk’,'Test3′,’D:\test3′ 添加一个设备，这里的设备是磁盘。
3. sp_dropdevice ‘Test3′ 删除一个备份设备。
4. BACKUP DATABASE POP
   TO DISK=’D:\test.bak’
   WITH NOINIT,
   NAME= ‘POP 测试 备份 完整 2222′,
   DESCRIPTION=’THIS IS A FULL BACKUP OF POP’;
5. backup database pop
   to disk =’D:\test.bak’
   with Differential,
   noinit,
   name=’pop 差异备份’;
6. backup log pop
   to disk=’D:\test.bak’
   with noinit,
   name =’pop 日志备份测试’
7. backup database pop
   filegroup=’PRIMARY’
   to disk =’D:\test.bak’
   with name=’pop 文件组备份’