Share via

disable "offline" database scanning

Olga Nazarova 1 Reputation point
2021-12-14T10:40:04.98+00:00

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 Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,263 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,246 Reputation points
    2021-12-14T12:15:32.097+00:00

    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.

    0 comments
  2. CathyJi-MSFT 21,131 Reputation points Microsoft Vendor
    2021-12-15T03:23:15.06+00:00

    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?

    0 comments
  3. Olga Nazarova 1 Reputation point
    2021-12-15T12:36:53.887+00:00

    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
    157840-image.png

    The databases are disconnected, but the database server user checks the connection 1-2 times a minute.

  4. CathyJi-MSFT 21,131 Reputation points Microsoft Vendor
    2021-12-16T06:41:12.95+00:00

    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".

    0 comments
  5. Olga Nazarova 1 Reputation point
    2021-12-16T09:24:36.787+00:00

    I think you are right. I will check the thought..