Database.LastBackupDate Database.LastBackupDate Database.LastBackupDate Property


Gets the date and time when the database was last backed up.

 property DateTime LastBackupDate { DateTime get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Expensive | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone)]
public DateTime LastBackupDate { get; }
Public ReadOnly Property LastBackupDate As DateTime
Property Value

A DateTime object value that specifies the date and time when the database was last backed up.



'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("Created on " + db.CreateDate)  
Console.WriteLine("Last backed up on " + db.LastBackupDate)  
Console.WriteLine("Log last backed up on " + db.LastLogBackupDate)  


$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  

Applies to

See Also