The Get-SqlDatabases
command returns a list of SQL databases from the specified protected machine.
Usage
The usage for the command is as follows:
Get-SqlDatabases -core [host name] -user [user name] -password [password] -protectedserver [server name or IP address]
Command Options
The following table describes the options available for the Get-
SqlDatabases
command:
Option | Description |
---|---|
-? |
Display this help message. |
-core |
Optional. Remote Core host machine IP address (with an optional port number). By default the connection is made to the Core installed on the local machine. |
-user |
Optional. User name for the remote Core host machine. If you specify a user name, you also have to provide a password.
If none are provided, then the logged-on user's credentials will be used. |
-password |
Optional. Password to the remote Core host machine. If you specify a password, you also have to provide a log on.
If none are provided, then the logged-on user's credentials will be used. |
-protectedserver |
Show jobs for a specific protected machine, indicated by IP address. |
Example:
Lists all SQL databases jobs on the local Core:
>Get-SqlDatabases -protectedserver 10.10.10.10