sql server 数据库备份存储过程

-- =============================================
 -- Author:                <Author,,Name>
 -- Create date: <Create Date,,>
 -- Description:        目前要备份的数据库名,备份文件路径均写在过程中,不需外部传入
 -- =============================================
 CREATE PROCEDURE UP_BackUPDataBase 
         @databasename nvarchar(50)=null,
         @strPath NVARCHAR(200)=null
 AS
 BEGIN        SET NOCOUNT ON;
         if(@databasename is null)
         begin
                 set @databasename = 'IS60DB'
         end
         if(@strPath is null)
         begin
                 set @strPath = convert(NVARCHAR(19),getdate(),120)
                 set @strPath = REPLACE(@strPath, ':' , '.')
                 set @strPath = 'E:\DBBAck\' + @databasename+@strPath + '.bak'
         end
         BACKUP DATABASE @databasename  TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
 END
 GO