If you want to troubleshoot a slow SQL Server Restore or just find out more about all the restore steps , use these techniques to give you an insightÂ
Click through for the extended event session as well as a script to shred the resultant XML and a sample output.