read the follow up to the forum post - setting recovery mode to simple should only be done if you understand the difference between the "simple" and "full".
Wednesday, November 22, 2006 2:57:00 PM
Anonymous said...
The same applies to "Auto Shrink" and "Auto Close". i.e. only change if you understanding the implications. Setting "Auto Close" on free's up resources when the DB's are not being used but the SQL Logs will repeatedly show "Starting up Database..." These options have performance implications.
Monday, February 18, 2008 5:18:00 AM
Anonymous said...
The same applies to "Auto Shrink" and "Auto Close". i.e. only change if you understanding the implications. Setting "Auto Close" on free's up resources when the DB's are not being used but the SQL Logs will repeatedly show "Starting up Database..." These options have performance implications.
Monday, February 18, 2008 5:20:00 AM
ravindra said...
I AM HAVING PROBLEM FROM YESTERDAY CAN'T LOGIN IN SCHOLARSHIP PORTAL AS A CANDIDATE IT SAYS THAT NO SPACE ON DISK HOW CAN I LOGIN?
Sunday, September 29, 2013 11:28:00 PM
Having these words in your SQL Server error in SQL Server 2005 seems a little unbearable.
The transaction log for database '%.*ls' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
[Image]
There are various reason to get the error. Transaction log expansion may occur because of the following reasons or scenarios: The linked MS Technet article does not help but confuses you.
• Uncommitted Transactions
• Extremely Large Transactions
• Operations: DBCC DBREINDEX and CREATE INDEX
• While Restoring from Transaction Log Backups
• Client Applications Do Not Process All Results
• Queries Time Out Before a Transaction Log Completes the Expansion and You Receive False 'Log Full' Error Messages
• Unreplicated Transactions
Check this FORUM POST out, excellent suggestion, set transaction recovery mode to "Simple". Try that once through database properties panel, it does not work for first time. few times it definitley works. Try changing the "Auto Shrink" and "Auto Close" properties to "True"
posted by Vishal Khapre at 9:29 PM on Aug 23, 2006
"log_reuse_wait_desc column in sys.databases"
4 Comments -
read the follow up to the forum post - setting recovery mode to simple should only be done if you understand the difference between the "simple" and "full".
Wednesday, November 22, 2006 2:57:00 PM
The same applies to "Auto Shrink" and "Auto Close". i.e. only change if you understanding the implications. Setting "Auto Close" on free's up resources when the DB's are not being used but the SQL Logs will repeatedly show "Starting up Database..."
These options have performance implications.
Monday, February 18, 2008 5:18:00 AM
The same applies to "Auto Shrink" and "Auto Close". i.e. only change if you understanding the implications. Setting "Auto Close" on free's up resources when the DB's are not being used but the SQL Logs will repeatedly show "Starting up Database..."
These options have performance implications.
Monday, February 18, 2008 5:20:00 AM
I AM HAVING PROBLEM FROM YESTERDAY CAN'T LOGIN IN SCHOLARSHIP PORTAL AS A CANDIDATE IT SAYS THAT NO SPACE ON DISK HOW CAN I LOGIN?
Sunday, September 29, 2013 11:28:00 PM