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

Sql ServerDatabaseSql Server-2012SsmsDatabase Restore

Sql Server Problem Overview

I am normally using SQL Server 2012 Management Studio to restore a SQL Server database from a "bak" file. I do this by overwriting an existing database. In the "Options" page, there is a check-box labeled "Close existing connections to destination database", which I mostly check because the target database is always "in use", even if I just restarted the MS SQL Service and I am sure that there are no applications using it.

Anyway, on my client's computer, I saw that that checkbox to close existing connections is grayed out without any information. How and why does this happen? A google search didn't yield any results.

Sql Server Solutions

Solution 1 - Sql Server

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.

Solution 2 - Sql Server

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

Solution 3 - Sql Server

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.

Solution 4 - Sql Server

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.

Solution 5 - Sql Server

Restart SQL Server (MSSQLSERVER) service and try to restore. Not a great solution but sometime it works.

Solution 6 - Sql Server

Before selecting the backup file from the device . Tick close existing connection to destination database

Categories
Recommended Sql Server Solutions
Recommended Database Solutions
Recommended Sql Server-2012 Solutions
Recommended Ssms Solutions
Recommended Database Restore Solutions

Previous Solution:

What is the difference between Rails.cache.clear and rake tmp:cache:clear?

Ruby on-RailsRuby on-Rails-3Ruby on-Rails-3.2Rake

Next Solution:

Content falls beneath navigation bar when embedded in custom container view controller.

IosObjective CUinavigationbarIos7

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionschlingelView Question on Stackoverflow
Solution 1 - Sql ServerEhud GrandView Answer on Stackoverflow
Solution 2 - Sql ServerMohamed ElmoftyView Answer on Stackoverflow
Solution 3 - Sql ServerFAAView Answer on Stackoverflow
Solution 4 - Sql ServerPerrierView Answer on Stackoverflow
Solution 5 - Sql ServerRoyBSView Answer on Stackoverflow
Solution 6 - Sql ServerAkhil MView Answer on Stackoverflow