HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to know if Instant File Initialization is enabled?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
fileenabledknowhowinstantinitialization

Problem

Besides creating a new database and timing it, is there a simple way to determine whether or not Instant File Initialization is enabled/functioning?

(on Windows Server 2008 Enterprise)

Solution

Using ntrights.exe, check if the SeManageVolumePrivilege priviledge is granted. IF you prefer a 'built in' tool, use secedit /export /areas USER_RIGHTS.

Context

StackExchange Database Administrators Q#10824, answer score: 4

Revisions (0)

No revisions yet.