Does the Data Protection for Microsoft SQL use the CLR(Common Language Runtime) or CLR types?
The Data Protection SQL client requires the Microsoft SQL Server 2008 Management Objects (SMO) from the feature pack for the backup/restore interface.
The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005 and SQL Server 2008.
Note: Microsoft SQL Server 2008 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types.
The Data Protection for SQL deploys the CLR Types to satisfy the SMO prerequisite, but the Data Protection for SQL does not actually utilize the CLR or CLR Types. It is important to note that having the CLR Types installed is not the same as CLR enablement or use. By default CLR support is disabled on the SQL Server, thus, unless it's explicitly enabled by a DBA, it should not be in use.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.