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

Question

Post reply

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

Ivan Mohapatra

SSCarpal Tunnel

Points: 4452
More actions
March 12, 2013 at 7:58 am

#271384

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.

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

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

george sibbald SSC Guru Points: 104210 More actions · Answer 1

set up an alert in SQLAgent to monitor for 9002 errors

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

Ivan Mohapatra SSCarpal Tunnel Points: 4452 More actions · Answer 2

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

Ivan Mohapatra SSCarpal Tunnel Points: 4452 More actions · Answer 3

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

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 4

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.