Stay Connected
Posts tagged SMS
SMS 2003: Error 25100
Mar 16th
I am still managing a SMS 2003 environment and last week we encountered following message on one of the SMS 2003 clients. The message appeared in Application Eventviewer and SMS client did not report back to our SMS Primary site:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 3/10/2009
Time: 12:17:06 PM
User: NETWORKNET\Ivan
Computer: IVAN-VM01
Description:
Product: SMS Advanced Client — Error 25100. Setup was unable to create the WMI namespace CCM
The error code is 80041002
To fix the problem see my cmd script below which was used by the local IT contact:
@echo off
REM Ivan Versluis
REM Date: 2009/03/11
REM Description: FIX WMI Database for SMS Client
c:
cd %windir%\system32\wbem\
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
net stop winmgmt
rmdir /s /q repository
rmdir /s /q Logs
mkdir Logs
net start winmgmt
rundll32 wbemupgd, UpgradeRepository
rundll32 wbemupgd, CheckWMISetup
rundll32 wbemupgd, RepairWMISetup
pause
(No Ratings Yet)
Loading ...How to shrink the SMS_SITENAME database SMS 2003?
Jan 24th
The SMS 2003 infrastructure I am managing has one singe SMS database which became 4 GB. 1GB data and 3GB log. Today I planned the database maintenance and managed to shrink the files with 3GB. Open the Enterprise Manager or Microsoft SQL Server Management tools and make sure the database option is set to Auto Shrink = Auto (enhancement for the future).
Run the following sql script:
USE [SMS_123]
GO
DBCC SHRINKFILE (N‘SMS_123_log’, 0, TRUNCATEONLY)
GO
Another useful script can be found here which will create a stored procedure and show all table space sizes with rows and MB used.
exec sp_show_huge_tables
(No Ratings Yet) Loading ...
