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...

104484127F827733-0BBD-E011-A284-0026551193F880827733-0BBD-E011-A284-0026551193F8104236SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E003100320037003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E00430041004A0041003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0037003500390032003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E00530041005000200042007500730069006E0065007300730020004F006E0065003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E00310038003000320033003900380036003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300039003A00330036003A00350036002E003400330033003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0031003000310039003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E00310036003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300031003600330039003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

104491747F827733-0BBD-E011-A284-0026551193F880827733-0BBD-E011-A284-0026551193F8104237SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003500310037003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E003100330035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0038003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E00430041004A0041003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0037003500390032003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E00530041005000200042007500730069006E0065007300730020004F006E0065003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E00310037003900380039003900340030003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300039003A00330037003A00330030002E003400380030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E003300360038003500300039003C002F00520065006100640073003E003C005700720069007400650073003E00310036003C002F005700720069007400650073003E003C004300500055003E0035003200360034003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300031003600340033003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

104491757F827733-0BBD-E011-A284-0026551193F880827733-0BBD-E011-A284-0026551193F8104238SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003000350030003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0035003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065003E00410064006D0069006E006900730074007200610064006F0072003C002F004E00540055007300650072004E0061006D0065003E003C004E00540044006F006D00610069006E004E0061006D0065003E004C0049004400450052003C002F004E00540044006F006D00610069006E004E0061006D0065003E003C0048006F00730074004E0061006D0065003E005300450052005600450052003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0032003000320034003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E005200650070006F007200740020005300650072007600650072003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E004C0049004400450052005C00410064006D0069006E006900730074007200610064006F0072003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E003200320031003600320036003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330034003A00340039002E003400320030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003000340037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E00350036003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051005500410041004100410041004100410055005600410041004100410079004B004700740064005A00440064006200370065004C0042004200470042003900410045004100410041003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003400380030003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E004C0049004400450052005C00410064006D0069006E006900730074007200610064006F0072003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

104491817F827733-0BBD-E011-A284-0026551193F880827733-0BBD-E011-A284-0026551193F8104239SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330032002E003000300033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003900300037003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003900300037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003400390039003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

104491827F827733-0BBD-E011-A284-0026551193F880827733-0BBD-E011-A284-0026551193F8104240SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330035002E003000330033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330034002E003900300037003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330034002E003900300037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003500320038003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

103308037D827733-0BBD-E011-A284-0026551193F87E827733-0BBD-E011-A284-0026551193F885316SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003900340033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600360030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600360030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600370036003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

103308047D827733-0BBD-E011-A284-0026551193F87E827733-0BBD-E011-A284-0026551193F885317SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003400310030003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E003100350036003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003200350033003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003400310030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600390035003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

103308057D827733-0BBD-E011-A284-0026551193F87E827733-0BBD-E011-A284-0026551193F885318SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003600390033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003600360030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003600360030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003700300033003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

103307977D827733-0BBD-E011-A284-0026551193F87E827733-0BBD-E011-A284-0026551193F885314SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003200340030003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E003100370033003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003000350030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003200320033003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600350038003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

103308027D827733-0BBD-E011-A284-0026551193F87E827733-0BBD-E011-A284-0026551193F885315SQL/Notifications/ProcessWMIEventProviderNotification/v1.065569http://schemas.microsoft.com/SQL/Notifications/PostEventNotification2http://schemas.microsoft.com/SQL/Notifications/EventNotification4X0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003700350037003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600330030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600330030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600360035003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00

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:

WMIEventProviderNotificationQueue1165247206NULL10SQSERVICE_QUEUE2011-08-02 08:27:43.2172011-08-02 08:27:43.2170000NULLNULL0110

and....

5BD74543-8571-E011-B2EC-0026551193F862453D36-5518-4B59-9AEE-C7C56D65C098125CD74543-8571-E011-B2EC-0026551193F822079-05-16 14:04:12.060SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-01-01 00:00:00.0001900-01-01 00:00:00.00000x000000000000-1000-1001

81A3FA0D-8671-E011-B2EC-0026551193F89FC84446-2AC1-4288-A1DF-807D329F51D11282A3FA0D-8671-E011-B2EC-0026551193F822079-05-16 14:09:47.580SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-01-01 00:00:00.0001900-01-01 00:00:00.00000x000000000000-1000-1001

7057CDE2-8571-E011-B2EC-0026551193F8AFCFC9A5-9B00-4C41-8E18-8078926A4480127157CDE2-8571-E011-B2EC-0026551193F822079-05-16 14:08:36.407SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-01-01 00:00:00.0001900-01-01 00:00:00.00000x000000000000-1000-1001

E442B2DC-4DD0-E011-A494-0026551193F88A1263FE-73B6-415C-9B45-8070A230587012E542B2DC-4DD0-E011-A494-0026551193F822079-09-14 04:57:00.483SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-01-01 00:00:00.0001900-01-01 00:00:00.00000x000000000000-1000-1001

D2608686-8571-E011-B2EC-0026551193F87D65C055-63F1-434B-A6CA-806A9D2665C812D3608686-8571-E011-B2EC-0026551193F822079-05-16 14:06:07.653SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-01-01 00:00:00.0001900-01-01 00:00:00.00000x000000000000-1000-1001

A4A4FA0D-8671-E011-B2EC-0026551193F8B7363F52-BB2F-42CA-BCFB-8062380CC39312A5A4FA0D-8671-E011-B2EC-0026551193F822079-05-16 14:09:55.033SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-01-01 00:00:00.0001900-01-01 00:00:00.00000x000000000000-1000-1001

61542CAB-8571-E011-B2EC-0026551193F816939A84-0EE5-42F1-A6BD-800455C5741A1262542CAB-8571-E011-B2EC-0026551193F822079-05-16 14:07:10.343SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-01-01 00:00:00.0001900-01-01 00:00:00.00000x000000000000-1000-1001

9942B2DC-4DD0-E011-A494-0026551193F87F424051-77AA-430C-8085-7FF50A2D4E21129A42B2DC-4DD0-E011-A494-0026551193F822079-09-14 04:56:58.700SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-01-01 00:00:00.0001900-01-01 00:00:00.00000x000000000000-1000-1001

D730FB5D-8671-E011-B2EC-0026551193F80CF38EEF-04CE-41C5-AB48-C7CAB9D9FBC112D830FB5D-8671-E011-B2EC-0026551193F822079-05-16 14:12:09.007SOSTARTED_OUTBOUNDSQL/Notifications/ProcessWMIEventProviderNotification/v1.074E66820-0D0F-49E4-9161-F151DC2F22424-100000000-0000-0000-0000-00000000000000000000-0000-0000-0000-0000000000001900-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:

sysjobhistory360 2776 KB888 KB128 KB1760 KB

backupset26 592 KB56 KB232...

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 should do...