Any thoughts on why the check of the filepath doesn't work as opposed to the extension? I've tried to expand on this example and other scenarios don't work. My tempdb log file is located at;
@FileName LIKE '%.ldf' validates
@FileName LIKE '%temp%' validates
@FileName = 'e:\mssql\cms\data\templog.ldf' validates
@FileName LIKE 'e:\mssql\%' doesn't validate
How come the last one won't? I wan't to start building policies to check expected file locations.