Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

  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
add comment

1 Answer

up vote 0 down vote accepted

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

http://support.microsoft.com/kb/971640/

Someone delete the question.

share|improve this answer
add comment

Your Answer

 
discard

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.