Review database powershell command

sns 9,241 Reputation points
2021-03-22T10:13:44.687+00:00

when I click on review databases under updgrade and migration in CA, it is taking longer time to load and eventually time out messaged popped up.
Please let me know why it is happening?
and do we have powershell command to review the contentdatabase of all 80130-capture.jpg

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,993 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. trevorseward 11,711 Reputation points
    2021-03-22T18:41:44.223+00:00

    The equivalent PoSh would be:

    Get-SPDatabase | select NormalizedDataSource,DisplayName,TypeName,Status
    

    To get the detailed status of a particular content database, run:

    $database = Get-SPDatabase -Name DatabaseName
    $database | select Server,DisplayName,Status,IsReadOnly,SchemaVersionXml,FailoverServiceInstance,WarningSiteCount,MaximumSiteCount,PreferredTimerServiceInstance
    

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.