May 20, 2014 at 3:11 am
Hi
Please help with this, We have a SQL Server 2005 cluster. Database has been In Recovery for more than 12 hours sicne server was failed over. . The errors we can see is 1450 errors. This started after DBCC CheckDB created a SQL Dump. Could you please let me know what is our best option, we have a backup form 4 days ago. Thank you very much in advance.
result of select * from sys.databases = Recovering
Thanks.
Where there is a will... There is a way!
May 20, 2014 at 3:14 am
Wait.
Recovering means that SQL is running restart-recovery on the database. When it finishes the DB will come online.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2014 at 6:26 am
Check if any disk SAN issue.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2014 at 6:59 am
Hi, Thanks for your reply, but the database has been in recovery for too long, usually takes less than a minut, we think it is very unlikely for it to come online. Operating system error 1450 keeps coming up. Disks have been checked, all the databases have come online except this one. the size of db is around 500GB, and SQL Server memory is 32 Gb. Do you think if it is the size of database? lack of memory? ...Thanks
Where there is a will... There is a way!
May 20, 2014 at 7:02 am
If the database state is RECOVERING, then it is running the recovery process and will come online at the end of that. Probably there's a large transaction that needs to be rolled back, or lots of committed transactions whose changes hadn't been written to the data file.
For those of us who don't memorise operating system errors, what is error 1450?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2014 at 7:16 am
Hi
error 1450:
Insufficient system resources exist to complete the requested service.
Where there is a will... There is a way!
May 21, 2014 at 8:14 am
Hi
Database has been in recovery for more than 24 hours and we are 99.99% sure it will never come out of recovery. It keeps throwing 1450 errors every two minutes. Is there any way to say where these errors come from? Thank you in advance.
Where there is a will... There is a way!
May 22, 2014 at 1:59 am
So Database has not come back online. In recovery still... Any suggestions please? Thanks.
Where there is a will... There is a way!
May 22, 2014 at 2:20 am
Wait, or drop it and restore from your last backups.
Or maybe call MS support and get someone on site if your agreements with them allow. Will cost. They might be able to track down whatever is causing the low resource warning. I assume you've already checked memory, IO, all the usual suspects.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2014 at 9:10 am
Hi
We rebuilt fulltext index on another database and we saw database starting to recover and after 15 minutes it finished, the last error before the recovery started was transaction spid 20 was deadlocked on lock resources with another process and has been chosen as victim.
Very good news for us! Now the 1450 errors are still coming up, it looks like we need to apply SP4, looks like MDF can not expand, although there is 90 GB free space on the disk. Apparently it is a bug! I will provide more info later. but thank you for reading and replying to my questions. 🙂
You are a star Gail 🙂
Where there is a will... There is a way!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply