Solved

sql data undelete or restore

Posted on 2011-03-01
2
271 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server - Sum Decimal Columns 11 33
Help Required 3 94
Better way to make a query with date filter. 5 23
ms sql + get number in list out of total 7 26
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.
Employees depend heavily on their PCs, and new threats like ransomware make it even more critical to protect their important data.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

776 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