Database.LastLogBackupDate Property
Gets the date and time when the transaction log was last backed up.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
VB
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Reference the AdventureWorks2012 database. Dim db As Database db = srv.Databases("AdventureWorks2012") 'Display date data for the database. Console.WriteLine(db.Name) Console.WriteLine("Created on " + db.CreateDate) Console.WriteLine("Last backed up on " + db.LastBackupDate) Console.WriteLine("Log last backed up on " + db.LastLogBackupDate)
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)") $db = New-Object Microsoft.SqlServer.Management.Smo.Database $db = $srv.Databases.Item("AdventureWorks2012") Write-Host $db.Name Write-Host "Created on " $db.CreateDate Write-Host "Last backed up on " $db.LastBackupDate Write-Host "Log last backed up on " $db.LastLogBackupDate
Show: