-- drop proc dbo.databackup
-- exec dbo.databackup
CREATE proc dbo.databackup
as
declare @path varchar(50)
declare @filename varchar(60)
SET DATEFIRST 1
set @path='F:\database_bak\'
set @filename=@path+'OA'+convert(varchar(13),getdate(),126)+'.bak'backup database TESTDB1 to disk=@filename
backup database TESTDB2 to disk=@filename
backup database TESTDB3 to disk=@filename
....
..
GO
-- exec dbo.databackup
CREATE proc dbo.databackup
as
declare @path varchar(50)
declare @filename varchar(60)
SET DATEFIRST 1
set @path='F:\database_bak\'
set @filename=@path+'OA'+convert(varchar(13),getdate(),126)+'.bak'backup database TESTDB1 to disk=@filename
backup database TESTDB2 to disk=@filename
backup database TESTDB3 to disk=@filename
....
..
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货