CREATE DATABASE TestingRecoveryModel

GO

ALTER DATABASE TestingRecoveryModel SET RECOVERY SIMPLE

GO

BACKUP DATABASE TestingRecoveryModel TO DISK = 'C:\Databases\Backups\Testing.bak'

GO

USE TestingRecoveryModel

GO

create table a ( a1 char(1000) default 'a1',

a2 char(1000) default 'a2',

a3 char(1000) default 'a3',

a4 char(1000) default 'a4',

a5 char(1000) default 'a5',

a6 char(1000) default 'a6',

a7 char(1000) default 'a7' ,

i integer)

GO

insert into a (i) values (1)

go 20000

SELECT name, recovery_model_desc, log_reuse_wait_desc FROM sys.databases WHERE name = 'TestingRecoveryModel'

GO

insert into a (i) values (1)

go 20000

SELECT name, recovery_model_desc, log_reuse_wait_desc FROM sys.databases WHERE name = 'TestingRecoveryModel'

GO

Double check code and settings, you cannot get a log reuse wait of log backup on a database that's always been in simple recovery model.