Hi, any thoughts on why our transaction log file on our server (sql 7) would show opening file x, starting up database x, then seconds later closing file x, then starting it all up again (and again and again)? Perhaps this is normal when we do a commit from ADO, just seemed a bit odd.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Intriguing log file messages
- Thread starter phildude
- Start date
tlbroadbent
MIS
Examine the "Auto Close" option on the database. It is most likely set ON. It should be off for production databases. SQL BOL has details about this option. Terry L. Broadbent - DBA
SQL Server Page:
If you want to get the best answer for your question read faq183-874.
SQL Server Page:
If you want to get the best answer for your question read faq183-874.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question