Thank you for helping ALZDBA.

The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t know...

Finally I got some one here.

On the other hand I noticed this while looking at the msdbdata.mdf and its log on the windows explorer..the log files was growing at 3...

Hi!

Still no expert here! And to make things worse the server collapsed! We have no system. I am installing a new SQL server to see if the SAP is cosign...

One last question, what do you think of doing this:

http://sqlplanet.blogspot.com/2008/07/recreate-corrupt-msdb-database.html

Regards,

Juan

Yes! We are very much grateful for that! Already talked to someone and he is checking this forum thread to see if he can help us out or get us...

And also...

17226605

forgot the query...

1 0 448412 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104236 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E003100320037003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E00430041004A0041003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0037003500390032003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E00530041005000200042007500730069006E0065007300730020004F006E0065003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E00310038003000320033003900380036003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300039003A00330036003A00350036002E003400330033003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0031003000310039003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E00310036003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300031003600330039003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

1 0 449174 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104237 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003500310037003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E003100330035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0038003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E00430041004A0041003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0037003500390032003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E00530041005000200042007500730069006E0065007300730020004F006E0065003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E00310037003900380039003900340030003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300039003A00330037003A00330030002E003400380030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E003300360038003500300039003C002F00520065006100640073003E003C005700720069007400650073003E00310036003C002F005700720069007400650073003E003C004300500055003E0035003200360034003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300031003600340033003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

1 0 449175 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104238 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003000350030003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0035003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065003E00410064006D0069006E006900730074007200610064006F0072003C002F004E00540055007300650072004E0061006D0065003E003C004E00540044006F006D00610069006E004E0061006D0065003E004C0049004400450052003C002F004E00540044006F006D00610069006E004E0061006D0065003E003C0048006F00730074004E0061006D0065003E005300450052005600450052003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0032003000320034003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E005200650070006F007200740020005300650072007600650072003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E004C0049004400450052005C00410064006D0069006E006900730074007200610064006F0072003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E003200320031003600320036003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330034003A00340039002E003400320030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003000340037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E00350036003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051005500410041004100410041004100410055005600410041004100410079004B004700740064005A00440064006200370065004C0042004200470042003900410045004100410041003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003400380030003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E004C0049004400450052005C00410064006D0069006E006900730074007200610064006F0072003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

1 0 449181 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104239 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330032002E003000300033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003900300037003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003900300037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003400390039003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

1 0 449182 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104240 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330035002E003000330033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330034002E003900300037003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330034002E003900300037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003500320038003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

1 0 330803 7D827733-0BBD-E011-A284-0026551193F8 7E827733-0BBD-E011-A284-0026551193F8 85316 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003900340033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600360030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600360030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600370036003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

1 0 330804 7D827733-0BBD-E011-A284-0026551193F8 7E827733-0BBD-E011-A284-0026551193F8 85317 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2

Here is the query, but to tell the truth I completely lost ... and we are trying to get someone to came to the office and help us...:doze:

Thanks for pointing...

Here they are:

WMIEventProviderNotificationQueue 1165247206 NULL 1 0 SQ SERVICE_QUEUE 2011-08-02 08:27:43.217 2011-08-02 08:27:43.217 0 0 0 0 NULL NULL 0 1 1 0

and....

5BD74543-8571-E011-B2EC-0026551193F8 62453D36-5518-4B59-9AEE-C7C56D65C098 1 2 5CD74543-8571-E011-B2EC-0026551193F8 2 2079-05-16 14:04:12.060 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 0 0x000000000000 -1 0 0 0 -1 0 0 1

81A3FA0D-8671-E011-B2EC-0026551193F8 9FC84446-2AC1-4288-A1DF-807D329F51D1 1 2 82A3FA0D-8671-E011-B2EC-0026551193F8 2 2079-05-16 14:09:47.580 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 0 0x000000000000 -1 0 0 0 -1 0 0 1

7057CDE2-8571-E011-B2EC-0026551193F8 AFCFC9A5-9B00-4C41-8E18-8078926A4480 1 2 7157CDE2-8571-E011-B2EC-0026551193F8 2 2079-05-16 14:08:36.407 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 0 0x000000000000 -1 0 0 0 -1 0 0 1

E442B2DC-4DD0-E011-A494-0026551193F8 8A1263FE-73B6-415C-9B45-8070A2305870 1 2 E542B2DC-4DD0-E011-A494-0026551193F8 2 2079-09-14 04:57:00.483 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 0 0x000000000000 -1 0 0 0 -1 0 0 1

D2608686-8571-E011-B2EC-0026551193F8 7D65C055-63F1-434B-A6CA-806A9D2665C8 1 2 D3608686-8571-E011-B2EC-0026551193F8 2 2079-05-16 14:06:07.653 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 0 0x000000000000 -1 0 0 0 -1 0 0 1

A4A4FA0D-8671-E011-B2EC-0026551193F8 B7363F52-BB2F-42CA-BCFB-8062380CC393 1 2 A5A4FA0D-8671-E011-B2EC-0026551193F8 2 2079-05-16 14:09:55.033 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 0 0x000000000000 -1 0 0 0 -1 0 0 1

61542CAB-8571-E011-B2EC-0026551193F8 16939A84-0EE5-42F1-A6BD-800455C5741A 1 2 62542CAB-8571-E011-B2EC-0026551193F8 2 2079-05-16 14:07:10.343 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 0 0x000000000000 -1 0 0 0 -1 0 0 1

9942B2DC-4DD0-E011-A494-0026551193F8 7F424051-77AA-430C-8085-7FF50A2D4E21 1 2 9A42B2DC-4DD0-E011-A494-0026551193F8 2 2079-09-14 04:56:58.700 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 0 0x000000000000 -1 0 0 0 -1 0 0 1

D730FB5D-8671-E011-B2EC-0026551193F8 0CF38EEF-04CE-41C5-AB48-C7CAB9D9FBC1 1 2 D830FB5D-8671-E011-B2EC-0026551193F8 2 2079-05-16 14:12:09.007 SO STARTED_OUTBOUND SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 74E66820-0D0F-49E4-9161-F151DC2F2242 4 -1 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 1900-01-01...

Hello,

One thing that I been trying to state is that the queue log is 36 GB and we have no idea how it became like that (we are guessing the...

query result 5756

And about the service broker, I have no idea. I will read about that and try to give you and answer.

I do want to let you know that...

The query showed nothing...

may be this one:

sysjobhistory 360 2776 KB 888 KB 128 KB 1760 KB

backupset 26 592 KB 56 KB 232...

Thanks for your answer... while the process is running I want to let you know that we are freeing about 10 GB when we run:

DBCC UPDATEUSAGE(0)

And

dbcc shrinkfile (1,100)

;

dbcc shrinkfile (2,100)

;

but...

We run the process overnight but it just reduce 500 MB and did not finish...but the MSDB grew to 50 GB again!

Please any comments are welcome!!

Juan

I think this will help reduce the queue, but I am not sure if we can run it on the production server...

http://gallery.technet.microsoft.com/scriptcenter/1d62b11b-82a2-46d0-b351-77eccbca1582

can anyone tell us if we...