sp_tran_dumpable

If you cannot make a transaction dump on a database, sp_tran_dumpable_status displays the reasons the dump is not possible.

Syntax

sp_tran_dumpable_status [database_name]

Parameters

database_name – name of the database you are researching.

Examples

Example 1 – Describes the reasons you cannot currently make a transaction dump on sybsystemprocs:

sp_tran_dumpable_status sybsystemprocs

bit              description
-----------       ----------------------------
          2       Log is not on its own device
          8       Trunc log on ckpt is set
         32       Dump tran with truncate_only
         64       Database is new or upgraded

Usage

This system procedure simply calls the tran_dumpable_status built-in function.

Permissions

Any user can execute tran_dumpable_status. Permission checks do not differ based on the granular permissions settings.