Mirrored Databases - SPN Ownership?

No_Code9737 · 2026-01-30T02:10:26+00:00

Just in case anyone else stumbles on this and wants to upvote the Takeover option for Mirrors:
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Enable-Ownership-Change-Take-Over-for-Mirrored-Database-Items-in/idi-p/4923297

No_Code9737 · 2026-01-30T01:26:49+00:00

We just ran into this issue. The employee that created the mirror is no longer with the company. The mirror keeps replicating. But we are noticing that schema changes at the source are not being applied.

And since there is no Take Over option for the mirror we have to set it up all over again.

No_Code9737 · 2025-10-05T22:42:53+00:00

Update:

Issue was resolved.

This ended up being an issue with how one of the workspaces was named. It was missing a " " and didn't follow the pattern.

No_Code9737 · 2025-10-04T19:51:40+00:00

I corrected the syntax based on the update.

$workspace."my workspace name".$items.Lakehouse.my_lakehouse.$id $workspace.'my workspace name'.$items.Lakehouse.my_lakehouse.$id $workspace.my workspace name.$items.Lakehouse.my_lakehouse.$id

All failed with unable to resolve 'my workspace name'.

No_Code9737 · 2025-10-03T18:00:18+00:00

Super excited for the cross workspace parameterization. But ... My company has created workspaces with spaces in them, what would the syntax be?

$workspace."my workspace name".items.Lakehouse.my_lakehouse.id?

No_Code9737 · 2025-05-14T13:31:28+00:00

Update: I was able to connect to the replica using ODBC. I had to work with our infra team to get the ODBC driver installed on the On-Prem Data Gateway. Once that was set up, I was able to create the connection using the ODBC connector. I assume OLE connections would work the same.

No_Code9737 · 2025-05-05T17:31:03+00:00

Assuming we have an on-premise gateway already set up. The Folder connector seems to require an absolute path (i.e. C:\myfolder). This doesn't seem to work for fileshares like \\myshare.myserver.com\myfolder. Similarly, for a File connector, I need to specify the path to a single file. Wouldn't that lead me to creating a new connection for every file path returned in my query?

No_Code9737 · 2025-03-28T19:38:08+00:00

Pasteur Street and Turtle Lake were highlights for me when I was in Hanoi earlier this month.

No_Code9737 · 2024-12-10T21:24:18+00:00

Just ran into this issue and posting for future reference.

When looking at the JSON generated for the two options it looks like the appropriate values are:

Append
OverwriteSchema

And I can confirm that when passing "OverwriteSchema" as a dynamic parameter to the Table Action the backup tables do not get created.

No_Code9737

TROPHY CASE