ConfigMgr Site Restore Fails If Database Has Multiple Database Files

Overview: I recently came across an issue that will cause a ConfigMgr restore to fail. This issue will only apply if you are using the built-in “Backup Site Server” maintenance task and your ConfigMgr database is configured with multiple database files. I was running 15-11, but this will likely affect previous 2012 versions of ConfigMgr….