Configuring a SQL Server with Instant file initialization is a fairly standard part of SQL Server Installation Checklists. There are substantial benefits to the duration taken during a SQL Server database restore. If you want to read more on how to set up instant file initialization and the technical benefits read SQL Server faster restores with instant file initialisation When I first started using instant file initialization I used to manually check using the gpedit.msc console - and checking the Windows Settings | Security settings | Local Policies | User Rights Assignments. Eventually I wrote a script to check as... Read more →