April 18, 2009 at 12:15 pm
Hi,
I scheduled a log backup job for every 15 min in my test environment and every 15 mins the job is running fine and the log is backing up. But there is NO change to the database,i.e no transactions happening, then also every 15 min log is backing up and the log size is 30KB
My question is, If there is no updates, no transactions happen to the database then also log is backing up every 15 mins with size 30KB. What is backing up actually,even though there is no changes occurred to the database?
T-log backup - backups the changes occurred after the full backup
April 18, 2009 at 2:17 pm
If you have scheduled a backup to take place every 15 minutes, then SQL Server will create a new TRN file every 15 minutes; the size of that file merely reflects the number of logged activities that took place since the last backup. 30K is a pretty small file, basically about what I would expect when no transactions have taken place.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply