search

lowlydba / lowlydba.sqlserver

:spoon: A cross-platform Ansible collection using PowerShell to configure and maintain SQL Server.
https://galaxy.ansible.com/ui/repo/published/lowlydba/sqlserver
GNU General Public License v3.0
20 stars 12 forks source link

[Bug] lowlydba.sqlserver.database hardcoded OnlyAccessible value results in orphaned database for Availability Groups #198

Closed git-cgallagher closed 1 year ago

git-cgallagher commented 1 year ago

Describe the bug When deleting a DB that was just removed from an availability group, the database.ps1 module orphans the inaccessible database.

To Reproduce Add database to AG Remove database from AG Delete DB from both standalone DB hosts See orphaned database in restoring state

Expected behavior It is expected that the database will be deleted from both hosts, regardless of accessible state

Versions(please complete the following information):

Additional context Just need to add only_accessible as a valid parameter to the module