Exclusive access to the database is not available because the database is in use

The database could not be restored and resolved:

When you restore database, you are sometimes prompted that you cannot gain exclusive access to the database because it is in use!!

You need to kill the thread that is using the database before restoring the database.

1. First locate the master database
2. Run the following statement

Kill the thread that is using the ' JCJQ ' database as follows:

DECLARE @dbname varchar (20)

Set @dbname = ' JCJQ '

declare @sql nvarchar (500)

Declare @spid the INT--SPID value is a unique integer assigned to the connection when the user makes the connection

Set @sql = ' Declare getspid cursor for

Select spid from sysprocesses where dbid=db_id ("' [email protected]+ ') '

EXEC (@sql)

Open Getspid

FETCH NEXT from Getspid to @spid

While @ @fetch_status <>-1--if the FETCH statement does not fail to execute or the row is not in the result set.

Begin

EXEC (' kill ' [email protected])--Terminate normal connection

FETCH NEXT from Getspid to @spid

End

Close Getspid

Deallocate getspid

Exclusive access to the database is not available because the database is in use