December 24, 2007 at 3:04 am
Hi all,
After restarting my Sql server 2005, the user databases were in recovery mode and still in this recovery mode (after 4 hour)...
and the log file is nearly 166 Gb....
please give us some solution
Thanks in Advance
December 24, 2007 at 3:36 am
Check if there are suffiecient hard disk space avaialable for the database to recover and also to start.
Yes, also check the sql server error log for clear error message. If possible post the error message.
If the space is the issue then add more space to the disk, then try to restore these databases.
"More Green More Oxygen !! Plant a tree today"
December 24, 2007 at 10:01 am
The error log will display percentage of recovery if it's moving slowly. It is possible you have some redo or undo action that eats up log space. What was happening before the server was stopped? Was it stopped hard?
December 24, 2007 at 12:21 pm
Errlog is not showing anything regarding the recovery.. Even i tried to restore the database from backup, but its not possible while in the recovery mode.
Is there any option to stop the instance recovery
December 25, 2007 at 11:15 pm
I dont think so if there is any comand to stop the recovery of the database. Even if you restart the SQL Instances the recovery process will start again for all the databases.
1. What is the percentage of recovery displayed in the error log ?
2. If there is no hard disk space issue then please check the event
log may be hardware or I/O related issue. May be the databases
are not shut down safe
3. You may not have the sufficient virtual memory to startup the
databases
Please read these KB for more
info :http://support.microsoft.com/kb/316749/en-us
4. Any maintenance related job is running at the instance / Database
start up time ?
Please confirm and post it.
"More Green More Oxygen !! Plant a tree today"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply