This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 12%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EON%3C/text%3E%3C/svg%3E)
Hellow! We have more than 10 bases "offline". They will be disabled for a few more months. SQL still speaks to them every minute. This creates
unnecessary load on the server. How to disable scanning of databases "offline"?
SQL still speaks to them every minute
I don't understand what you mean with this, may can you explain it more detailed, please?
If you take a database offline, then SQL Server don't do anything further with that database. It's only keeps the database basic informations like name and files.
Hi @Olga Nazarova ,
Sorry, I can't understand your issue.
> How to disable scanning of databases "offline"?
Could you please explain that how SQL server scan the database? This will help us to understand your issue.
When the database is in offline state, the database is unavailable. So what did you real mean with you say the SQL still speaking to offline databases?
We are transferring databases offline. In the sql and windows event log, we observe every minute a check of the availability of disconnected databases.
...
Login failed for user ".." Reason: Could not open explicitly specified database "base 1..n"
time
The databases are disconnected, but the database server user checks the connection 1-2 times a minute.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
That is likely coming from an application, not SQL Server itself, unless you have a SQL Agent job which runs every minute. Check the IP address of the invalid login to determine the host.
Hi @Olga Nazarova ,
Agree with Tom. Did you have any SQL server agent job that need to access the offline database frequently? Or did you have any application that use these offline databases?
If you get more related error message from event log, please share them to us.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
I think you are right. I will check the thought..
Hi @Olga Nazarova ,
Thanks for your reply. Did the issue resolved? If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread. Your contribution is highly appreciated.