balasaukri (6/19/2013)
If db recovery model is simple and I take full back up every day. And if my recovery mdel is full and I take only fulll backup every day.(I do not take transaction log back up at all.)
Will these recovery models give same results or am I missing some thing.
---- Taking Full Backup on the database which is in either Full or Simple or Bulk-logged recovery model will give the same result only and there won't be any difference.
Thanks
Bala
Sorry, but that's wrong. The recovery model setting has no influence on when and whether the log files get "cleared". Just follow Gail's link a little further up for an explanation as to why.