[Script Of Dec. 10] How to get the information of last backup for all the SQL databases


Script Download:  
The script is available for download from https://gallery.technet.microsoft.com/How-to-get-the-information-cb205c18.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

This PowerShell script will demonstrate how to get the information of the last backup for all the SQL databases. All we need is to provide an available instance name of the SQL Server and the script will list the last backup history of all the databases in the instance.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

Skip to main content