on 08-05-2010 3:24 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.