Good Morning Experts.
We have a SQL Server instance. All the user databases log files are on R drive. We have been getting alerts that R drive is 99% full, 100% full. I am interested to know what is consuming the R drive. Could you please advise. Any script to check what is consuming the R drive?
How big is the drive and is anything else using the drive? Also, how often are you taking log file backups? And, what are the initial size and growth settings set to? And finally, do you have any form of log shipping or replication running?
Nothing else is using the drive. It is dedicated to user databases log files. We take log file backups every 30 minutes. No log shipping or replication. This issue is happenning only from last 2 days. Is there a way to find out the spid/transaction that is eating up the drive