Press "Enter" to skip to content

Zeroing out a Transaction Log File

Randolph West reports on a change in SQL Server 2014:

I’ve been doing SQLskills training recently, and Paul Randal (blog | Twitter) reminded our class that zeroing out a transaction log file does not use zeroes (0x00). Well, not since SQL Server 2014 at any rate.

Click through to see what SQL Server uses instead when “zeroing” out a log file.