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 |
|
korey
Starting Member
2 Posts |
 Posted - 2011-05-17 : 19:34:28
|
| Hello All,I have a question about SQL server express. I have a Hyper-V virtual machine running Server 2008 Standard 64-bit and SQL Server Express 2008.This is a web server that gets majority of its use during the week. It seems like on the weekend, when the server is idle, it will start a recovery on two databases. I found the recovery log entries in the Log File Viewer in SMS. These databases are queried by two other database servers and when the recovery happens, the connections from the remote SQL servers fail.These recoveries are intermittent and there is nothing in the server event logs about stopped services, unexpected shutdowns, etc...Our last web server did the same, giving us the same connection issues. Is there something I should be checking? Sorry for the nubness, heh.I appreciate any help! Thanks!!!- Korey |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
korey
Starting Member
2 Posts |
Posted - 2011-05-17 : 19:45:28
|
| It is enabled, ma'am. I have disabled it now and will let you know if the problem persists. Thank you so much! And extra thanks for the quick response. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-05-17 : 21:47:23
|
| You should also check for auto-shrink and disable it. This is also one of those defaults for Express databases that cause a lot of problems.Jeff |
|
|
|
|
|
|
SQL Server Idle / Database Recovery