setup an alert for DB data file full

• yogi123

  SSCrazy

  Points: 2932

  More actions

  February 18, 2013 at 7:28 am

  #268674

  Hello

  I need to set an alert when Database data file will exceed 90% or less then 5GB in SQL Server 2005.

  so please help me to setup that.

  Thanks

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  February 18, 2013 at 7:29 am

  #1588849

  Yes a SQL Agent alert for that

  http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/