Hi Gail

I still get the LOG_backup for simple recovery.

This how i get it in sql 2012-

.created new db with simple recovery

.Created 20000 rows

. took back up (Full)

.till now it showslog_resue_wait_desc as Nothing

created 20000 more records and now it shows as Log_backup

Code used is as follows---------------

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',

iinteger)

insert into a (i) values (1)

go 20000