snippetMinor
How to know if Instant File Initialization is enabled?
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)
(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.