备份 DECLARE @strPath NVARCHAR(200) set @strPath = convert(NVARCHAR,getdate(),120) set @strPath='hq'+rtrim(left(replace(@strPath,'-',''),8)) set @strPath = 'D:\sqlback\mydb\' + @strPath + '.bak' BACKUP DATABASE [mydb] TO DISK = @strPath WITH NOFORMAT, NOINIT, NAME = N'mydb-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO 删除 declare @date nvarchar(20) set @date=convert(nvarchar,dateadd(d,-1,getdate()),120) EXECUTE master.dbo.xp_delete_file 0,N'D:\sqlback\mydb',N'bak',@date set nocount on --开启xp_cmdshell支持 exec sp_configure 'show advanced options', 1 reconfigure with override exec sp_configure 'xp_cmdshell', 1 reconfigure with override exec sp_configure 'show advanced options', 0 reconfigure with override print char(13)+'------------------------'