Krishna1 (6/19/2013)
Thanks for quick reply. How do I test this. I need to show the diff that log will not get trucated even if we take full back every day. Can u tell so.e was to demonstrate the difference between a imple and full recovery model
It is easy to test this
Follow the below steps:
1. Set the recovery model as FULL
2. Create a table in the database
3. Insert lots of data in the table and check the log size
4. Take a FULL backup
5. Repeat steps 3 & 4 as many times as you want
Note down the log size after every iteration and you will find that the log size keeps on increasing.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/