Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How can we recover the deleted data

Author  Topic 

boreddy
Posting Yak Master

172 Posts

Posted - 2011-03-21 : 02:11:09
Hi Experts

we deleted some of the data in my database(one table data)

is this possible to recover the deletedd data ?
if there is any chance pls reply

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-03-21 : 05:34:28
Restore a backup from before the data was deleted.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

boreddy
Posting Yak Master

172 Posts

Posted - 2011-03-21 : 05:48:07
I dont have the back up


is it possible throw Log file
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-03-21 : 06:53:33
Then the data is gone.
I do hope that's not a production database with no backups. But then even a dev DB should be getting backed up if there's anything of value in it.

There's a tool that might (not likely since there's no backup) be able to read the log file. Apex SQL Log. It retails for around $1000.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

mimran18
Starting Member

4 Posts

Posted - 2011-10-31 : 16:06:53
http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/
Go to Top of Page
   

- Advertisement -