Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2010-05-10 : 04:04:23
|
| Hi all,I have a important issuse. I have noted many instance where database (with SIMPLE RECOVERY MODE)running in SQL Express 2005 mode when i attach the same in SQL Standard 2005 then it goes in recoverery mode as soon as it attached and remain in that state infinitely.What could be the possible reasons for that?Thankx |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-10 : 04:20:27
|
| Query sys.databases. What's the exact value of the state_desc column for that database?Any messages in the SQL error log?--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Database in Recovery Mode