Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

roll back

2 posts in Windows NT Last posting was on 2000-06-06 17:37:29.0Z
Jimmy Nie Posted on 2000-06-06 09:55:14.0Z
Reply-To: "jimmy Nie" <jimmy_nie@163.net>
From: "jimmy Nie" <jimmy_nie@163.net>
Subject: roll back
Date: Tue, 6 Jun 2000 17:55:14 +0800
Lines: 15
Organization: Benefit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <o4DbW25z$GA.299@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 202.109.255.172
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2054
Article PK: 1089508

Sybase 11.0.1


After I execute a delete command , I found I just made a mistake ,I delete
records in another table, How can I roll back these records.

(I execute the Sql in Win ISQL)

Thanks In advance)

Jimmy Nie


Rob Verschoor Posted on 2000-06-06 17:37:29.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <o4DbW25z$GA.299@forums.sybase.com>
Subject: Re: roll back
Date: Tue, 6 Jun 2000 19:37:29 +0200
Lines: 44
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <bmUNGB#z$GA.86@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i0627.pvu.euronet.nl 194.134.166.117
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2051
Article PK: 1089512


> After I execute a delete command , I found I just made a mistake ,I
delete
> records in another table, How can I roll back these records.
>
> (I execute the Sql in Win ISQL)
>
> Thanks In advance)
>
> Jimmy Nie
>

You cannot roll this back, unless you did a "begin tran" first. If you
just issued a delete (i.e. without a transaction around it) then the
following simple rule applies: deleted == deleted (and gone ==
gone...). So basically, if this is what happened, start feeling sorry
now...
For completeness, if you make proper transaction log dumps (and you
still have the database dump to start with), you could dump the log
and reload the dump with the "until_time" option; when you set this to
just a little before the time when you started your delete, it might
get you your data back (though other transaction in your database
might not be as you expect it).

Wrapping up, I hope you make regular backups so you can restore
yesterday's data...

Good luck,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Associate DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl
WWW http://www.euronet.nl/~syp_rob
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------