Archive for September, 2014

Stupid SQL Things To Do: Backup to NUL

Occasionally I’ve come across a site where backups are taken to disk = ‘NUL’. Note that’s NUL with 1 L and not NULL with 2 L’s. I’ve seen it recommended in a few places online as a quick fix where a log file has grown out of control and at least one SQL backup utility actively uses it under the guide of ‘truncating the transaction log’.

Read More →