sql server 数据库作业备份存储过程

DECLARE @fileName nvarchar(100)
SET @fileName='D:\HFS\DataBase' + REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(100), GETDATE(), 121), ' ', ''), ':', ''), '-', ''), '.', '') + '.bak'
BACKUP DATABASE [HFBaseData] TO DISK = @fileName WITH NOINIT , NOUNLOAD , NAME = N'数据库-备份', NOSKIP , STATS = 10, NOFORMAT

posted @ 2017-06-26 09:15  野狼谷  阅读(388)  评论(0编辑  收藏  举报