#Write-SqlTableData

[prashantjayaram]

Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL

Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL

This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script includes various columns that show the internals of a database, backup size, and gives the latest completion statuses and the corresponding backup sizes. Though the output is derived from the msdb database, having the data consolidated at one place gives us better control and…