December 18, 2009 at 7:03 am
Hi
i see in the sql logs very often this kind of massages poping up
Just like below and not sure what they meant because server or Database not down for any given peroid of time
they up and running still i see this massages
Message
13 transactions rolled forward in database xxxx. This is an informational message only. No user action is required.
Message
1 transactions rolled back in database 'XXX. This is an informational message only. No user action is required.
-----------------------------------------------------
The Main error we find on app server
Connection to the Database is lost. Trying to reconnect to the Database
Please Wait ...
[ConnectionPool] : Entering into Refresh Database Connections.!
26 Connections disconnected from database in Connection pool
Could not reconnect to database. (Application) Server is being Shut Down
December 18, 2009 at 11:46 am
no i did not see that kind of issue.database ever had taken in single user mode or down for any time.
i do not see any other errors or warnings at all in sql logs or app or system logs.
December 18, 2009 at 12:59 pm
Check the properties of the database and see if the database is set to auto close. Also, check to see if it is set to auto shrink. If auto close is true - then the database is being closed when there are no connections, thus - you are going to see the recovery type messages when the database is opened.
If you have auto shrink enabled - disable it. It is just going to cause fragmentation and other problems that you don't want.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 19, 2009 at 2:01 am
Those messages show restart-recovery. They occur whenever a database is opened. If you're seeing them often in the logs it means that the db is set to auto_close or it's being taken offline/online often or that it's being restored from backup often.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply