InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:53:18 GMT20http://www.sqlservercentral.com/Forums/Topic536573-146-1.aspxProviding he had a backup, had the DB in full recovery and had an unbroken log chain, yes. However that's not a rollback (which is what the question asked)p.s. 2 year old thread.Thu, 09 Sep 2010 09:13:31 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic536573-146-1.aspx[quote][b]GilaMonster (7/18/2008)[/b][hr][quote][b]free_mascot (7/18/2008)[/b][hr]You can't recover deleted rows unless and untill you are using checkpoint. [/quote]Checkpoints happen automatically and just write dirty data pages to disk. It's BEGIN TRANSACTION that allows data modifications to be rolled back.[/quote]Hello Gail, you get about, don't you? :-DLet me ask you this; if he issues a Delete statement at 5pm, demolishing 50 rows in .05 seconds, could he not take a TLog backup at 5.05pm, and then do a point-in-time restore to 4.59Pm?Thu, 09 Sep 2010 09:06:16 GMTJake Sheltonhttp://www.sqlservercentral.com/Forums/Topic536573-146-1.aspx[quote][b]GilaMonster (7/18/2008)[/b][hr][quote][b]shiwani2002sg (7/18/2008)[/b][hr]if by chance i run a delete command ,n sme rows from some table get deleted ,then what is the command to rollback the command or immediate command. so that i can retrieve the deleted rows[/quote]Unless you started an explicit transaction before you ran the delete, there is no command that will retrieve the rows. You will have to locate a backup of the database.[/quote]If you need to revert to the backup, you may even want to explore some third party tools that allow you to do table and row level restore using the SQL Server backup. If the backup is older than you need, and you are desperate, you can also dig out a lot of information about the deleted rows from the transaction log.Regards, AndrasFri, 18 Jul 2008 05:13:51 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic536573-146-1.aspx[quote][b]free_mascot (7/18/2008)[/b][hr]You can't recover deleted rows unless and untill you are using checkpoint. [/quote]Checkpoints happen automatically and just write dirty data pages to disk. It's BEGIN TRANSACTION that allows data modifications to be rolled back.Fri, 18 Jul 2008 05:05:09 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic536573-146-1.aspx[quote][b]shiwani2002sg (7/18/2008)[/b][hr]if by chance i run a delete command ,n sme rows from some table get deleted ,then what is the command to rollback the command or immediate command. so that i can retrieve the deleted rows[/quote]Unless you started an explicit transaction before you ran the delete, there is no command that will retrieve the rows. You will have to locate a backup of the database.Fri, 18 Jul 2008 04:49:07 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic536573-146-1.aspxYou can't recover deleted rows unless and untill you are using checkpoint. To rollback checkpoint is must.Resoultion:1. You can restore the backup with stop at otion and extract the data. (Best Option)2. You can use 3rd party tool to read the log and find out more. Not sure howfar it will help?Fri, 18 Jul 2008 03:39:07 GMTfree_mascothttp://www.sqlservercentral.com/Forums/Topic536573-146-1.aspxGood Day,You can use the "BEGIN TRAN" and "COMMIT TRAN" OR if you need to rollback then just use "ROLLBACK"BEGIN TRANSACTION @TranName;GOUSE AdventureWorks;GODELETE FROM AdventureWorks.HumanResources.JobCandidate WHERE JobCandidateID = 13;GOCOMMIT TRANSACTION MyTransaction;GOThe Rollback syntaxROLLBACK { TRAN | TRANSACTION } [ transaction_name | @tran_name_variable | savepoint_name | @savepoint_variable ] [ ; ]Hope this helps youregardsStephenFri, 18 Jul 2008 03:38:49 GMTstephen.christiehttp://www.sqlservercentral.com/Forums/Topic536573-146-1.aspxif by chance i run a delete command ,n sme rows from some table get deleted ,then what is the command to rollback the command or immediate command. so that i can retrieve the deleted rowsFri, 18 Jul 2008 03:32:55 GMTshiwani2002sg