DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '.')
set @strPath = 'G:/备份/datebase/' + @strPath + '.bak'
BACKUP DATABASE [taoqi@jingling2046@789] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
数据库作业备份存储过程
最新推荐文章于 2022-07-31 07:21:50 发布