Matts Admin Tips
Welcome to Matts Admin tips. This blog is full of little fixes, tutorials and work-arounds to those anoying problems that a Systems Administrator might face. If you find something that you have found useful please leave me a comment - I appreciate knowing that I've helped! Also, feel free to leave a comment if my tips or ideas don't work in your environment... I monitor them closely and would be happy to help! Matt
I’ve finally posted the full 2007 season of Get This.
How good is this?
http://mattlog.net/get-this-2007-episodes-01-99/
http://mattlog.net/get-this-2007-episodes-100-187/
Posted by Matt ShadboltTags: Get This 2007
Mapi session “/o=DOMAIN/ou=first administrative group/cn=Recipients/cn=username” exceeded the maximum of 500 objects of type “objtFolderView”.
This error is caused by the Outlook 2007 Cached Exchange mode setting “Download shared folders (excludes mail folders) being enabled by default. You can untick this box manually on each client (Tools > Account Settings > Change > More Settings > Advanced) or you can disable this setting domain wide via the Outlk12.adm Group Policy admin feature set.
Microsoft’s step-by-step instructions can be found here - http://technet.microsoft.com/en-us/library/cc179175.aspx#BKMK_ConfigureUsingGroupPolicy
Basically, you need to DISABLE the “Synchronizing data in shared folders” option and apply the GPO to the users in your domain.
Posted by Matt ShadboltTags: MAPI, objtFolderView, Outlook 2007
I’ve just posted all episodes of Get This from 2006.
You can download them from:
http://mattlog.net/get-this-2006-episodes-01-99/
http://mattlog.net/get-this-2006-episodes-100-171/
I’ll be posting the 2007 episodes next week.
Posted by Matt ShadboltStrangely, Microsoft apply a default password to all Windows Storage Server 2008 products – and without downloading all of the TechNet documentation you aren’t told the password!
Well, thanks to Quantum John the password is:
wSS2008!
Posted by Matt ShadboltHad a strange issue today where my Gmail themes and Digg.com login/comments weren’t loading properly. It was only happening on my local machine, and loading those pages up in IE worked fine. The issue was obviously with my FF profile.
After some digging around with my Firefox profile, and manually removing lines from the prefs.js (I know, you should use the About:Config to make these sorts of changes), I found the offending line:
user_pref(“general.useragent.override”, “Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)”);
Removing this line from the prefs.js file fixed the issue.
Posted by Matt ShadboltTags: Firefox 3.5, general.useragent.override
While trying to restore a MSSQL 2008 .BAK file to a staging server, I received the following error:
The media family on device ‘C:\database_backup.bak’ is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
This is actually an easy error to fix! The problem is due to the service pack level of the server you are trying to restore to. If you backup the database on a SQL 08 server with SP1 applied, you need to make sure the destination server is at SP1 level too.
Posted by Matt ShadboltI’m finally completing my MCSE certification with one exam to go, and I thought I’d quickly post on a great online training site that I’ve found.
Unfortunately I didn’t know about this site until recently, so I’m only using it for the one exam (70-294).
http://www.vtc.com
For only $30 per month, you get full access to their video training catalog including all of the major Microsoft exams. There’s also heaps of other courses including Photoshop, programming, Cisco and heaps of others. Even better, its a simple monthly fee. Once you’ve completed the certs your after you can just cancel the account.
The videos are good quality, broken down into chapters and includes slide-show style presentations and lab senarios. In conjunction with the MS Press books there’s no reason to fail!
Posted by Matt ShadboltTags: MCSE, Microsoft Training
Here’s a LogParser query I’ve written that will output the top hits for your website within the last 7 days. All you need to do is change the path of the log file location:
SELECTÂ COUNT(*) AS Hits, cs-uri-stem AS Page
FROM D:\LogFilePat*.*
WHERE
TO_DATE(Date) >= TO_DATE(SUB(SYSTEM_TIMESTAMP(), TO_TIMESTAMP(’01-07′, ‘MM-dd’)))
GROUP BY cs-uri-stem
ORDER BY Hits DESC
Tags: Hits last 7 days, LogParser
I’ve been having some issues with my maintenance plans in SQL Server 2005. I’ve been using the newer 2008 Server Management Studio to manage my SQL servers and it didn’t occur to me that the newer version would break my maintenance plans.
When I modify the plans in 2005 Management Studio I receive the following error:
The DDS layout contains an invalid control progid.
After opening the maint plans in 2005 and resaving them they are back to their old glory and working perfectly.
Tags: SQL Server 2005, SQL Server Management Studio 2008
Here’s a quick and dirty Exchange 2007 command-let that will output all the outgoing emails that are not being delivered. It Checks the message status (NOT “Active) and the message retry count (GT 0) and outputs the results.
Get-Message -Server SERVER01 -IncludeRecipientInfo | Where{$_.RetryCount -gt 0} | Where{$_.Status -ne “Active”} | SELECT FromAddress, Recipients, LastError | Format-Table
Tags: EMS, Exchange 2007, Get-Message, PowerShell
