备份: backup database test to disk='E:/test.bak' 还原: use master declare @mycur cursor declare @spid int set @mycur = cursor for select spid from master..sysprocesses where dbid=db_id('test') open @mycur fetch next from @mycur into @spid while @@fetch_status=0 begin exec('kill '+@spid) fetch next from @mycur into @spid end close @mycur deallocate @mycur restore database test from disk='E:/test.bak' with replace go
备份和还原数据库
最新推荐文章于 2024-03-30 10:04:23 发布