October 25, 2006 at 2:45 am
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 UsedFree
TLog Space 4976.43MB 31.83MB 4944.6MB
My 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?
October 30, 2006 at 8:00 am
This was removed by the editor as SPAM
October 30, 2006 at 11:20 am
1. The minimum size of your TLog will be set based on the Model database (that db is the template used to build all other databases). Check the log file in that db. Then right click on your database, select properties and see what size the log file is set for.
2. I don't think there's anyway to do what you want. You might be able copy and rewrite sp_spaceused to return just the size of the log file and run the backup job based on that.
-SQLBill
October 30, 2006 at 2:27 pm
Not sure if there is a minimum size of a log backup. The smallest I see in general is 33Kb on my server.
With regards to checking the tlog, i guess, you could use something like lumigent log explorer. This also writes to its own database and you could check for transactions?
Without spending any money. You could run a dbcc sqlperf(logspace) and see if the percentage used has increased (with the log file size remaining the same).
October 30, 2006 at 11:07 pm
November 1, 2006 at 2:50 pm
The default size of ldf file is either that of model or a quarter of mdf file size, whichever is larger.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply