Tags: sql |
Posted by
thomas on
3/26/2009 3:54 PM |
Comments (0)
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...
17b164d5-182b-463b-abbe-75d3ed65bacc|0|.0