N
N
NNS2022-04-18 03:50:23
Database administration
NNS, 2022-04-18 03:50:23

Why is "Close existing connections" not active?

On some databases, through SQL Server Management, when trying to restore, the checkbox is not active:
625cb4bf6c312045096740.jpeg

And on other similar databases, it is active. Google says that it is necessary to install it, but not to say what to do when it cannot be installed, maybe some individual database setting.
As a workaround when restoring, I took the database offline (it was allowed to do this), then only performed a restore from the backup.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin Tsvetkov, 2022-04-18
@tsklab

Network enrichment showed tips from disabling some automatic operations to restarting the server.
But most of all: enable this action before selecting a source, after which it will become unavailable, but remain enabled.
Other options .

H
hint000, 2022-04-18
@hint000

It is customary to make inactive functions or options that do not make sense in a particular situation.
For example, there can be no connections to a database if the database is offline . Since there can be no connections, then there is nothing to close. Since there is nothing to close, the checkbox is made inactive.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question