Microsoft distributes Microsoft SQL Server 2008 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.

If you are a Small Business customer, find additional troubleshooting and learning resources at the Support for Small Business site.

Scenario 1

In Microsoft SQL Server 2008, you have a database that cannot be accessed or only allows restricted access. For example, the database is running in one of the following conditions:

The database is read-only.

The database is offline.

The database is running in single-user mode and another user is already using the database.

In this scenario, you cannot set up Data Collector on the server.

For example, if you set up Data Collector when the database is offline, you receive the following error message:

Database '<Database Name>' cannot be opened because it is offline. (.Net SqlClient Data Provider)

Scenario 2

In SQL Server 2008, you set up the Data Collector on a server. Then, you specify that a database is inaccessible or is not fully accessible, such as offline or read-only. In this scenario, Data Collector fails.

This problem occurs because Data Collector enumerates databases. If a database is inaccessible or not fully accessible, the database enumeration fails. Then, the SQL Server Integration Services (SSIS) package stops and then cancels data collection on any remaining databases.

The fix for this issue was first released in Cumulative Update 3 for SQL Server 2008 Service Pack 1. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:

Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. Microsoft recommends that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released

Microsoft SQL Server 2008 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2008 Service Pack 1 hotfix to an installation of SQL Server 2008 Service Pack 1. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.