sqlreader.log_reuse_wait.jsl

SQL 类Shell代码生成器 对SQL Server 2005,2008生成C#代码

public enum Log_Reuse_Wait {
    
    // Hex value is: 00000000
    /** @attribute Description("Currently there are one or more reusable virtual log files.")*/
    NOTHING(0),
    
    // Hex value is: 00000001
    /** @attribute Description("No checkpoint has occurred since the last log truncation, or the head of the log " +
"has not yet moved beyond a virtual log file (all recovery models).This is a rout" +
"ine reason for delaying log truncation. For more information, see Checkpoints an" +
"d the Active Portion of the Log.")*/
    CHECKPOINT(1),
    
    // Hex value is: 00000002
    /** @attribute Description("A log backup is required to move the head of the log forward (full or bulk-logged" +
" recovery models only). Note:  Log backups do not prevent truncation. When the l" +
"og backup is completed, the head of the log is moved forward, and some log space" +
" might become reusable.")*/
    LOG_BACKUP(2),
    
    // Hex value is: 00000003
    /** @attribute Description("A data backup or a restore is in progress (all recovery models). A data backup wo" +
"rks like an active transaction and, when running, the backup prevents truncation" +
". For more information, see \"Data Backup Operations and Restore Operations,\" lat" +
"er in this topic.")*/
    ACTIVE_BACKUP_OR_RESTORE(3),
    
    // Hex value is: 00000004
    /** @attribute Description("A transaction is active (all recovery models). A long-running transaction might e" +
"xist at the start of the log backup. In this case, freeing the space might requi" +
"re another log backup. For more information, see \"Long-Running Active Transactio" +
"ns,\" later in this topic. A transaction is deferred (SQL Server 2005 Enterprise " +
"Edition and later versions only). A deferred transaction is effectively an activ" +
"e transaction whose rollback is blocked because of some unavailable resource. Fo" +
"r information about the causes of deferred transactions and how to move them out" +
" of the deferred state, see Deferred Transactions. ")*/
    ACTIVE_TRANSACTION(4),
    
    // Hex value is: 00000005
    /** @attribute Description("Database mirroring is paused, or under high-performance mode, the mirror database" +
" is significantly behind the principal database (full recovery model only). For " +
"more information, see \"Database Mirroring and the Transaction Log,\" later in thi" +
"s topic.")*/
    DATABASE_MIRRORING(5),
    
    // Hex value is: 00000006
    /** @attribute Description("During transactional replications, transactions relevant to the publications are " +
"still undelivered to the distribution database (full recovery model only). For m" +
"ore information, see \"Transactional Replication and the Transaction Log,\" later " +
"in this topic.")*/
    REPLICATION(6),
    
    // Hex value is: 00000007
    /** @attribute Description("A database snapshot is being created (all recovery models). This is a routine, an" +
"d typically brief, cause of delayed log truncation.")*/
    DATABASE_SNAPSHOT_CREATION(7),
    
    // Hex value is: 00000008
    /** @attribute Description("A log scan is occurring (all recovery models). This is a routine, and typically b" +
"rief, cause of delayed log truncation.")*/
    LOG_SCAN(8),
    
    // Hex value is: 00000009
    /** @attribute Description("This value is currently not used.")*/
    OTHER_TRANSIENT(9)
}