{"description":"This custom metric queries the MSDB database to search for multiple paths for a full backup","name":"Full backup to odd path","tsql":"CREATE TABLE #defaultPath (\r\n\tvalue VARCHAR(500)\r\n\t,BackupPath VARCHAR(250)\r\n\t)\r\n\r\nINSERT INTO #defaultPath\r\nEXECUTE [master].dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE'\r\n\t,N'SOFTWARE\\Microsoft\\MSSQLServer\\MSSQLServer'\r\n\t,N'BackupDirectory'\r\n\r\nSELECT COUNT(*)\r\nFROM (\r\n\tSELECT LEFT(b.physical_device_name, LEN(b.physical_device_name) - charindex('\\', reverse(b.physical_device_name), 1) + 1) AS [Path]\r\n\tFROM msdb.dbo.backupset a\r\n\tINNER JOIN msdb.dbo.backupmediafamily b ON a.media_set_id = b.media_set_id\r\n\tWHERE a.type = 'D'\r\n\t\tAND a.database_name = DB_NAME(DB_ID())\r\n\t\tAND a.backup_finish_date BETWEEN DATEADD(MINUTE, - 2, GETDATE())\r\n\t\t\tAND GETDATE()\r\n\t\tAND LEFT(b.physical_device_name, LEN(b.physical_device_name) - charindex('\\', reverse(b.physical_device_name), 1) + 1) <> (\r\n\t\t\tSELECT BackupPath\r\n\t\t\tFROM #defaultPath\r\n\t\t\t)\r\n\tGROUP BY LEFT(b.physical_device_name, LEN(b.physical_device_name) - charindex('\\', reverse(b.physical_device_name), 1) + 1)\r\n\t) t\r\n\r\nDROP TABLE #defaultPath","databases":{"mode":1},"instances":true,"metricenabled":true,"noalertremark":"You could add an alert once the baseline for your environment has been established.","frequency":60,"frequency_comment":"seconds (collected every minute)","rateofchange":false,"aboveorbelow":"above","_thresholds_high":{"selected":false},"_thresholds_medium":{"selected":false},"_thresholds_low":{"selected":false},"collections":1,"alertenabled":true,"targetentitytype":0}