False Results | Evaluating 'Simple Recovery Model' and PS script returns false results

Sep 26, 2012 at 11:49 PM

Good Afternoon Everyone.

I evaluted the 'Check for Simple Recovery' policy using the PS script. This policy checks if my database's recovery model != SIMPLE. Well the results return 'FAIL' when it should return 'PASS'. I checked my database's properties again and again, and my databases are in Simple recovery.

Anyone else having this issue?

Nov 20, 2012 at 11:31 PM

In response,

It sounds as if you want to verify that your databases are set to 'Simple' mode and to do this you would need to set your condition to:

@RecoveryModel = Simple

by setting your Condition to how you are describing you will pass only when the database is set to 'Full' or 'BulkLogged'

@RecoveryModel != Simple

Hope this clarifies your question,

Cory