none
How can I Determine Which Database is the Search Admin Database RRS feed

  • Question

  • Hello All,

    Quick question. How can I determine which database is the Search Admin Database.

    Mike


    SharePoint Engineer - Mike

    Tuesday, October 1, 2019 3:52 PM

Answers

  • Hi Mike, 

    Are you working in SharePoint 2010? (the following method also works in 2013/2016/2019.)

    Navigate to CA->Application Management->Manage service applications->click search service application->You can find Search administration database:

    Best Regards,

    Lisa Chen 


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Wednesday, October 2, 2019 2:43 AM
    Moderator

All replies

  • https://sharepoint.stackexchange.com/questions/200753/find-out-which-sharepoint-server-is-using-the-databases

    From any SharePoint server run the below command, it will tell you on about every database is being used in the farm.

    Get-SPDatabase | Select displayname, NormalizedDataSource, Type

    Or go Central admin > Upgrade and migration > Review Database Status on this page, you will get list of database being used in SharePoint along with Sql Server information.

    Couple of things to try to nail it down.

    Run the below script, which will tell you any active connection with login name.

     SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
    loginame as LoginName
    FROM sys.sysprocesses
    WHERE dbid > 0
    GROUP BY dbid, loginame

    Now if you run the below built in store proc then you will see from which server it is being connected.

    exec sp_who
    exec sp_who2

    Please remember to click Mark as Answer on the answer if it helps you

    Tuesday, October 1, 2019 4:50 PM
  • Hi Mike, 

    Are you working in SharePoint 2010? (the following method also works in 2013/2016/2019.)

    Navigate to CA->Application Management->Manage service applications->click search service application->You can find Search administration database:

    Best Regards,

    Lisa Chen 


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Wednesday, October 2, 2019 2:43 AM
    Moderator
  • Hi Mike, 

    If a reply helps you, please remember to mark it as an answer.

    Thanks for your understanding. 

    Best Regards, 

    Lisa Chen 

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Monday, October 7, 2019 2:55 AM
    Moderator
  • Hi Mike, 

    Please remember to mark the helpful post as an answer.

    Thanks for your understanding. 

    Best Regards, 

    Lisa Chen 

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Thursday, October 10, 2019 8:56 AM
    Moderator