Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Automatic Alert for Full of Primary file group in Sql server. Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 7:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:01 AM
Points: 123, Visits: 462
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.
Post #1429825
Posted Tuesday, March 12, 2013 10:39 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:27 AM
Points: 5,895, Visits: 13,068
set up an alert in SQLAgent to monitor for 9002 errors

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

Post #1429958
Posted Tuesday, March 12, 2013 11:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:01 AM
Points: 123, Visits: 462
will that for primary file group or t log file group or for all ?
Post #1429997
Posted Tuesday, March 12, 2013 12:12 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:01 AM
Points: 123, Visits: 462
thanks for the idea where i can get but this is what i need to monitor Error: 1105, Severity: 17
Post #1430035
Posted Tuesday, March 12, 2013 12:48 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 10:19 AM
Points: 1,951, Visits: 2,123
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.
Post #1430058
Posted Tuesday, March 12, 2013 10:42 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:01 AM
Points: 123, Visits: 462
already done that !!
Post #1430205
Posted Wednesday, March 13, 2013 4:52 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:27 AM
Points: 5,895, Visits: 13,068
so you have a sqlagent alert but its not working?

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

Post #1430294
Posted Wednesday, March 13, 2013 5:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:01 AM
Points: 123, Visits: 462
every thing is working fine i created alert after i posted this and it is working fine....
Post #1430298
Posted Wednesday, March 13, 2013 5:06 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:27 AM
Points: 5,895, Visits: 13,068
ok, I see. Glad you sorted that.

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

Post #1430302
Posted Wednesday, March 13, 2013 5:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 20, 2014 8:01 AM
Points: 123, Visits: 462
Thanks to your idea
Post #1430303
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse