Import Hyper-V Machine Without Export File
Joe Johnson - 23/12/2009
Last week I had a client with a crashed hard drive on their Hyper-V server. Coming from a physical server world, they had performed file-level backups of all the virtual machines and virtual machine files on the system. Expecting to just recover the files to the new RAID array and use the “Import virtual machine” feature of Hyper-V Manager, I was shocked to learn that unless you perform a specific “Export virtual machine” step, you cannot import a virtual machine file.
When you only have a simple VM that consists of a single VHD file and no snapshots, things are quite easy to restore: create a new virtual machine with the same physical configuration and attach the existing VHD. Open and shut, done in 5 minutes or less. However, if the machine has had snapshots, even if you have since removed the snapshots, chances are the individual snapshot files are still floating on the hard drive and are required for full recovery.
What I ended up doing was following the very helpful instructions located here for Option 2 and recovered both machines to the server in about 45 minutes. Very easy, very straightforward, but also very unsupported. Lacking a Hyper-V-aware backup, though, this was the best option for me.
Going forward, we have implemented Hyper-V-aware backups using the Microsoft Data Protection Manager 2007 with SP1 software and iSCSI mounted storage. Alternatively, BackupExec 12.5 has an option available that makes BE aware of the Hyper-V machines and can independently backup their configurations.
MySQL Recovery for Plesk 8.x After System Crash
Joe Johnson - 01/09/2009
I checked and checked and couldn’t find a good answer to this question: how do I recover my MySQL databases for Plesk after a system crash if I don’t have MySQL-aware backups? BackupExec captures the .frm files and the InnoDB logs, but it can’t restore specific databases or tables, just the raw files. And if all you have is the raw files, you cannot restore just one DB. So, I figured what the hell, I’ll restore it all!
First, I stopped mysqld-nt on the server. Then, I restored all of my database folders and the InnoDB logs (for me, the contents of C:\Program Files\Parallels\Plesk\Databases\MySQL\Data). Finally, I started mysqld-nt and viola! All of my databases and users were restored to the system.
In theory, I could restore these files to another machine running MySQL for Windows of the same build as my live server, then run a MySQL backup (mysqldump, for example) and restore with more granularity, but I did not test this: YMMV. In this case, the whole shebang was gone, so I needed it all back.