Re: global synchronization point

horos11@xxxxxxxxx pisze:
[...]
I'm not thinking of the transaction begin/commit/rollback cycle, I'm
thinking of it truly globally - where users could do multiple commits
and rollbacks, and then do a global rollback to a given point of time.

In oracle, I believe this is done through transaction logs; how do you
set up this in sybase?

Hi,
If you perform database+transaction log dumps for your database
you can 'rollback' the state of database loading database from
the last db dump and loading transactions up to a specified time
(i.e. using 'until_time' option). I'm not an expert but I think
it would work.


(ps - how do you get the version of sybase that you are running
against via isql? I see in my case the binary is old (1999) but I'm
assuming that the database itself is a lot newer..)


For ASE servers, @@verion is a server-wide, global variable that
contains version information.
>select @@version
>go

Regards,

--
Marcin Najs
.

Relevant Pages

  • Re: Question on Transactions for Allen Browne
    ... Did you BeginTrans on the WorkSpace? ... Or did you BeginTrans on the Database? ... I was trying to troubleshoot an issue I was having with a Transaction, ... The problem I was having was an error 3034 when trying to Rollback a failed ...
    (microsoft.public.access.formscoding)
  • Re: Scope of transaction processing wrapper
    ... Just pass the Database variable, and it will all rollback. ... This article illustrates transactions: ... My question is on the scope of what transaction ...
    (comp.databases.ms-access)
  • Re: Calling BeginTrans without Commit / RollBack
    ... That is correct, rollback is guaranteed ... > locks acquired by the transaction. ... >> Will there be any negative impact on the database if one ... >> commit/rollback commands, e.g. a sudden blackout. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Calling BeginTrans without Commit / RollBack
    ... > rights.Please do not send email directly to this alias. ... >> think sql server should rollback the transaction itself and release any ... >> locks acquired by the transaction. ... >> left on the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help - Timing Logic
    ... server application, both of which ran on the same box. ... the client applications and 'lodging' them in the database. ... Another part of the server application was dedicated to retrieving messages ... commit transaction ...
    (microsoft.public.dotnet.languages.vb)