SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 how to get the data back
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ankita1091
Starting Member

USA
2 Posts

Posted - 02/14/2013 :  16:02:42  Show Profile  Reply with Quote
How can i get the data back which i have deleted from Management studio.
i am sorry i am new to this so please help me out.

Thanks in advance

ANKITA

James K
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 02/14/2013 :  16:07:53  Show Profile  Reply with Quote
It is a difficult thing at best, and impossible at worst. There are data recovery tools (google) that are commercially available that look through the log records and try to recover the data - I have no familiarity with them.

The script in this article may be helpful. I have not used this either, so not able to comment whether it is effective or not: http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-1/

But, the best course of action would be to restore the database if you have a current backup. You will lose the data/changes newer than the last backup or log backup.

Edited by - James K on 02/14/2013 16:08:45
Go to Top of Page

Ankita1091
Starting Member

USA
2 Posts

Posted - 02/14/2013 :  16:42:52  Show Profile  Reply with Quote
Thanks a lot James

ANKITA
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000