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