SQLTeam.com | Weblogs | Forums

Monitor pre configured maximum size limits on mdf ldf files


#1

Hello All,

I had to set maximum limit on the DATA and LDF files of all the database on UAT (not a good practice but let's not go there). How can I setup a SQL job which can monitor free space in both the files so I will be notified prior to filling the max limit on the files.

Thanks,
Amita


#2

I haven't implemented this approach myself, so all I can say is that, conceptually, it's the the type of a approach I'd at least start with and adapt as necessary.
Monitor SQL Server Transaction Log File Free Space