sql server 2005 database in restore mode

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

It looks like this database is stuck in a restoring mode. I would
issue sp_who2 and identify the restore process. Then once you have its
spid do something like this

select *from sys.sysprocesses wehre spid=@MySpid

where @myspid is a variable holding the spid which corresponds to the
restore operation and watch to see if cpu and io change. If not, this
could be hung, if so you will have to wait for the restore operation
to complete. How large is the database?


On Feb 11, 11:38 am, "Vikas Murarka" wrote:
> 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