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.
'
Comments (
)
)
Link to this page:
//www.vb-net.com/Sql/Sql/Ts_sp_ca-cz_7c84.htm
|
|