# Sql-server – Instant File Initialization on Shared drive

performancerestoresql server

I asked something similar to this before, but previously I had asked about moving backups to a shared location. This time I am curious: if I want to restore a database on a shared drive, do I need to enable IFI on that server or just the server that is running SQL Server?

The reason I ask is I am restoring a pretty large database and its been stuck at 100% restored for the last couple hours. The wait type in sp_whoisactive is:

(28472716ms) PREEMPTIVE_OS_WRITEFILEGATHER.
`

The only time I've seen that is when IFI is not on, but I do have it enabled on the SQL Server, but it is not enabled on the shared drive server.