unable to access sql 2005 database - in middle of restore

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

Vikas, responded in .server.

For your future knowledge, when posting to several groups, it is better if
all groups are listed in the same address line. That way, one post will
cover all the groups and an answer will also cover all the same groups.
This prevents someone from answering one post when another identical post
has already been answered. Make sense?

RLF

"Vikas Murarka" wrote in message

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