to seth99(seth) :
大哥,
“设定trunc. log on chkpt., 用bcp or BULK INSERT就可以insert data不写log的”
的前提条件也忒严了吧:
A nonlogged bulk copy occurs if all the following conditions are met:
1、The database option select into/bulkcopy is set to true.
2、The target table has no indexes, or if the table has indexes, it is empty when the bulk copy starts.
3、The target table is not being replicated.
The TABLOCK hint is specified using bcp_control with eOption set to BCPHINTS.
日志这么好的东西怎么能不要呢?如果没有它就不是真正的商业数据库了,只要用的得当,不会有带来什么麻烦
===========================================================================
1.对于银行、电信、证卷等事务性业务,是希望能rollback;
让SQLServerAgent定时backup log(1h or 2h or 3h.....),那log size自然能够控制到合理的大小
2.但是对于工业控制,现场监视,这个数据量同样很大,但是是完全不需要rollback的。
设定trunc. log on chkpt., 用bcp or BULK INSERT就可以insert data不写log
===========================================================================