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

[Former Member]

Hi Laura,

SQL server by default is in Auto commit mode. Every transaction is committed unless it has error, it will rollback. The default mode can be overridden by the transactions.

Please follow these links to have for insight about how transactions work in sql server:

[http://msdn.microsoft.com/en-us/library/ms187878.aspx]