LastBackup Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The LastBackup property identifies the most recent date and time at which a backup operation was performed against the referenced transaction log.
Syntax
object
.LastBackup
Parts
- object
An expression that evaluates to an object in the Applies To list
Data Type
String
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetLastBackup(SQLDMO_LPBSTR pRetVal);
Note
SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.
Remarks
The LastBackup property date is reported as a string, formatted as yyyy**/mm/dd hh:mn:ss.**fff where yyyy represents the year in four digits; mm represents the month in two digits; dd represents the day in two digits; hh represents the hour in two digits using a twenty-four hour clock; mn represents the minute in two digits; ss represents the second in two digits; and fff represents the thousandth of a second in three digits.