Dealing with a large transaction log file

(Nigel Rivett) Whenever a data update is made entries are added to the transaction log. It is not possible to prevent this as it is part of the way sql server maintains integrity – particularly during recovery. The transaction log is a circular file i.e. when the end is reached any free entries

Read More - Register for Free Membership