• Hi Gail,

    Can I please ask a quick question. In your article you say the following:

    Log backup

    The log backup wait reason will never appear in Simple Recovery.

    Now I do agree this is a valid statement, however:

    SELECT database_id,

    recovery_model_desc,

    log_reuse_wait_desc

    FROM sys.databases

    WHERElog_reuse_wait_desc <> 'NOTHING'

    database_idrecovery_model_desclog_reuse_wait_desc

    46SIMPLELOG_BACKUP

    Why would I be seeing this?

    Thanks

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]