create table #v_group(tbname varchar(200))
insert into #v_group(tbname)values('数据库1')
insert into #v_group(tbname)values('数据库2')
insert into #v_group(tbname)values('数据库3')
declare @path varchar(300)--备份路径
SET @path='D:\web\20240506\'
--申明一个游标
DECLARE MyCursord CURSOR FOR
SELECT *
FROM #v_group
--打开一个游标
OPEN MyCursord
--循环一个游标
DECLARE @tbname varchar(300) FETCH NEXT
FROM MyCursord INTO @tbname WHILE @@FETCH_STATUS =0 BEGIN declare @v_backup_database varchar(100),
@v_path varchar(300),
@vname varchar(100),
@mdf varchar(100),
@ldf varchar(100),
@tb1 varchar(300),
@tb2 varchar(300)
--备份数据库
SET @vname='.bak'
SET @v_backup_database=@tbname
SET @v_path=@path+@v_backup_database+@vname
BACKUP DATABASE @v_backup_database TO DISK=@v_path
WITH INIT --备份数据库
FETCH NEXT
FROM MyCursord INTO @tbname
END --关闭游标
--释放资源
DEALLOCATE MyCursord
drop table #v_group
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交