sp_can_tlog_be_applied

Verify that a transaction log can be applied to a database.

Syntax

sp_can_tlog_be_applied [ @backup_file_name = ] 'backup_file_name'
    , [ @database_name = ] 'database_name'
    , [ @result = ] result OUTPUT

Arguments

[@backup_file_name =] 'backup_file_name'

Is the name of the backup file. backup_file_name is nvarchar(128).

[@database_name =] 'database_name'

Is the name of the database. database_name is sysname.

[@result =] result OUTPUT

Indicates whether the transaction log can be applied to the database. The value one (1) means the log can be applied; zero (0) means it cannot. result is bit.

Return Code Values

0 (success) or 1 (failure)

Permissions

Only members of the sysadmin fixed server role can execute sp_can_tlog_be_applied.