isql -Usa -P -i sql.sql
Msg 3101, Level 16, State 1:
Server 'WQNT', Line 1:
Database in use. A user with System Administrator (SA) role must have exclusive
use of database to run load.
Database 'zsdb' is now online.
Server Message: Server Message: Number 3101, Severity 16
Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load
解决方法
有些用户正在使用该被恢复的数据库。使用下面的sql查询哪些会话在连接该数据库。
select spid,hostname,loggedindatetime,ipaddr from master.dbo.sysprocesses where db_name(dbid)='数据库名'
使用如下的sql杀掉连接那个数据库的用户连接：
select 'kill '+convert(varchar,spid) from master.dbo.sysprocesses where db_name(dbid)='数据库名'
笨办法
重启服务器,重新操作
Msg 3101, Level 16, State 1:
Server 'WQNT', Line 1:
Database in use. A user with System Administrator (SA) role must have exclusive
use of database to run load.
Database 'zsdb' is now online.
Server Message: Server Message: Number 3101, Severity 16
Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load
解决方法
有些用户正在使用该被恢复的数据库。使用下面的sql查询哪些会话在连接该数据库。
select spid,hostname,loggedindatetime,ipaddr from master.dbo.sysprocesses where db_name(dbid)='数据库名'
使用如下的sql杀掉连接那个数据库的用户连接：
select 'kill '+convert(varchar,spid) from master.dbo.sysprocesses where db_name(dbid)='数据库名'
笨办法
重启服务器,重新操作
19朵
2个
