Database.LastDifferentialBackupDate Property

Gets the date and time when the last differential backup was performed.

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 LastDifferentialBackupDate As DateTime 
    Get
'Usage
Dim instance As Database 
Dim value As DateTime 

value = instance.LastDifferentialBackupDate

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public DateTime LastDifferentialBackupDate { get; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property DateTime LastDifferentialBackupDate {
    DateTime get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member LastDifferentialBackupDate : DateTime

function get LastDifferentialBackupDate () : DateTime

Property Value

Type: System.DateTime
A DateTime object value that specifies the date and time when the last differential backup was performed.

See Also

Reference

Database Class

Microsoft.SqlServer.Management.Smo Namespace

LastBackupDate

LastLogBackupDate

Other Resources

Working with Database Objects

Transaction Log Backups (Full Recovery Model)

Transaction Log Backups (Full Recovery Model)

CREATE DATABASE (Transact-SQL)