Friday, 3 June 2011

Preventing MS SQL Transaction log bloat

The easy solution to this is:
  1. make a backup of your transaction log
  2. shrink your transaction log

Do not ever use "truncate_only" or "no_log" unless you wish to forget about the whole "database recovering in any point of time".

See some links here:

No comments:

Post a Comment