SQL Server Restore w/o "Closing Existing Connections" By default in SSMS (2012/2014) when you choose to restore a database, the "close existing connections" option located in the  
is by default unchecked, is it possible to restore a database while maintaining a connection to it (i.e. in an Enterprise Edition)? If not, why have this option (besides as a sanity check), if so? How?
No, the option is there for you so that you can decide to either:


Kick all users out right now and restore immediately; or,
let the restore operation wait until it can get exclusive access to the
database before it begins. 


You can't restore and keep connections active, sorry. This is like changing the keg without interrupting someone actively pouring a beer...