Unanswered: How to prevent non logged updated to database
I want to make sure all updates to a db are logged so that backup/restore of translogs go through correctly. We have no need for bulk copy operations, so having non logged transactions don't offer any benefits. Can I do this by making sure select into/bulk copy is unchecked?
Actually...what I should be asking is that, instead of PREVENTING non logged operations, will unchecking Select Into/Bulk Copy make sure that all transactions that create changes in a database are logged? Is there anyway to do this?