use master go if object_id('sp_restoreDB') is not null drop proc sp_restoreDB go create proc sp_restoreDB( @DBName sysname,--数据库名 @RestoreFiles nvarchar(1000)--路径如:c:\ ) as declare @S nvarchar(4000),@BackName nvarchar(200) set @BackName='backup'+convert(varchar(8),getdate(),112)+'.bak' set @S='BACKUP DATABASE ['+@DBName+'] TO DISK = N'''+@RestoreFiles+@BackName+''' WITH NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD, STATS = 10' exec(@S)
!
go
if object_id('sp_restoreDB') is not null
drop proc sp_restoreDB
go
create proc sp_restoreDB(
@DBName sysname,--数据库名
@RestoreFiles nvarchar(1000)--路径如:c:\
)
as
declare @S nvarchar(4000),@BackName nvarchar(200)
set @BackName='backup'+convert(varchar(8),getdate(),112)+'.bak'
set @S='BACKUP DATABASE ['+@DBName+'] TO DISK = N'''+@RestoreFiles+@BackName+''' WITH NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD, STATS = 10'
exec(@S)