Solved

sql data undelete or restore

Posted on 2011-03-01
2
269 Views
Last Modified: 2012-08-13
For some reason all the data from a file was deleted. Can you undelete data from a datafile once deleted? The file size is 11 gigs for the mdf and ldf. When I do a backup it's only 2 gig. The data must still be there. Need some help with this one.
0
Comment
Question by:goldmineexpert
2 Comments
 
LVL 15

Accepted Solution

by:
derekkromm earned 250 total points
ID: 35010866
Any transactions will be logged in the transaction log.

Check out this product: http://www.red-gate.com/products/dba/sql-log-rescue/

You should be able to get a 30 day free trial (fully functional) and is very easy to use.
0
 
LVL 2

Assisted Solution

by:niaz
niaz earned 250 total points
ID: 35011015
I presume you don't have a  backup at all. If you do have a full backup before deletion then you can use transaction logs to recover till the time the data was lost. Please see the article below for more detail concepts.

http://searchsqlserver.techtarget.com/tip/Recover-lost-SQL-Server-data

0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Update in Sql 7 30
select over clause 1 40
INSERT DATE FROM STRING COLUMN 18 50
Parsing out characters on the right side of hyphen 3 23
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Facing problems with you memory card? Cannot access your memory card? All stored data, images, videos are lost? If these are your questions...than this small article might help you out in retrieving your lost or inaccessible data.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now