Why is "close existing connections to destination database" grayed out on SQL Server 2012 Management Studio?

database sql-server sql-server-2012 ssms database-restore

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.


Same happened here with 2014 server and management studio. I could set the database to single user mode under database properties/Options/State/Restrict Access. For me it was set back to multi user mode automatically after the restore.

Related

How to stop lodash.js _.each loop?
Arrow function "expression expected" syntax error
Typescript Array Map Return Object
Is there a way to print a console message with Flutter?
what is the difference between a view model and a data transfer object?
Ruby: convert string to date
Rails ActiveSupport: How to assert that an error is raised?
$K[X]$-modules are $K$-vector spaces with a linear transformation
why scalar projection does not yield coordinates?
How do I calculate the value of this series?
Why do reciprocal functions work for undefined values?
Palindromes in multiple bases