Code
create procedure MY_BACKUP
--CREATED BY momada ON DEC-17-2007
--EXAMPLE: EXEC EWAY_BACKUP
AS
declare @sql varchar(3000)
set @sql='BACKUP DATABASE [Y2] TO DISK =
N''e:\数据库自动备份\Y2_db_'+convert(varchar(8),getdate(),112)+left(replace(convert(varchar(14),getdate(),108),':',''),4)+'.BAK''' +' WITH NOINIT , NOUNLOAD , NAME = N''Y2 备份'', NOSKIP , STATS = 10, NOFORMAT '
print @sql
exec(@sql)
GO
create procedure MY_BACKUP
--CREATED BY momada ON DEC-17-2007
--EXAMPLE: EXEC EWAY_BACKUP
AS
declare @sql varchar(3000)
set @sql='BACKUP DATABASE [Y2] TO DISK =
N''e:\数据库自动备份\Y2_db_'+convert(varchar(8),getdate(),112)+left(replace(convert(varchar(14),getdate(),108),':',''),4)+'.BAK''' +' WITH NOINIT , NOUNLOAD , NAME = N''Y2 备份'', NOSKIP , STATS = 10, NOFORMAT '
print @sql
exec(@sql)
GO