# rubrik\_sql\_live\_mount

## rubrik\_sql\_live\_mount

Live Mount a mssql database from a specified recovery point i.e. data and time. `Requirement: Rubrik Python SDK (pip install rubrik_cdm)`

## Example

```yaml
- rubrik_sql_live_mount:
    db_name: 'AdventureWorks2016'
    date: '08-26-2018'
    time: '12:11 AM'
    sql_instance: 'MSSQLSERVER'
    sql_host: 'sql.rubrikdemo.com'
    mount_name: 'AdventureWorksClone'
```

## Arugments

### Common

| Name       | Description                                                                                                                                                                                                                                                                                                  | Default |
| ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------- |
| node\_ip   | The DNS hostname or IP address of the Rubrik cluster. By defeault, the module will attempt to read this value from the rubrik\_cdm\_node\_ip environment variable. If this environment variable is not present it will need to be manually specified here or in the \`provider' parameter.                   |         |
| password   | The password used to authenticate the connection to the Rubrik cluster. By defeault, the module will attempt to read this value from the rubrik\_cdm\_password environment variable. If this environment variable is not present it will need to be manually specified here or in the \`provider' parameter. |         |
| username   | The username used to authenticate the connection to the Rubrik cluster. By defeault, the module will attempt to read this value from the rubrik\_cdm\_username environment variable. If this environment variable is not present it will need to be manually specified here or in the \`provider' parameter. |         |
| api\_token | The api token used to authenticate the connection to the Rubrik cluster. By defeault, the module will attempt to read this value from the rubrik\_cdm\_token environment variable. If this environment variable is not present it will need to be manually specified here or in the \`provider' parameter.   |         |
| provider   | Convenience method that allows all connection arguments (`node_ip',`username', \`password') to be passed as a dict object. By default, the module will attempt to read these parameters from the rubrik\_cdm\_node\_ip, rubrik\_cdm\_username, and rubrik\_cdm\_password environment variables.              |         |

| Note: The `username` and `password` must be supplied together and may not be provided if the `api_token` variable is present |
| ---------------------------------------------------------------------------------------------------------------------------- |

### Module Specific

| Name          | Description                                                                                                  | Default | Type | Choices | Mandatory | Aliases |
| ------------- | ------------------------------------------------------------------------------------------------------------ | ------- | ---- | ------- | --------- | ------- |
| db\_name      | The name of the database to Live Mount.                                                                      |         | str  |         | true      |         |
| date          | The recovery\_point date you wish to Live Mount formated as `Month-Day-Year` (ex: 1-15-2014).                |         | str  |         | true      |         |
| time          | The recovery\_point time you wish to Live Mount formated as `Hour:Minute AM/PM` (ex: 1:30 AM).               |         | str  |         | true      |         |
| sql\_instance | The SQL instance name with the database you wish to Live Mount.                                              | None    | str  |         | true      |         |
| sql\_host     | The SQL Host of the database/instance to Live Mount.                                                         | None    | str  |         | true      |         |
| mount\_name   | The name given to the Live Mounted database i.e. AdventureWorksClone.                                        | None    | str  |         | true      |         |
| timeout       | The number of seconds to wait to establish a connection the Rubrik cluster before returning a timeout error. | 30      | int  |         | false     |         |

## Return Values

| Name     | Description                                          | Returned | Type | Aliases |
| -------- | ---------------------------------------------------- | -------- | ---- | ------- |
| response | The full response of `POST /v1/mssql/db/{id}/mount`. | success  | dict |         |
