Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

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


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


[@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)


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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft