How MSSQL handle cross database transaction in TRN files?

3 votes

1 answer

232 views

sql-server transaction-log distributed-transactions

                          I've a distributed transaction between two bases (let's call them *data* and *history*) (on the same server, so no MSDTC). I can't find any doc about how the transaction will be saved on both trn files and how it will link them forever. Can I restore *data* DB without *history*? Will it fail? What are the impacts?
                        

Asked by Thomas Ayoub (91 rep)

Jun 24, 2025, 01:30 PM
Last activity: Jun 24, 2025, 02:35 PM

How MSSQL handle cross database transaction in TRN files?

Related Questions