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 |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-02-19 : 12:56:35
|
| Transactions log disk is full and the database is stalled. How can I eliminate this problem without the loss of work by users?Could anybody provide me the steps to do this using Management Studio?Thanks!!!! |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-19 : 13:12:23
|
| Backup the Transaction Log regularly (every 15 minutes is a reasonable interval)Change the Transaction Log to "Autogrow" - if it is currently a fixed size |
 |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-19 : 14:23:53
|
| And create an alert that will back up the transaction logs to a newtwork share when they get say 75-80% full. Stops ANY any database crashes becuase of TLogs getting full |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-19 : 14:35:43
|
| I like that idea - presumably that would launch a TLog backup during Index Rebuild housekeeping (which IME is the most hefty users of TLog space) just-in-time before the TLog was extended? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-02-19 : 18:04:26
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
transactions log disk is full and DB is stalled