Review database powershell command

Question

Review database powershell command

sns 9,246

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

1 answer

Your answer

Answer 1

trevorseward 11,711

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

sns 9,246 Reputation points

2021-03-24T05:55:15.057+00:00

Hi Seward,

Although database name is there it not picking up. Please find attached screenshot

and I want to know status of db as "No action required" is there or not
Jerry Xu-MSFT 7,961 Reputation points

2021-03-25T09:21:37.337+00:00

HI, @sns ,

The parameter Name only works for SharePoint 2016 and 2019. You may need to use Identity to specify the database with its GUID.

Reference:https://learn.microsoft.com/en-us/powershell/module/sharepoint-server/get-spdatabase?view=sharepoint-ps

Share via

Review database powershell command

1 answer

Your answer