SQLserver has no rollback segment

[Former Member]

I am an Oracle admin.

I find out that SQL has no rollback segment.

Could you confirm this is true that SQL has no rollback segment?

If so, how does SQL deal with uncommitted transactions?

Thanks!

[clas_hortien · Accepted solution]

Hello,

in SQL Server all the rollback and roll forward information is stored in the transaction log (ldf File).

If a transaction has to roll back, the log is read from that point where the transaction starts and

all changes will revert.

Best regards

Clas