>-----Original Message-----
>That means that an application or user(s) is connected to
the database that
>you are trying to restore onto. First you need to make
sure nobody is
>connected to the database, before you attempt a restore.
>
>You can forcefully set the database into single user mode
in SQL Server 2000
>using the new extensions of ALTER DATABASE command. You
could also use
>sp_dboption command. More information is available in SQL
Server Books
>Online. Also see
http://vyaskn.tripod.com/administration_faq.htm#q16 if you
>are on SQL Server 7.0
>
>You could use sp_who to see who is currently accessing
your database.
>
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>What hardware is your SQL Server running on?
>http://vyaskn.tripod.com/poll.htm
>
>
>
>
>"ja" <jainklr@yahoo.com> wrote in message
>news:1d3b01c37974$93801d80$a501280a@phx.gbl...
>error: exclusive access could not be obtained because the
>database is in use..
>
>this happens after we take a complete backup and do a
>whole new restore with undo log as read only.
>
>
>
>
>.