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 |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2006-01-13 : 05:21:32
|
| I have a tran log that is always 1000MB, despite being backed up every 10 minutes, despite being shrunk, and with minimal db activity.Any obvious reasons?Drew |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-01-13 : 05:46:01
|
| What's more, the actual TRN files are no bigger than 83kb. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-13 : 10:21:46
|
| Any output from DBCC OPENTRAN?Run that from the database with the troublesome log.is there replication involved? Also, what does the output of DBCC SQLPERF (LOGSPACE) look like? If the percentage used is low, then you just have items at the end of the file. DBCC SHRINKFILE will only shrink back to the first piece of log data it sees. |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-01-13 : 12:43:43
|
quote:
Probably a "stuck" transaction at the end of the Log file.However, I would caution against shrinking it, see: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Database+Shrinking height="1" noshade id="quote"> Great thread. Weekend reading. Here's a kiss. x quote:
Any output from DBCC OPENTRAN?Run that from the database with the troublesome log.is there replication involved? Also, what does the output of DBCC SQLPERF (LOGSPACE) look like? If the percentage used is low, then you just have items at the end of the file. DBCC SHRINKFILE will only shrink back to the first piece of log data it sees.
No replication. SQLPerf brought back a Gig. Can't remember the percentage. I'll try that and Opentran when I go back to work on Monday. Thanks.Drew |
|
|
|
|
|
|
|
|
Transactional Log ALWAYS at 1 gb. Won't budge.