备份数据库
CREATE PROCEDURE [dbo].[Database]
AS
----auto back database
DECLARE @todayDate VARCHAR(50)
SET @todayDate= CONVERT (nvarchar(12),GETDATE(),112)
PRINT @todayDate
--select @todayDate
DECLARE @backName VARCHAR(100)
----路径请根据实际位置创建
SET @backName=N'F:\Data\[库名]_'+@todayDate+'.bak'
PRINT @backName
DECLARE @sql VARCHAR(300)
SET @sql='BACKUP DATABASE [库名] TO DISK = N'+''''+ @backName+ ''''+' WITH NOFORMAT, NOINIT, NAME = '+''''+'T1DB'+''''+', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10'
PRINT @sql
EXEC(@sql)