November 12, 2009 at 6:30 am
I´ve a lot of development DB´s. Besides one of them it appears a message "(in recovery)". I can´t do anything with this DB.
¿why has this happened?¿how can i solve it ?
thanks in advance.
November 12, 2009 at 7:44 am
I'm guessing that SQL restarted. That indicates that SQL is still recovering the DB. Check the error log, what does it say about that DB?
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
November 12, 2009 at 7:47 am
This has happened because the database was restored with NORECOVERY, which allows you to restore further files, diff / trans log backups etc.
If you want to bring it online in its current state, run a
RESTORE DATABASE [db name] WITH RECOVERY
statement. Should solve your problem.
*** IGNORE*** I thought I read (Restoring) not (In Recovery). Apologies. 🙂
November 12, 2009 at 11:33 am
GilaMonster (11/12/2009)
I'm guessing that SQL restarted. That indicates that SQL is still recovering the DB. Check the error log, what does it say about that DB?
The error log is in to the sql agent ?? if it does i have a new problem...
sql server agent is disabled, i´ve used the configuration manager to reboot the service but it still appears disabled...
November 12, 2009 at 12:26 pm
igngua (11/12/2009)
The error log is in to the sql agent ??
No. The SQL server error log. SQL Agent has nothing to do with anything here.
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
November 12, 2009 at 12:31 pm
The error log is in to the sql agent ?? if it does i have a new problem...
sql server agent is disabled, i´ve used the configuration manager to reboot the service but it still appears disabled...
You have got the wrong one, SQL Error Log is available under Management Node in the Object Explorer, expand Management you find SQL Server Logs, Right Click on select View SQL Server Error Log.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 12, 2009 at 12:38 pm
Bru Medishetty (11/12/2009)
The error log is in to the sql agent ?? if it does i have a new problem...
sql server agent is disabled, i´ve used the configuration manager to reboot the service but it still appears disabled...
You have got the wrong one, SQL Error Log is available under Management Node in the Object Explorer, expand Management you find SQL Server Logs, Right Click on select View SQL Server Error Log.
ok... i will check them...thanks
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply