Data Protection SQL & Microsoft SQL Server System CLR prerequisites

Technote (FAQ)


Question

Does the Data Protection for Microsoft SQL use the CLR(Common Language Runtime) or CLR types?

Answer

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.


Product Alias/Synonym

TSM DP

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager for Databases
Data Protection for MS SQL

Software version:

5.5, 5.5.1, 5.5.2, 5.5.4, 5.5.5, 5.5.6, 6.3, 6.3.1, 6.4

Operating system(s):

Windows

Software edition:

All Editions

Reference #:

1626905

Modified date:

2013-04-26

Translate my page

Machine Translation

Content navigation