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 |
|
tradu81
Starting Member
3 Posts |
 Posted - 2009-07-28 : 20:13:36
|
| Hi,I don't know much about SQL and was hoping someone couold give me a help in hand. Just recently we've been getting an event error ID 9002, source: MSSQLSERVER with description:The transaction log for database 'wslogdb63' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databasesThere is plenty of space on the drives to wrote to and so not quiet sure why the transaction log is full. Not sure if this matters but The initial size of the database Data file is set to 155 MB, Autogrowth set to 'By 1 MB, unrestricted growth'. The Log file has an initial size of 20 MB and Autogrowth set to 'None'. The backup Maintenance job is currently failing. I'm running SQL Server 2005I'm really not quiet sure how to excute sys.databases (Transact-SQL)commands. Any easy fix?Your help would be appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-29 : 00:30:09
|
| need to allow autogrow |
 |
|
|
|
|
|
Transaction log full Event 9002.