Tags: | 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...

Comments

Add comment




  Country flag


  • Comment
  • Preview
Loading