i have managed to construct two sql servers each with their own elastic pools
i then create a failover group
as i add databases to the first server and include it in the failover group then all is well
but when i try to delete the database it can not remove it from the secondary server as it was not created by terraform but my microsoft failover.
I understand the documentation makes mention of this and that i should ‘create the resource if i want terraform to manage it’ butwithout an example I dont really understand what it wants me to do.
Has anyone else done this and could they explain what they want me to do to manage databases in failover groups through terraform alone?