SQL 2008 Datawarehouse Collection Agent Fails with Mirrored Databases on instance
Posted
by Dale Wright
on Server Fault
See other posts from Server Fault
or by Dale Wright
Published on 2009-07-23T01:47:18Z
Indexed on
2010/04/10
13:33 UTC
Read the original article
Hit count: 380
sql-server-2008
|database-mirroring
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.
© Server Fault or respective owner