Get-DbaDbBackupHistory,dbatools

The below script will give the last FULL backup information for a specifc database of specific server. You need to provide the Server and DatabaseNames.
cls
# Get the backup history
$backupHistory = Get-DbaDbBackupHistory -SqlInstance "ServerName" -Database "DatabaseName" -LastFull -Verbose
# Add a custom column 'ParentFolder' using calculated property to extract the parent folder from the 'Path' property
$backupHistoryWithCustomColumn = $backupHistory | Select-Object ComputerName,SQLInstance,Database,Start,End,Duration,
TotalSize,CompressedBackupSize,Type,
@{Name='Path';Expression={$_.Path | Split-Path -Parent}},
@{Name='File';Expression={$_.Path | Split-Path -Leaf}}
# Display the result with the new custom column
$backupHistoryWithCustomColumn

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server