Which operation will affect the log file?
By keam_wu
@keam_wu (5)
China
September 3, 2007 1:08am CST
These days I'm trying to research the technology of recovery model, in sql server 2005, it has three recovery model, which are simple, full,bulk-insert, I had tried some simple test, but still didn't know which operation will increase the log file under the three recovery model.
1 response
@wqhhust (62)
• United States
4 Sep 07
Do you mean which DML, DCL or DDL will increase the log file? THe log file is like the redo log for oracle, nearly any DML/DCL/DDL will create log, so each operation will increase the log file.
BTW, I find this is a good place to discuss non-tech things to improve English. it is not a professinal website for tech.
@keam_wu (5)
• China
5 Sep 07
Ok , I see, thanks. I just want to know how many people interesting this topic, haw-haw.
I'm studying SQL Server those days, and according to the tech document, all the operation will record in log file if the recovery model is full, and some operationi will record if the recovery model is bulk-insert, such as Bulk insert, bcp, select into*, but in my testing , the log file increased even I do "select into" operation under bulk-insert recovery model.
I will research more tech to makeup this topic if have time
