SELECT*

The below cmdlet Install-DBAMaintenanceSolution will Ola Hallengren Maintenance soluction for SQLServer databases. -AutoScheduleJobs WeeklyFull parameter will schedule Fully backps weekly once, DIFF backp on Daily and Log backup every 15 minutes. Install-DbaMaintenanceSolution ` -SqlInstance "RAMESH\UAT" ` -Database DBAMainteance ` -BackupLocation D : \Maintenance\Backup ` -Verbose ` -CleanupTime 72 ` -ReplaceExisting ` -InstallJobs ` -OutputFileDirectory D : \Maintenance\Output ` -AutoScheduleJobs WeeklyFull

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