question

sns1 avatar image
0 Votes"
sns1 asked JerryXu-MSFT commented

Review database powershell command

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


office-sharepoint-server-administration
capture.jpg (21.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

trevorseward avatar image
0 Votes"
trevorseward answered JerryXu-MSFT commented

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
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Seward,

Although database name is there it not picking up. Please find attached screenshot
81014-capture.jpg

and I want to know status of db as "No action required" is there or not

0 Votes 0 ·
capture.jpg (31.6 KiB)

HI, @sns1 ,

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://docs.microsoft.com/en-us/powershell/module/sharepoint-server/get-spdatabase?view=sharepoint-ps

0 Votes 0 ·