备份数据库
ALTER PROC [dbo].[BACKUP_DATABASE] (@file NVARCHAR(255))
AS
BEGIN
DECLARE @dbname NVARCHAR(255)
DECLARE @sqlstr NVARCHAR(4000)
DECLARE @dbfile NVARCHAR(255)
declare @itmp int
declare @iptmp int
declare @stmp varchar(100)
declare @tname varchar(250)
declare @now datetime
set @now = getdate()
select @itmp =DATEPART("ms",GETDATE())
select @stmp = convert(varchar(50), rand(@itmp))
set @stmp = substring(@stmp, 4, 4)
SET @dbname= DB_NAME()
set @tname = 'backup_'+@dbname +'_'+ convert(varchar(20), @now, 112)
+ convert(varchar(2), DATEPART("hh",@now)) + convert(varchar(2), DATEPART("mm",@now))
+ convert(varchar(2), DATEPART("ss",@now)) + @stmp
SET @dbfile=@file+@tname+'.bak'
--SELECT @dbfile
SET @sqlstr='BACKUP DATABASE '+@dbname+' TO DISK =N'''+ @dbfile +''' WITH NOFORMAT, NOINIT,NAME = N'''+@tname+'完整 数据库 备份'', SKIP, NOREWIND, NOUNLOAD, STATS = 10'
--SELECT @sqlstr
EXEC sp_executesql @sqlstr
SELECT fname= @tname
AS
BEGIN
DECLARE @dbname NVARCHAR(255)
DECLARE @sqlstr NVARCHAR(4000)
DECLARE @dbfile NVARCHAR(255)
declare @itmp int
declare @iptmp int
declare @stmp varchar(100)
declare @tname varchar(250)
declare @now datetime
set @now = getdate()
select @itmp =DATEPART("ms",GETDATE())
select @stmp = convert(varchar(50), rand(@itmp))
set @stmp = substring(@stmp, 4, 4)
SET @dbname= DB_NAME()
set @tname = 'backup_'+@dbname +'_'+ convert(varchar(20), @now, 112)
+ convert(varchar(2), DATEPART("hh",@now)) + convert(varchar(2), DATEPART("mm",@now))
+ convert(varchar(2), DATEPART("ss",@now)) + @stmp
SET @dbfile=@file+@tname+'.bak'
--SELECT @dbfile
SET @sqlstr='BACKUP DATABASE '+@dbname+' TO DISK =N'''+ @dbfile +''' WITH NOFORMAT, NOINIT,NAME = N'''+@tname+'完整 数据库 备份'', SKIP, NOREWIND, NOUNLOAD, STATS = 10'
--SELECT @sqlstr
EXEC sp_executesql @sqlstr
SELECT fname= @tname