While attempting to execute a FAST Server back-up following the directions on TechNet, we ran into the following error:
Cannot find type [Microsoft.SqlServer.Management.Smo.Server]: make sure the assembly containing this type is loaded.
This was an issue we hadn’t experienced in production, and were unsure how to resolve.
After searching around for a while, I found the following post on blogs.like10.com that describes the solution.
Apparent FAST requires SQL management objects, CLR types, and additional PowerShell commands to successfully run the FAST Backup.ps1 file.
From the blog:
In our case we are using SQL Server 2008 R2 so the files we require are part of the Microsoft SQL Server 2008 R2 Feature Pack and we need to download the following components (install in order listed):
- Microsoft System CLR Types for SQL Server 2008 R2
- Microsoft SQL Server 2008 R2 Shared Management Objects
- Microsoft Windows PowerShell Extensions for SQL Server 2008 R2