|
|
||||||
|
#1
03-05-07, 07:27 AM
|
|
|
|
|
Hi:
I am using a test SQL Server 2005 database and was finding queries were not completing. I stopped the queries so nothing was running, restarted SQL Server and now when I startup the database shows as "in recovery". It has been stuck there for a few hours. Any way of figuring out if it will finish or when it will finish? Thanks, Kayda |
|
|
|
#2
03-05-07, 04:29 PM
|
|
|
|
|
On Mar 5, 1:27 am, "Kayda" <blair> wrote:
> Hi: > > I am using a test SQL Server 2005 database and was finding queries > were not completing. I stopped the queries so nothing was running, > restarted SQL Server and now when I startup the database shows as "in > recovery". It has been stuck there for a few hours. Any way of > figuring out if it will finish or when it will finish? > > Thanks, > Kayda Sounds like a large transaction is being rolled back. Check the SQL Server error log, you will see status messages written there telling you how far along the recovery is. |
|
|
| Similar Threads | |
| stuck on recovery screen for hours running vitsa business 32 bit. amd athlon 64 , i gb ram (don't know mobo) straight to the point; computer is not booting to login screen. tried fixing via the installation... |
|
| GP 7.5 - Posting is stuck in batch recovery We are running GP 7.5 and had a batch that failed with a "unhandled database exception: a saved operation on table SOP_line_CMT_work_hist failed accessing SQL data" now the... |
|
| System Recovery is stuck I had to do a system recovery. It's stuck at "Installing Windows" with "34 minutes left" for the past hour. What should I do? Everything was going just fine until this... |
|
| STUCK!!How do I run the XP Recovery /Repair CD? I need to run a repair with my XP reinstall/repair CD on my Dell 4550 Desktop. I can get to a certain point and then I don't know what the heck I'm supposed to put in. I... |
|
| Virus recovery - I'm stuck I apparently got a virus on my machine which caused my Security Tab and Advance Tab to disable. When I wrote in before Alan Edwards was able to tell me how to go to Regedit... |
|
|
All times are GMT. The time now is 03:27 AM. | Privacy Policy
|
Database Stuck in Recovery