ALTER PROCEDURE USP_DBBackup
	@BackPath nvarchar(100)
	@BackName nvarchar(50)
AS
	SET NOCOUNT ON 
	 declare cur cursor for
	 select name from master..SysDataBases	--ȡݿ.
	 declare @cur nvarchar(4000)
	 open cur
	 fetch next from cur into @cur
	 while @@fetch_status = 0
	 begin
		 exec(@cur)
		 fetch next from cur into @cur
	 end
	 declare @name nvarchar(4000)
	 set @name = ''
	 select @name += @cur + ','
	backup database Left(@name, Len(@name) - 1) to disk= @BackPath + '\'+@BackName	--ϻõݿ.