Vh dZdZdZy)a: --- module: database short_description: Creates and configures a database description: - Adds a new database to an existing SQL Server instance. version_added: 0.1.0 options: database: description: - Name of the target database. type: str required: true recovery_model: description: - Choose the recovery model for the database. type: str required: false choices: ['Full', 'Simple', 'BulkLogged'] data_file_path: description: - Directory where the data files should be placed. Uses SQL Server's default if not supplied. - Only used if database is being created. type: str required: false log_file_path: description: - Directory where the log files should be placed. Uses SQL Server's default if not supplied. - Only used if database is being created. type: str required: false owner: description: - Database owner login. type: str required: false maxdop: description: - MAXDOP value for the database. required: false type: int secondary_maxdop: description: - MAXDOP value for the database when it is a non-primary replica in an availability group. required: false type: int compatibility: description: - Compatibility mode for the database. Follows the format of C(Version90), C(Version100), and so on. - String is validated by C(Set-DbaDbCompatibility). required: false type: str rcsi: description: - Whether or not to enable Read Committed Snapshot Isolation. required: false type: bool only_accessible: description: - Whether or not to enable Read Committed Snapshot Isolation. default: true required: false type: bool version_added: '2.2.0' author: "John McCall (@lowlydba)" requirements: - L(dbatools,https://www.powershellgallery.com/packages/dbatools/) PowerShell module extends_documentation_fragment: - lowlydba.sqlserver.sql_credentials - lowlydba.sqlserver.attributes.check_mode - lowlydba.sqlserver.attributes.platform_all - lowlydba.sqlserver.state a) - name: Create database lowlydba.sqlserver.database: sql_instance: sql-01.myco.io database: LowlyDB - name: Create database with customizations lowlydba.sqlserver.database: sql_instance: sql-01.myco.io database: LowlyDB owner: sa maxdop: 2 recovery_model: Simple z data: description: Modified output from the C(New-DbaDatabase), C(Set-DbaDatabase), or C(Remove-DbaDatabase) function. returned: success, but not in check_mode. type: dict N) DOCUMENTATIONEXAMPLESRETURNo/home/dcms/DCMS/lib/python3.12/site-packages/ansible_collections/lowlydba/sqlserver/plugins/modules/database.pyrsH T  r