restore database AAA from disk='D:\AAA.BAK' with replace如何关闭现有连接

[muyebo]

use master
go
restore database AAA from disk='D:\AAA.BAK' with replace
总容易出现数据库正在使用中,如何用sql语句将现有连接关闭

[no_mIss]

use master
go
alter database AAA set SINGLE_USER with ROLLBACK IMMEDIATE 
go
restore database AAA from disk='D:\AAA.BAK' with replace 
go

[liangCK]

DECLARE @cmd VARCHAR(500);
SET @cmd='';
SELECT
    @cmd=@cmd+';KILL '+RTRIM(spid)
FROM master.dbo.sysprocesses
WHERE dbid=db_id('数据库名');

EXEC(@cmd);

GO

RESTORE DATABASE dbname FROM DISK='D:\AAA.BAK' WITH REPLACE;

[--小F--]

只有看的份

[zhengzeng]

可以结帖了

[muyebo]

用了下一楼的,可以

[muyebo]

二楼的也可以

[vicent3]

declare @sql varchar(500);
set @sql='';
select @cmd=@cmd+'kill'+ RTRIM(spid) from master.dbo.sysprocesses
where dbid=(select spid from master..sysprocesses where dbid=db_id('DB_Test'))
exec(@cmd);
go
RESTORE DATABASE dbname FROM DISK='D:\AAA.BAK' WITH REPLACE;
go
ALTER DATABASE DB_Test set MULTI_USER;
go

[vicent3]

唉 怎么会出现单用户。。。我觉得在恢复的时候就要 改一下 多用户状态。