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 |
|
maranbe
Starting Member
28 Posts |
 Posted - 2006-10-25 : 04:50:30
|
| Hi Folks,Yesterday was a holiday and there were no transactions entered in our db. I noticed that each of the 47 tlog backup files created has 391 kb file size.Current space allocation: Total Used FreeTLog Space 4976.43MB 31.83MB 4944.6MBMy questions are:1. Is this the typical minimum file size of tlogs backup?2. Is there a way I can check the contents of a tlog file so I would know if changes have been made only then that I can start off my tlog backup?Kindest regard,SQL Server 2K (Clustered)/2K5_________________________Our life is frittered away by detail ... Simplify, simplify. |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-25 : 05:31:22
|
| Timings for backing up of your transaction log should be driven by business need, rather than the space the log takes up. If you back up every 5 minutes for a day, you will still be consuming the same amount of disk space (give or take some small overhead) than if you back up the same day's log file activity every 6 hours. -------Moo. :) |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-10-25 : 11:36:57
|
| Why do you ask? is there a space issue? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-28 : 03:15:09
|
| Our "dormant" transaction log backups vary from 14K to over a MB. Dunno why that is .... but I would hazard a guess that its related to the size of the DB, or its Log files. Might be some un-checkpointed stuff in there too I suppose that is getting pushed out every time ...Kristen |
|
|
|
maranbe
Starting Member
28 Posts |
Posted - 2006-10-28 : 03:28:16
|
| Space is not an issue. I just want to know if there's a way i can trigger tlog backup only when there are updates in my db that's all...this is for information purposes only. thanks.Kindest regard,SQL Server 2K (Clustered)/2K5_________________________Our life is frittered away by detail ... Simplify, simplify. |
|
|
|
maranbe
Starting Member
28 Posts |
Posted - 2006-10-28 : 03:37:04
|
quote:
Originally posted by Kristen
Our "dormant" transaction log backups vary from 14K to over a MB. Dunno why that is .... but I would hazard a guess that its related to the size of the DB, or its Log files. Might be some un-checkpointed stuff in there too I suppose that is getting pushed out every time ...Kristen
Thanks Kristen for sharing your experience. I'm just beginning to slowly understand the mechanics of the backup in SQL since we are just started implementing tlogs because it's now being required by the business .Kindest regard,SQL Server 2K (Clustered)/2K5_________________________Our life is frittered away by detail ... Simplify, simplify. |
|
|
|
|
|
|
|
|
Minimum tlog file size