--2.进行数据库备份
declare @dbname varchar(256)
declare @sql varchar(8000)
declare cur cursor local for
select name from master..sysdatabases where dbid>4
open cur
fetch next from cur into @dbname
while @@fetch_status=0
begin
set @sql='backup database '+@dbname
+' to disk=''z:\'+@dbname
+'.bak'''
exec(@sql)
fetch next from cur into @dbname
end
close cur
deallocate cur
--3.备份完成后删除映射
exec master..xp_cmdshell 'net use z: /delete'
create proc bak_db
as
declare @SqlStr varchar(8000)
select @SqlStr=''
select @SqlStr=@SqlStr+'backup database '+name+' to disk=''D:\'+name+'.bak'''+CHAR(10)
from master..sysdatabases where dbid>=7
exec(@SqlStr)
go
declare @dbname varchar(256)
declare @sql varchar(8000)
declare cur cursor local for
select name from master..sysdatabases where dbid>4
open cur
fetch next from cur into @dbname
while @@fetch_status=0
begin
set @sql='backup database '+@dbname
+' to disk=''D:\'+@dbname
+'.bak''
exec(@sql)
fetch next from cur into @dbname
end
close cur
deallocate cur