SQL Server 2005 - SQL Server Configuration Manager WMI Error 0x80041010

Problem:
When trying to run SQL Server 2005 - SQL Server Configuration manager, a WMI 0x80041010 Error occurs.

Most likely reason:
The object in WMI that the configuration manager is trying to find isn't present, because it was never loaded.

Solution:

Compile the mof file manually for the SQL Server Configuration Manager so the object gets in there.
Run:
"C:\Windows\System32\wbem\mofcomp.exe" "C:\Program Files\Microsoft SQL Server\90\Shared"

Huge SQL Log growing out of control

SOLUTION:

In Query Analyzer:
--Delete inactive transactions
BACKUP LOG WITH TRUNCATE_ONLY
GO
-- Shrink the log file to 10 MB
DBCC SHRINKFILE(_log,10)
GO


STORY:
Well, today I had another surprise comming into work...No disk space! This has happened many times and for many reasons. So I downloaded 'Disk Space Inspector' to see what might be happening.

I noticed in my data directory (where I keep my SQL databases) that one of my log files was at 2.5 GB! I know better to set the Truncate at Checkpoint, but I guess I didn't...who knows. Anyway, I couldn't remember what to do about it...so a google we shall go...

I read a couple of articles, but basically the theme was the same. You need to backup the log file, which will delete the invalid transactions and then shrink the database. Since my HD was full, I couldn't back it up there. I found an article that explained how to back it up to the network here (but don't do that if you don't want a backup!)

Finally, I came upon the right solution for the job at Microsoft's KB Q272318.

Online Etymology Dictionary

Online Etymology Dictionary

One of my favorite things to do is lookup word orgins. You can find it here at Online Etymology. Its fun to do with a lookup once a day with friends. You always find something intersting. I think my biggest surprise is that most words are not as old as I would have thought. I'd say a great deal of them are only 500 years or less.

Sushi House

Sushi House

Well, here it is my favorite place to eat here in Overland Park, KS. My favorite dishes are Tako Sunomono (sliced octopus over slices of cucumber with rice vinegar), Miso soup, Tekka Don (tuna sashimi over rice). So if you are town, be sure to stop by and see all the friendly faces.

Green Tea Benefits Health

Green Tea Benefits Health

This is a great site if you want your green tea (緑お茶)　straight from Japan. I met a person from the Shizuoka (静岡) region of Japan, and she recommended this tea. I tried some and its great!! I got some great ceramic tea pots from here, but I'm always looking for something better.

I suggest that you try a first flush sencha. I got the daily sencha, and it was good, but the higher grade teas definitely make a difference.

Un-blog

Welcome to un-blog...or anti-blog or anything that is not blog. The irony....