# Script is ran on the SQL server (not remotely)
# Instance is called sql-instance
# database is called sql-data

import-module SQLPS -disableNameChecking
$instanceName = "$($env:computername)\sql-instance"
$server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName
$lastBackupFile = Invoke-Sqlcmd -Query "
	SELECT TOP 1 msdb.dbo.backupmediafamily.physical_device_name 
	FROM   msdb.dbo.backupmediafamily 
		INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id 
	WHERE  msdb..backupset.type = 'D' and msdb.dbo.backupset.database_name = 'sql-data'
	ORDER BY  msdb.dbo.backupset.backup_finish_date desc"

physical_device_name
--------------------
C:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSQL\Backup\full_sql-data_20121101.bak