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 |
|
wisertime
Starting Member
28 Posts |
 Posted - 2008-04-07 : 10:40:35
|
| I am geting growth alerts and need to shrink a log file that is 99% full, but it won't let me. Here is the message I get.The transaction log for database 'SOM_System' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databasesWhat can I do in order to shrink this log file??Thanks |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-07 : 11:00:51
|
| Take a log backup: Backup log SOM_Systems to "pathname\filename.bak". This will free the used transactions from the log.Terry |
 |
|
|
wisertime
Starting Member
28 Posts |
Posted - 2008-04-07 : 11:09:33
|
| thanks, i forgot to check the drive space. it was too full for a backup |
|
|
|
|
|
|
Log File Can't Shrink