SQL SERVER备份数据库存储过程. 

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[dbBak]   

AS  
BEGIN  
   DECLARE @sqlCommand NVARCHAR(1000)  
   DECLARE @dateTime NVARCHAR(20) 
   SELECT @dateTime = REPLACE(CONVERT(VARCHAR, GETDATE(),111),'/','') +  
   REPLACE(CONVERT(VARCHAR, GETDATE(),108),':','')   
   SET @sqlCommand = 'BACKUP DATABASE BLNBusyData TO DISK = ''D:\DataBaseBakUp\bln_' + @dateTime + '.BAK'''   
   EXECUTE sp_executesql @sqlCommand
END
posted @ 2010-10-21 14:56  The Code Life  阅读(733)  评论(1)  编辑  收藏  举报