Why is "close existing connections to destination database" grayed out on SQL Server 2012 Management Studio?
I had the same issue. I simply checked the Checkbox BEFORE choosing the source to restore from. After choosing the source the CB was grey but checked and the restore worked fine.
right click on database-> properties-> Options-> change Auto Update statistics Asynchronously to false. it will solve close existing connections to destination database grayed out issue
I hope it help
It can happen if you are restoring from a version less than 2012, for instance trying to restore a SQL Server 2005 database using SSMS 2012.