SQL Database restore

Hi Experts,

I am facing a critical issue which is related to data recovery.

10:00 PM-- Database full Backup-- Completed

10:30 PM--- Tlog backup 1--completed

11:00 PM---by mistake User deleted 100 rows

11:30 PM--Tlog backup 2 ---completed

12:00 AM ---inserted 1000 rows using DTS package

12:15 Am --User reported to DBA for the cause of deletion

How to recover the data? Can you please provide the steps and scripts?

Thanks,
paul

You'll have to restore the full backup first followed by the first tlog backup and a restore of tlog backup 2. The with recovery will leave the database in a state where you can restore the rest of the log. The last one will be set to recovery which will leave it in functional form.It'll be something like:restore database myDatabasefrom disk = '>'with norecoveryrestore log myDatabasefrom disk = '>'with norecovery, stopat = 'Mar 31 2011 11:00pm'restore log myDatabasefrom disk = >'with recovery, stopat = 'Mar 31 2011 11:00pm'Check out BOL if you need some specific examples.

**Text removed, as it relates to advertisement

Recover sql database data help you sql database recovery System Tables and User Tables, Stored Procedures, Views, User Defined Data Types and Functions. It works with big databases more than 16TB. Application doesn't modify source database file during restoration.