Setup Mirror failing with 'lock could not be placed on dat..

Hi, I have a rather large 500GB sql 2005 database I'm trying to mirror, I
have everything inplace ready to go but I keep getting the below error, I
have closed all connections, I have ran the commands to kill all connections
and to set it to single user mode but I still get the same error, I went
through the same process with a much small DB on the same servers without
issue, can anyone advise if there is anything else I can try, taking a DB
like this offline etc is an hour of and an hour on so I can't play with that
to much, I'm confused, in the activlity monitor there are nho connections to
this DB only the master and temp!

Any help is appreciated.

TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'mydb'. (Microsoft.SqlServer.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9....3042.0

------------------------------

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

ALTER DATABASE failed because a lock could not be placed on database 'mydb'.
Try again later. (Microsoft SQL Server, Error: 5061)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=0...0.3054&

------------------------------
BUTTONS:

OK
------------------------------

Did you try this

alter database databaseset set recovery full with rollback immediate

"Mike D" wrote in message

> Hi, I have a rather large 500GB sql 2005 database I'm trying to mirror, I
> have everything inplace ready to go but I keep getting the below error, I
> have closed all connections, I have ran the commands to kill all
> connections
> and to set it to single user mode but I still get the same error, I went
> through the same process with a much small DB on the same servers without
> issue, can anyone advise if there is anything else I can try, taking a DB
> like this offline etc is an hour of and an hour on so I can't play with
> that
> to much, I'm confused, in the activlity monitor there are nho connections
> to
> this DB only the master and temp!
>
> Any help is appreciated.
>
> TITLE: Database Properties
> ------------------------------
>
> An error occurred while starting mirroring.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Alter failed for Database 'mydb'. (Microsoft.SqlServer.Smo)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9....3042.0
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> ALTER DATABASE failed because a lock could not be placed on database
> 'mydb'.
> Try again later. (Microsoft SQL Server, Error: 5061)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=0...0.3054&
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>