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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-04-30 : 04:55:20
|
| Dear Folks,I'm getting the error with application like this.............."the transaction log for database "mydatabase" is full.....to find out why space in the log can not be reused, see the log_reuse_wait_desc column in sys databases. "I've checked with the column, there are totally 3 options.(I've checked with all other databases)1)checkpoint,2)log_backup,3)nothingwhat can i choose for this error to be suppressed?actually there was log_backup option.please guide me in this regard.........thanks in advace.Vinod |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
log reuse help