January 14, 2015

Subscribe

Create a Zero’d out File with Powershell

by Scott Newman

When sql server adds space to a transaction log file (or creates the transaction log file) it needs to zero-out said file. Whilst zeroing out the file Sql Server is unfortunately read-only. Hence why you need to be careful in setting reasonable transaction log growth sizes. I wanted to get a quick fix on how long a particularly old system took to create a file and zero it out, hence this script.