• Dear Gail

    I tried it again today. Attached documeent shows the step i took. But after taking full back up it makes the log_reuse_wait_desc as LOG_BACKUP.

    Not able to understand whats making it like this. Due to this log size just keeps increasing even though the recovery model is simple

    Did you try the same in sql2012 express edition? How do i check whats happning to recovery model? (becasue it still shows as simple)

    Regards

    Krishna.