SQL Server Performance

SQL Database restore

Discussion in 'SQL Server 2005 General DBA Questions' started by babusabus, Mar 30, 2011.

  1. babusabus New Member

    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
    Jack Rider likes this.
  2. jdgonzalez New Member

    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.
  3. satya Moderator

    Welcome to the forums.
    Is this a real problem or interview question?"
    YOu can restore database backup from 10:00PM and transaction log backup, then use the 12:00 AM program to insert those 1000 rows.
  4. prett New Member

    **Text removed, as it relates to advertisement
  5. GregoryBarrows New Member

    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.

Share This Page