Hi Zubeyir
I appreciate your help. I ran the dbcc sqlperf (logspace) and have posted some of the results below ordered by log size. Nothing really strikes me as significant though. But notice the last entry in the table - I'm not sure what that is all about. I think that db was restored from backup.
DatabaseName | LogSizeMB | LogSpaceUsed% | Status |
AbacBill | 492.49219 | 26.741283 | 0 |
db4128 | 209.67969 | 5.3222456 | 0 |
quotes | 199.99219 | 5.6828394 | 0 |
db4688 | 106.74219 | 11.490888 | 0 |
db4167 | 106.17969 | 67.104149 | 0 |
db4739 | 95.742188 | 9.98878 | 0 |
db4283 | 80.429688 | 10.636838 | 0 |
db5060_bak | 73.117188 | 10.495245 | 0 |
db5060_bak1 | 70.179688 | 9.8595963 | 0 |
db4238 | 64.367188 | 10.542845 | 0 |
db4853 | 61.617188 | 11.554615 | 0 |
tempdb | 56.304688 | 54.613571 | 0 |
db4121 | 52.554688 | 11.766947 | 0 |
db4837 | 50.054688 | 13.764242 | 0 |
db5138 | 46.679688 | 15.445606 | 0 |
db5322 | 46.117188 | 13.065391 | 0 |
db4121_1 | 45.367188 | 12.592561 | 0 |
db5358 | 43.367188 | 15.230364 | 0 |
model | 0.4921875 | 83.531746 | 0 |
db5286_copy | 6.2500954E-2 | 1.1789507E+15 | 0 |
Cheers,
Tom.