Hi All SQL Server & scripting experts,
I've got multiple different version of SQL Server Database running from 2008 R2 up to 2014 edition.
Can anyone here please share the script (T-SQL or PowerShell) to list all SQL Backup job that is currently setup or configured to backup the Database on each database server?
I need to know if there is any backup job has been set and where it is dumping it's database into ?
Because sometimes I've found out that the D:\ drive is full due to the SQL backup dumping large.BAK file into the same drive as the SQL database .MDF running.
Thanks in advance.