LastRestore Property
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The LastRestore property identifies the last transaction log unit in a chain of log backups.
구문
object
.LastRestore [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetLastRestore(LPBOOL pRetVal);
HRESULT SetLastRestore(BOOL NewValue);
주의
Microsoft SQL Server provides administrators with a variety of backup options designed to enable efficient protection of an organization's data. One common option uses a scheduled full database backup at one interval, and related backups of the transaction log performed at a smaller interval. In the event of catastrophic failure, the full database backup is restored and then each log backup made after that point is restored in order, which restores the database to its most recent verifiable state.
If more than one log unit exists for restoration, it the administrator must specify that more than one log unit will be restored. After SQL Server processes the last log unit in the chain, no log backups made after that unit can be applied.
Set the LastRestore property to FALSE when restoring a backup unit that is not the last in a backup chain. Set the LastRestore property to TRUE when restoring a backup unit that is the last in the chain.