I tried cast('SQL' as nvarchar(5)) as DB_Type and cast('PROD' as nvarchar(5)) as DB_Env in both IF & ELSE clause but no luck.

Is this something new in SQL 2014? This was running fine from very long time on all older versions of SQL even on 2012.

Thanks

Kowsalya

Thanks,I have it as work around but could you please help me with what is the problem with my query have been trying to figure it out.

Thanks

Kowsalya

Here is the final query

IF ((select count(*) from msdb..backupset) > 0)

BEGIN

select @@servername as Instance,

b.database_name as Database_name, max(b.backup_finish_date) as Backup_Date,

Backup_Type =

CASE b.[type]

...

No luck, its failing with the same error. After changing to cast and using exists

SQL job owner is sa and running with SQL server service account

Thanks for your reply.

I'm using SQLSafe for backups, when recovery model is changed from simple to full or full to simple and then try to run a diff/log my backup...