The specified ‘@subsystem’ is invalid
If you get the following error: Create maintenance plan failed. The specified ‘@subsystem’ is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error 14234) Just install Integration Services (just a little job…) and reboot. References: http://support.microsoft.com/kb/909036/en-us
“System Cannot Find Specified Path”
“System Cannot Find Specified Path” when trying to start a SQL Server instance after copying the instance from one machine to another My Scenario 1) Took a snap shot of our production database server using NTBackup 2) Converted the image to run on a virtual server 3) Booted the server with a new server name [...]


