.png)
Database.LastLogBackupDate Property
SQL Server 2008
Gets the date and time when the transaction log was last backed up.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")
'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)
