Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Database in Use - Trying to Restore- SQL 6.5

Author  Topic 

adam3291
Starting Member

8 Posts

Posted - 2001-09-05 : 14:43:21
SQL 6.5 - I am trying to restore a test database through Enterprise Manager (GUI) but it's failing with an error "Database in use. The system administrator must have exclusive use of the database to run the load operation." I can't figure out who or what could be using this database. Anyone have any idea's on how to locate the user? I've tried to locate a SP on SWYNK called sp_kill_db_users, but have had no luck there either. Thanks in advance!!

   

- Advertisement -