Database.LastBackupDate 属性

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

命名空间:  Microsoft.SqlServer.Management.Smo
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property LastBackupDate As DateTime 
    Get
用法
Dim instance As Database 
Dim value As DateTime 

value = instance.LastBackupDate
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public DateTime LastBackupDate { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property DateTime LastBackupDate {
    DateTime get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member LastBackupDate : DateTime
function get LastBackupDate () : DateTime

属性值

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

示例

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

请参阅

参考

Database 类

Microsoft.SqlServer.Management.Smo 命名空间

LastDifferentialBackupDate

LastBackupDate

其他资源

使用数据库对象

Transaction Log Backups (Full Recovery Model)

创建、更改和删除数据库

CREATE DATABASE (Transact-SQL)