Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

Accidentially deleted rows in one table on one MS SQL database

We accidentally deleted 10,000 valid rows from one table in our MS SQL 2008 database.  We have a current Backup Exec backup.  How can I restore these rows to the one table?  I can't do a full restore of the entire database because there has been activity on to other tables in the database today.  Note no new rows have been added to the table that had the accidental rows deleted for the last week.

Thanks In Advance
0
chasmx1
Asked:
chasmx1
1 Solution
 
sachitjainCommented:
If your backup is taken through Litespeed then it has got options to support restore of single table but I am afraid SQL Server intrinsic backup feature does not provide this option as per my knowledge. The only solution left for you is to restore the whole db in some other SQL instance if possible and link that with your current SQL instance through linked server and pull all lost records from desired table.
0
 
chasmx1Author Commented:
We used Symantec Backup Exec 2010 with the SQL Agent.
0
 
sachitjainCommented:
I have personally no idea about Symantec Backup Exec 2010 but following link suggests that with this also its not possible to restore a single table.

http://www.symantec.com/connect/forums/restoring-single-table-sql
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree with above: you have to restore the full database, and "recover" the table data from there.
0
 
Ramesh Babu VavillaCommented:
i suggest you to restore the old db with diffrent name on the same server , use some where condotion to extract missing rows from the old db
0
 
nedysCommented:
Hi. Before all operations BACKUP live database and test the scenario on testing environment.

Here is my solution:
- Restore backup to new database named "restore" etc.
- Use "Export data..." from restored database to live database

Inside the "Export data..." wizard use this steps:
- Select restored database as "Data Source" and live database as "Destination"
- Select "Write a query to specify the data to transfer"
- Write query to SELECT all deleted rows in the table
- Set "Destination" to table where data was deleted, click "Edit Mappings..." and select "Enable identity insert"
- "Run immediately" -> Finish
- Check "Success" and check if deleted rows is now in the live database

When all looks fine, use the same scenario on really live database.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now