I'm looking for a way to determine the last Full, Diff and subsequent Log backups of a database using Powershell and SMO.
I want to simplify what I've been doing previously, see below for example, I want to find away of having all the file names returned that I'd need to do a Pit restore without having to sue tsql.
$qry = @"
DECLARE @dbname sysname
SET @dbname = '$database'
SELECT f.physical_device_name as [backup]
FROM msdb.dbo.backupset AS s WITH (nolock) INNER JOIN
msdb.dbo.backupmediafamily AS f WITH (nolock) ON s.media_set_id = f.media_set_id
WHERE (s.database_name = @dbname) AND (s.type = 'D')
AND (s.backup_finish_date = (SELECT MAX(backup_finish_date)
FROM msdb.dbo.backupset WITH (nolock)
WHERE (database_name = @dbname) AND (type = 'D') AND (is_snapshot = 0)))
Can you contact Chrissy LeMaire on Twitter ( https://twitter.com/cl ) ? She's the founder of this project, and for sure she can help you out. If she doesn't know it, she can put you in contact with someone else for sure.