Krishna1 (6/19/2013)
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.
Create a database, set it to full recovery. Schedule full backups. Run data modifications (create, populate and drop a table if you have nothing else). Wait for the full drive error.
Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability