Database.LastLogBackupDate Property
Gets the date and time when the transaction log was last backed up.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property LastLogBackupDate As DateTime
Get
'Usage
Dim instance As Database
Dim value As DateTime
value = instance.LastLogBackupDate
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public DateTime LastLogBackupDate { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property DateTime LastLogBackupDate {
DateTime get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member LastLogBackupDate : DateTime
function get LastLogBackupDate () : DateTime
Property Value
Type: System.DateTime
A DateTime object value that specifies the date and time when the transaction log was last backed up.
Examples
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
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
Transaction Log Backups (Full Recovery Model)