Hello IT GURU"SI am faceing the windows update issue on the client - since SCE2007 SP1 is not broadcasting the updates on the clients- when i checked the event log i am getting this message - so could you kindly assist me in resloveing this issueTehc InfoWin2002 SP2SQL 2005 9.00.4035.00Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 1105 Date: 3/28/2009 Time: 10:35:58 AM User: xty\admin Computer: ELM-SCE-01 Description: Could not allocate space for object 'dbo.PerformanceData_35'.'idxc_PerformanceData_35_TimeSampled' in database 'OperationsManager' 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. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 51 04 00 00 11 00 00 00 Q....... 0008: 0b 00 00 00 45 00 4c 00 ....E.L. 0010: 4d 00 2d 00 53 00 43 00 M.-.S.C. 0018: 45 00 2d 00 30 00 31 00 E.-.0.1. 0020: 00 00 12 00 00 00 4f 00 ......O. 0028: 70 00 65 00 72 00 61 00 p.e.r.a. 0030: 74 00 69 00 6f 00 6e 00 t.i.o.n. 0038: 73 00 4d 00 61 00 6e 00 s.M.a.n. 0040: 61 00 67 00 65 00 72 00 a.g.e.r. 0048: 00 00 ..Thanks

This message indicates your SQL database is out of space. You need to add some free space. In SQL Mgmt Studio, right click the database and increase the size of the data files. You want to maintain about 40% free space at all times in your OperationsManager and OperationsManagerDW databases.Pete Zerger, MVP-MOM | http://www.systemcenterforum.org

Thanks for your email - could you kindly send me the steps ...How can i perfom this action- since i am not good with SQL :_(..But i have seen by going to "OperationManager > Right click > Files > there i can see MOM_Data is 1332 Autogrowth (None)MOM_Log is 665Autogrowth (None)OperationManagerDW > Right click > Files > there i can see MOM_Data is 3139 Autogrowth (By 10 percent, unrestricedgrowth)MOM_Log is 733 Autogrowth (By 10 percent, restricted growth to 2097152MB)Please do let me know for further any query Thanks

Any resposne gusy -- please help me out !!!Thanks

But i have seen by going to "OperationManager > Right click > Files > there i can see MOM_Data is 1332 Autogrowth (None)MOM_Log is 665Autogrowth (None)OperationManagerDW > Right click > Files > there i can see MOM_Data is 3139 Autogrowth (By 10 percent, unrestricedgrowth)MOM_Log is 733 Autogrowth (By 10 percent, restricted growth to 2097152MB) I am running into a similar issue of the database size hitting a limit. I was getting ready to post and came across this question.http://social.technet.microsoft.com/Forums/en-US/systemcenter/thread/02fe13a8-cf50-45d2-a3f3-a1133090b9b7/As you stated above:I just increased the "1332" to a higher number. I'm assuming that is in MB, so I changed it to 5120 (5GB=1024x5) to see if that works. So far so good. I will post back if I hit this wall again.

Hi Pete. How big should the log be in relation to the data file? My log is 4 Gig and climbing. The data file is 4.5Gig so far and it is only 18mnths old. How big should I expect MOM to grow? I know - how long is a piece of string - but not being "informed" on MOM I believe it a legit question.