sql server 2005 database in restore mode

[Vikas Murarka]

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

[Hilary Cotter]

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?

[johnchri...@gmail.com]

SQL databases can be repaired by the use of .mdf fixer

http://www.mdffixer.sqlmdffix.com