| Re: sql server 2005 database in restore mode |
|
 |
|
 |
|
 |
|
 |
Group: microsoft.public.sqlserver.setup · Group Profile
Author: Warren BrunkWarren Brunk Date: Feb 11, 2008 13:35
I am not sure the problem but since you are restoring from a backup, why not
delete the bad database and try re-restoring the database.
thanks,
--
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.TechIntSolutions.com
www.RealWorldSQL.com
*/
"Vikas Murarka" ankitindia.net> wrote in message
news:OhRFuzMbIHA.1188@TK2MSFTNGP04.phx.gbl...> Hi folks
>
> I was restoring a database in SQL Server 2005 express edition. Due to a
> malfunction, system restarted.
>
> Now when I try to access the database, the status shows as "Restoring
> Database". I have tried to restart SQL Server and PC, but there is no
> change. Other databases are fine.
>
> Can someone help me go back to my old database, before I started restore?
>
> Thanks in advance.
>
> regards
> Vikas Murarka
>
| 
