FEONA Posted July 10, 2013 Report Posted July 10, 2013 how to retrieve deleted data in SQL. Accidental ga kontha data delete ayindi?
cherlapalli_jailer Posted July 10, 2013 Report Posted July 10, 2013 There is a SQL thread is there u will get lot of info along with this Que
loveindia Posted July 10, 2013 Report Posted July 10, 2013 Is your database in full recovery mode?[list] [*] If yes, are you doing transaction log backups? [list] [*]If yes, do you have a backup utility like Quest LiteSpeed, Red Gate SQL Backup, or Idera SQLSafe? [list] [*]If yes, those utilities can undelete objects from backup files (including the fulls and transaction logs) - but explaining how to use those is beyond the scope of what I can do here. Contact the vendor for instructions. [*]If no, restore the full backup and transaction logs as a database with a different name. (Don't overwrite the existing database.) You'll be able to get an up-to-the-second copy of the object before the delete happened, but you'll need to use the stopat part of the restore command to specify when to stop restoring the commands. You need to stop before the delete happened. [/list][*]If no, go grab a copy of a log reader utility like Quest LiteSpeed or Apex SQL Log. These utilities can connect to the database server, examine the log file, and help you undo transactions. I'm not sure if the demo versions will work, but the paid ones definitely will. [/list][*] If no (not in full recovery mode), restore the last full backup as a database with a different name. (Don't overwrite the database you've already got.) From there, you'll be able to restore whatever records were online at the time of the backup, but you'll lose all of the changes since. [/list] Idi naa answer kaadu... but I follow same methods.. DBA's chestaaru if u need that backup help.. if you have all privileges then this will be easy for u... nenu raasina same answer raastanu so andukey copy paste chesanu... Pandaga chesko...
loveindia Posted July 10, 2013 Report Posted July 10, 2013 [quote name='cherlapalli_jailer' timestamp='1373484487' post='1303939226'] There is a SQL thread is there u will get lot of info along with this Que [/quote] this is calling thread for me man... wat man.. get out man..
Mustodi_2ndsetup Posted July 10, 2013 Report Posted July 10, 2013 [quote name='soldier' timestamp='1373484544' post='1303939230'] Ctrl+Z [/quote] [img]http://stream1.gifsoup.com/view5/2823143/brahmi-o.gif[/img]
cherlapalli_jailer Posted July 10, 2013 Report Posted July 10, 2013 [quote name='loveindia' timestamp='1373484553' post='1303939231'] this is calling thread for me man... wat man.. get out man.. [/quote]Subject thread clean ga vinchandi useful for others too. Punch punch punch
loveindia Posted July 10, 2013 Report Posted July 10, 2013 [quote name='cherlapalli_jailer' timestamp='1373484677' post='1303939242'] Subject thread clean ga vinchandi useful for others too. Punch punch punch [/quote] ori nee yeshaaalooooo... mamulu tima timalu kaadu raa babu ivi ... pedda bombai tima timalu...
cherlapalli_jailer Posted July 10, 2013 Report Posted July 10, 2013 [quote name='loveindia' timestamp='1373484758' post='1303939245'] ori nee yeshaaalooooo... mamulu tima timalu kaadu raa babu ivi ... pedda bombai tima timalu... [/quote]EvAru babu nuvvu. Theda ga vunnau. Sate. Noted
Nenunnanu Posted July 10, 2013 Report Posted July 10, 2013 Baasu.. Backup lekapothe govindha.. ekkuva try cheyaku
Cheeta Posted July 10, 2013 Report Posted July 10, 2013 [quote name='loveindia' timestamp='1373484518' post='1303939229'] Is your database in full recovery mode?[list] [*]If yes, are you doing transaction log backups? [list] [*]If yes, do you have a backup utility like Quest LiteSpeed, Red Gate SQL Backup, or Idera SQLSafe? [list] [*]If yes, those utilities can undelete objects from backup files (including the fulls and transaction logs) - but explaining how to use those is beyond the scope of what I can do here. Contact the vendor for instructions. [*]If no, restore the full backup and transaction logs as a database with a different name. (Don't overwrite the existing database.) You'll be able to get an up-to-the-second copy of the object before the delete happened, but you'll need to use the stopat part of the restore command to specify when to stop restoring the commands. You need to stop before the delete happened. [/list][*]If no, go grab a copy of a log reader utility like Quest LiteSpeed or Apex SQL Log. These utilities can connect to the database server, examine the log file, and help you undo transactions. I'm not sure if the demo versions will work, but the paid ones definitely will. [/list][*]If no (not in full recovery mode), restore the last full backup as a database with a different name. (Don't overwrite the database you've already got.) From there, you'll be able to restore whatever records were online at the time of the backup, but you'll lose all of the changes since. [/list] Idi naa answer kaadu... but I follow same methods..[b][color=#00ff00] DBA's chestaaru if u need that backup help[/color][/b].. if you have all privileges then this will be easy for u... nenu raasina same answer raastanu so andukey copy paste chesanu... Pandaga chesko... [/quote] DBA's can do this
Recommended Posts