VBScripts BLOG

Marcus Nasarek has written an article for Linux-magazine about BASH and MS PowerShell. It’s nice to read because he took the time to get to know MS Powershell.

Read at source: Linux-magazine

It took me some time to figure this one out. After installing SP3 on my Windows XP virtual machine I was no longer able to update my Windows with Microsoft update. After some debugging I found out that Windows installer was the problem. All windows updates failed directly after installation.

The message I received was: the update or the updates were not installed successfully.

What I did to fix the problem was remove SP3 for Windows XP installed Windows installer 3.1, applied all available updates and last I reinstalled SP3 for Windows XP.

After I fixed it on my Virtual Machine I found this article on the support page of Microsoft but by that time I knew what to look for so… maybe I can save somebody else his or her time by giving you this article up front.

This article has a more simple solution to the problem. This article Explains how to register a DLL that is not registered correctly on a Windows XP SP0 machine where you install SP3. The steps

net stop wuauserv

For x86
regsvr32 %windir%\system32\wups2.dll

for x64
regsvr32 %windir%\syswow64\wups2.dll

net start wuauserv

We all have our weak moments and do stupid things. Just like I did with our virtual center database transaction log. I did not set a maximum growth limit to which the transaction log could grow and so it ran out of disc space. And our Virtual Center server stop running because of it. So I needed to trash the transaction log and fast. I made this little SQL script that can be run with SQL Query Analyzer.

The very simpel solution to this problem:

USE [YouVirtualCenterDB]

BACKUP LOG [YouVirtualCenterDB] WITH TRUNCATE_ONLY

DBCC SHRINKFILE([YouVirtualCenterDB]_log,2)

Remeber this will trash your transaction log. It will not be backuped to disc it will be written to dev NULL. This script is only to be used if your sure you don’t need the transaction log or you need the database running again in a very short time and there is no other way.

Hope it helps some of you.