dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Get-DbaBackupDevice

Gets SQL Backup Device information for each instance(s) of SQL Server.

Screenshots

Examples

To return all Backup Devices on the local default SQL Server instance.

Get-DbaBackupDevice -SqlInstance localhost

To return all Backup Devices for the local and sql2016 SQL Server instances.

Get-DbaBackupDevice -SqlInstance localhost, sql2016

Author

This command was created by Garry Bargsley. You can find Garry on Twitter and his blog.

Get-Help

From PowerShell, execute Get-Help Get-DbaBackupDevice -Detailed for more information on this function.

Source Code

Want to see the source code? View Get-DbaBackupDevice.ps1 on GitHub
 

Related commands