手动备份请参考:http://wenku.baidu.com/view/d57f283f453610661ed9f46a.html?from=search
准备:
1.完整备份数据库
BACKUP DATABASE CollectionDB TO DISK = 'E:\20150609_75\bak\Test_bak_full.bak' WITH INIT
2.差异备份数据库
BACKUP DATABASE CollectionDB TO DISK = 'E:\20150609_75\bak\Test_bak_diff.bak' WITH INIT, DIFFERENTIAL --加上DIFFERENTIAL代表差异备份
3.备份日志文件
BACKUP LOG CollectionDB TO DISK='c:\db_log.bak' WITH INIT
3.备份事务日志,文件名中包含当前时间,适合定时备份
DECLARE @strbackup NVARCHAR(100)
--改为日期加时间的
SET @strbackup = 'E:\20150609_75\bak\Test_bak_log_'
+ REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 120), '-', ''), ' ', ''), ':', '') + '.bak'
BAC