Automatic Alert for Full of Primary file group in Sql server.

  • hi guys,

    is there any ways to have a automatic alert when primary file group is full in Sql server for any of the database in Sql server 2005.

  • set up an alert in SQLAgent to monitor for 9002 errors

    ---------------------------------------------------------------------

  • will that for primary file group or t log file group or for all ?

  • thanks for the idea where i can get but this is what i need to monitor Error: 1105, Severity: 17

  • if you have DBMail and an operator setup, then it's simple since 1105 is a logged error:

    USE MSDB

    EXEC sp_add_alert @name = 'Error 1105: Filegroup Full', @message_id=1105, @Severity=0, @enabled=1, @delay_between_responses=900, @include_event_description_in=1

    EXEC sp_add_notification @alert_name = 'Error 1105: Filegroup Full', @operator_name='youroperatorname', @notification_method = 1

    you'll get an e-mail like this:

    DATE/TIME:3/12/2013 2:43:26 PM

    DESCRIPTION:Could not allocate space for object 'dbo.bogus' in database 'trying' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

  • already done that !!

  • so you have a sqlagent alert but its not working?

    ---------------------------------------------------------------------

  • every thing is working fine i created alert after i posted this and it is working fine....

  • ok, I see. Glad you sorted that.

    ---------------------------------------------------------------------

  • Thanks to your idea

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply