HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Unknown _TransactionIndex table in Azure SQL Database

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
unknownsql_transactionindexdatabaseazuretable

Problem

Just noticed today that there is a random table in my Azure SQL Database that is named "_TransactionIndex_{guid}"

It has 1 column, Id, that contains 8 GUIDs.

Couldn't find any information about this table - what is it? Does it mean that I have an issue with transactions within my application?

Solution

It's an internal table that is used during the import of a bacpac. If all is well it should be gone when the import is done. If it remains in the database the import wasn't completed successfully.

Context

StackExchange Database Administrators Q#60385, answer score: 6

Revisions (0)

No revisions yet.