var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Undo mechanism
I know that Oracle uses undo table spaces or rollback segments as its undo mechanism. what does Microsoft SQL Server use as its undo mechanism?
Nothing. SQL Server DBAs do not make mistakes. Only Oracl DBAs make mistakes.
Oh, all right. The transaction log. Modifications to the data are written to a transaction log before being committed to the database.
Do you have a link online that I can have a look at that explains Microsoft SQL Server's undo mechanism in detail? And maybe some issues with this mechanism?
Just check out Books Online, installed with Microsoft Server.
Originally Posted by krz
Are you talking about the redo logs? Which is what the sql server transaction logs afre...
Never heard of UNDO in Oracle before...what version?
There is no sql server equivilant...you have to restore to a point in time
Until you supply the COMMIT or ROLLBACK the transaction is stillactive and the changes are not applied...