All about instant file initialization in SQL

Did you ever wonder why presizing your databases takes so long? At least I did - being the non-DBA that I am. The reason why is that instant file initialization is not turned on by default. Paul S. Randal summarizes the ins & outs of this process on his blog.

If you don’t run your SQL server with a service account that is local administrator (of course you don’t), than you have to grant your SQL service account the “SE_MANAGE_VOLUME_NAME” permission. This can be done through the Local Security Settings of your server. Be aware that it doesn’t work for log files though…