There was a need when I had to get the list of sharepoint databases present on a shared SQL server instance.
Below PowerShell Command helps to reduce the work in searching the databases individually. We need to go to the Sharepoint Management Shell and run the below powershell command -
Get-SPDatabase | Select Name | Out-File c:\AllActiveSPDBs.txt
The text file will be created automatically if it doesn't exist.
Also you can go and validate the same from Central Administration as well by following the path
Central Administration --> Upgrade and Migration --> Review Database Status
Below PowerShell Command helps to reduce the work in searching the databases individually. We need to go to the Sharepoint Management Shell and run the below powershell command -
Get-SPDatabase | Select Name | Out-File c:\AllActiveSPDBs.txt
The text file will be created automatically if it doesn't exist.
Also you can go and validate the same from Central Administration as well by following the path
Central Administration --> Upgrade and Migration --> Review Database Status
No comments:
Post a Comment