1) steps how i got Log_Backup for the simple

.created new db with simple recovery

.Created 20000 rows

. took back up

.till now it showslog_resue_wait_desc as Nothing

created 20000 more records and now it shows as Log_backup

2)how to check if active transaction log exsits?