Display All SharePoint Databases
Scenario/Problem: You need to obtain a service application reference and therefore need a listing of available service applications.
Solution: Use the Get-SPDatabase cmdlet with the ServerInstance parameter to retrieve all available databases.
To obtain a database reference object, you need to find the identity of the database. Using the Get-SPDatabase cmdlet with the ServerInstance parameter (see Listing 7.1) displays all available databases, as shown in Figure 7.1.
Figure 7.1. The Get-SPDatabase -ServerInstance cmdlet displays all databases on the SQL Server.
You need to pass in the SQL Server instance to ...
Get PowerShell™ for SharePoint® 2013 How-To now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
