I've got a bit of an odd one that I'm wondering if anyone's seen before.
See the SQL Server errorlog for details.
Gail Shaw Microsoft Certified Master: SQL Server, MVP, (Comp Sci) : Discussions on DB performance with occasional diversions into recoverability We walk in the dark places no net protector antivirus 2012 full version with crack others will enter We stand on the bridge and no one may pass jnieuwoudt SSC Journeyman Group: General.
What does your error logs say?Moreover, if I restart SQL Server, other databases start to have the same issue, meaning they become stuck in recovering mode too, while other database seem to have been recovered.Once the drives were available, a manual restart of SQL Server fixed the problem and the DB was automatically recovered.You can't delete other posts.You can't post topic replies.Database 'Database' cannot be opened due to inaccessible files or insufficient memory or disk space.Was there any sudden shut down of the SQL Server?One of our DBs was stuck in a "Recovery Pending" state following a sudden (and unusual) loss of power.Msg 5069, Level 16, State 1, Line.Has anyone seen this behaviour before, it happened on a random handful of databases at various points during the day?Usually this is because the log is missing or corrupt.You can't send emails.Recovery Pending means that recovery cannot be started.Now, even msdb is in recovering state.Thanks, Ioana GilaMonster SSC Guru Group: General Forum Members Points: 444106 Visits: 47235 Please post new questions in a new thread.SqlserverCentral Register Search Jump to page Jump to page.If so, try stopping and restarting the SQL service as it may be that SQL came up before the drive was available.(An onsite electrician was to blame.) Anyhow, it turns out that when the server booted back up, the various drives were a little slower to come online.
You can't post new polls.