I had the same quandry with the wording of the company policy. I believe that enabled just means the same thing as the PBM script.

Basically I think that For Every fail, i.e., db that doesn not have a log file that I need to have a Log file created. I don't think there is an actual STATE_DESC = ONLINE or STATE_DESC = OFFLINE (STATE = 1/0) that pertains to anything but the database. I just started second guessing myself because of this being a Company wide written standard.

so in a nutshell, I want to be able to run a ALTER DATABASE script wth parameters and I think this will be the actual correct response to policy fails.

USE master;

DECLARE@PathNVARCHAR(255),

@FileNameNVARCHAR(128),

@NameNVARCHAR(128),

@SIZENVARCHAR(10),

@MAXSIZENVARCHAR(10),

@FILEGROWTHNVARCHAR(10)

SET @Path=''

SET@Name=''

SET@SIZE=''

SET@MAXSIZE=''

SET@FILEGROWTH=''

SET @FileName= @Path + @Name + '_Log.ldf'

GO

ALTER DATABASE dbTest1

ADD LOG FILE

(

NAME= @Name,

FILENAME= @FileName

SIZE= @SIZE,

MAXSIZE= @MAXSIZE,

FILEGROWTH= @FILEGROWTH

);

GO

I have not been able to locate an example of using parameters in this method however.