【源码】sql__备份数据库1__bak数据库__存储过程

--EXEC sys_BakDataBase 'vccrm4s',N'e:\'
CREATE PROCEDURE sys_BakDataBase 
    @backup_BaseName  nvarchar(255),
    @backup_path      nvarchar(50)
as
    declare @str_date         nvarchar(50),
            @backup_fullpath  nvarchar(255)
        

   --set @backup_path = N'e:\testbak\'

   -- make date string in backup filename
   set @str_date = convert(varchar(50), getdate(), 121)
   set @str_date = replace(@str_date, N'-', N'')
   set @str_date = replace(@str_date, N':', N'-')
   set @str_date = replace(@str_date, N'.', N'')
   set @str_date = replace(@str_date, N' ', N'-')

   -- backup master database
   set @backup_fullpath = @backup_path + @backup_BaseName + '-' +  @str_date + N'.full.bak'  --修改库名
   backup database  @backup_BaseName  to disk = @backup_fullpath  --修改库名
   PRINT @backup_fullpath