ALTER proc [P_DBBACKUP](@DbName varchar(50))
as
DECLARE @dbPath VARCHAR(200)
select @dbPath='E:\bak\'
select @dbPath=@dbPath+@DbName+'_'+convert(varchar(20),getdate(),112)+replace(convert(varchar(20),getdate(),108),':','')+'.bak'
BACKUP DATABASE @DbName
TO DISK = @dbPath
WITH INIT
,NOUNLOAD
,NAME = N'backup database'
,NOSKIP
,STATS = 10
,NOFORMAT
