February 17, 2010 at 10:59 am
The transaction log for database 'database' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Plz tell me what cause it will come
February 17, 2010 at 12:10 pm
Well, the output from sys.databases tells you why the log can't clear. For instance, if it says LOG_BACKUP it means you've got to take a log backup before the log will clear.
Here are some blog posts to help you:
- Search Engine Q&A #23: My transaction log is full - now what?
- Importance of proper transaction log size management
- TechNet Magazine: feature article on understanding logging and recovery
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply