Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


The job consists of the following steps

  1. dcexec -u -s 1 -i "INSTANCE03"
  2. EXEC [dbo].[sp syscollector purge collection logs]
  3. 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.

share|improve this question
Ok Stepping through this issue I have discovered one of the first commands issued is a user on the database. This fails with the following error. Msg 954, Level 14, State 1, Line 1 The database "DatabaseNameDB" cannot be opened. It is acting as a mirror database. Now I guess I need how to work out how to exclude databases from the collection – Dale Wright Jul 23 '09 at 5:29
use on the database not user – Dale Wright Jul 23 '09 at 5:39
up vote 0 down vote accepted

After getting in touch with Microsoft Support. I have now discovered this is fixed in a cumulative update.

Someone delete the question.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.