Can't change DB to single user

[RonPro]

I have a test server onto which I need to restore a backup from a production database. The backup is made, but I can't get the test server to set the single-user option on my test db. It keeps telling me that other users are attached.

There are no apps running against the test server dbs. I have bounced the test server and my workstation to make sure there are no links.

"Current Activity" shows no one using the database I want to restore over.

Any ideas as to where this phantom db user is lurking?

TIA
Ron

 

[JayKusch]

How are you restoring this DB. Via Query Analyzer or Enterprise Manager?

Thanks

J. Kusch

 

[RonPro]

EM

 

[mrdenny]

check the sysprocesses table. If may show someone. If may think that your EM is trying to use the database, and that's kicking you out. Try running the restore from Query Analyzer.

Denny

 

[stefanlennerbrant]

Did you try

alter database YOUR_DB_NAME set single_user
with rollback immediate;

in Query Analyzer?

/Stefan Lennerbrant