Working on SQL Server 2014.
I have noticed that a log file (60GB) on a database has filled up within the past day. To my knowledge, I am the only developer using this database and I have not been performing any transactions on the database for over a week. I asked the DBA if anyone else is using the database and they did not think so. The DBA mentioned that the automated index rebuild jobs could be filling up the log.
My question is this, can automated index rebuild jobs that run hourly fill up the log file? My assumption here is that the index would not be fragmented and so there would not be any work to rebuild the index. Therefor, the log file should not fill up. Is this assumption false? Am I missing something with how SQL Server index rebuilds work and how that might impact the log file?
We are using Ola's solution: Click Here
EXECUTE [dbo].[DatabaseBackup] @Databases = 'USER_DATABASES', @Directory = N'\\DirectoryPath\', @MirrorDirectory = N'\\DirectoryPath\', @BackupType = 'LOG', @Verify = 'Y', @CleanupTime = 48, @MirrorCleanupTime=24, @CheckSum = 'Y', @LogToTable = 'Y', @Compress = 'Y'