【源码】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

转载于:https://www.cnblogs.com/chusiping/archive/2011/12/19/2293096.html