problem restore database SQL2005

Dear all,

I'm trying to restore a database saved last week in a .bak file through the
GUI of Management Studio but i have the following message error : "the
database is in use".

So i restarted the service engine SQL and changed the option to put Single
User but i have still the same error message when trying to restore.

Do you the procedure to restore a database with SQL2005 through the
Management Studio ?

Thanks in advance.

Check the ActivityLog to find out who is connected to database.
--
Thanks & Rate the Postings.
-Ravi-


"Ving" wrote:

> Dear all,
>
> I'm trying to restore a database saved last week in a .bak file through th
e
> GUI of Management Studio but i have the following message error : "the
> database is in use".
>
> So i restarted the service engine SQL and changed the option to put Single
> User but i have still the same error message when trying to restore.
>
> Do you the procedure to restore a database with SQL2005 through the
> Management Studio ?
>
> Thanks in advance.
>
>
>
>