Home > Archive > MS SQL Server > February 2006 > problem restore database SQL2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author problem restore database SQL2005
Ving

2006-02-28, 8:23 pm

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.



Ravi

2006-02-28, 8:24 pm

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 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.
>
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com