sql server 2005 database in restore mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vikas Murarka - 11 Feb 2008 16:38 GMT

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

Reply to this Message

Hilary Cotter - 12 Feb 2008 13:16 GMT

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?

> Hi folks
>
[quoted text clipped - 11 lines]
> regards
> Vikas Murarka

Reply to this Message