Hi,

I am an Oracle developer and new to SqlServer. Is there rollback
segment in SqlServer? If there is, does it use only for the purpose
of rollback or to maintain read consistency as well?

If there is no rbs in SqlServer. How does it handle rollback and read
consistency?

Thanks!
Susan

Hi Susan,

SQL Server's transaction logs have combined function of Oracle
rollback segment and Oracle online redo log. When you create SQL
Server database you need to specify at least one physical file as
transaction log for each database (please note that meaning of common
terms like "database" for example, is different with Oracle and SQL
Server).

Automatic recovery mechanism is the same.

Hope this helps.

Sinisa

susana73@hotmail.com (Susan Lam) wrote in message news:<7186ed56.0308102350.21f3d005@posting.google. com>...
> Hi,
>
> I am an Oracle developer and new to SqlServer. Is there rollback
> segment in SqlServer? If there is, does it use only for the purpose
> of rollback or to maintain read consistency as well?
>
> If there is no rbs in SqlServer. How does it handle rollback and read
> consistency?
>
> Thanks!
> Susan