Unanswered: How to log select into/bulk copy transactions
Is there a way to be able to use select into and/or bulk copy statements AND have them logged into the transaction log? If I uncheck select into/bulk copy, these statements cannot be performed. If I leave them checked, the operations are not logged, making my transactions logs invalid.
Builk copy operation are specially designed to be NONLOGGED. Since you have got operations that not looged in tranlog, there is no way to get db in consistant state using this tranlog. Thats why you need to perform full db backup.
In SQL2k u dont need perform full backup after builk ops anymore since they are logged thru BCM pages.