If you are trying to use ExpressMaint with Microsoft SQL Express 2012 or later, you will most likely run across the following error:
Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
This is easily repaired by installing the following items from the Microsoft® SQL Server® 2008 R2 SP2 Feature Pack:
- Microsoft® System CLR Types for SQL Server® 2008 R2 (SQLSysClrTypes_x86.msi)
- Microsoft® SQL Server® 2008 R2 Shared Management Objects (SharedManagementObjects_x86.msi)