• Dear All

    Thanks for your replies. I have done testing of .ldf file size using 2 newly created DB. One DB is simple recovery model and other Full recovery model.

    Created following table in both DBs

    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)

    and used

    insert into a (i) values (1)

    go 20000

    Please refer to the pdf file of my findings. From the PDF file i noticed that Full recovery model after transaction log back up us taken it resused the log space. But in the Simple recovery model its keeps on growing, which i know is not correct.

    Let me know what is that i am doing wrong

    Regards

    Krishna1