Locked out of SQL 2008?

I was recently found myself locked of a demo environment by removing the builtin\administrators group from SQL Server’s sysadmin role – a good practice by the way. I needed to get into SQL Management Studio. This particular installation of SQL 2008 was running under the localsystem account.  Using PSEXEC from sysinternals, I was able to…

Recovering deleted objects in AD 2008

In Windows 2008, Microsoft introduced the ability to create and mount AD snapshots online, without having to reboot into Directory Services Restore Mode (DSRM).   By exposing an AD Snapshot, you can check to see if the backup set contains the deleted object in question. I also show a technique of using a 3rd party tool…

Using repadmin.exe to monitor AD replication

This is really just a ‘re post’ of an excellent blog article demonstrating the features of repadmin. I learned quite a bit from reading this and hopefully this will benefit other AD Administrators out there. I like the summary command: Repadmin /replsummary * And /syncall with the /A(ll partitions) P(ush) e(nterprise, cross sites) d(istinguished names)…

Moving DHCP Server Scope from 2003 to 2008

Couldn’t be easier!   from 2003 server: netsh dhcp server export C:\dhcp.txt all   copy dhcp.txt to the 2008 server (where the DHCP role was installed and authorized) netsh dhcp server import c:\dhcpdatabase.txt all Done! Wow! Remember when this used to be a pain?   http://blogs.technet.com/networking/archive/2008/06/27/steps-to-move-a-dhcp-database-from-a-windows-server-2003-or-2008-to-another-windows-server-2008-machine.aspx

Antivirus on Hyper-V

I was on a customer call today where they had installed Kapersky anti-virus on their Hyper-V host. The server would no longer boot up. After reviewing KB 961804 I recommended that the customer add the proper exclusions or uninstall Kapersky.  To complicate matters, it was not possible to uninstall the product from Add/Remove programs because…

VMMCA 2008 diagnostic tool

This tool can help troubleshooting SCVMM 2008 RTM. “There are many occasions on the public forums where a customer is struggling with a commonly known issue on VMM 2008 RTM.  For those commonly known issues we have bundled those up into a tool called the Virtual Machine Management Configuration Analyzer.  This tool enables customers to…