SQL 2008 Datawarehouse Collection Agent Fails with Mirrored Databases on instance
- by Dale Wright
I have a data collection job that fails when a Database on the instance is in Recovery Mode. The database in recovery is the MIRROR partner in the database mirror.
The Job that fails is as follows.
collection_set_1_noncached_collect_and_upload
The job consists of the following steps
dcexec -u -s 1 -i "INSTANCE03"
EXEC [dbo].[sp syscollector purge collection logs]
dcexec -u -s 1 -i "INSTANCE03"
The job fails at Step 1. I have run the steps manually and they all appear to be ok.
If I change the mirror database to be the principal the job completes successfully.