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