InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 15:54:53 GMT20http://www.sqlservercentral.com/Forums/Topic1077426-149-1.aspxThanks for the reply gail. Your'e awesome !:-)Mon, 14 Mar 2011 05:10:55 GMTVinodh247http://www.sqlservercentral.com/Forums/Topic1077426-149-1.aspxOther than the few operations that can be minimally logged (see Books Online, Operations that can be minimally logged), it fully logs everything. So most inserts, all updates, all deletes are fully logged. Schema changes are logged (depending what they do how much is logged for each). Enough information is stored for the DB engine to be able to undo or redo any operation.If you're curious...[code="sql"]select * from fn_dblog(null, null)[/code]Sun, 13 Mar 2011 03:35:22 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1077426-149-1.aspxwe all knew that In the Simple recovery model, the database engine minimally logs most operations and truncates the transaction log after each checkpoint. I really want to know what actually gets stored in tlog when it is using simple recovery model.Sun, 13 Mar 2011 03:30:02 GMTVinodh247