Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Data Recovery In SQL Server

Author  Topic 

Noushadkh
Starting Member

1 Post

Posted - 2011-08-18 : 03:52:16
Please help me....
I accidentally deleted the data from table with out "where" close. How to restore the same with the help of SQL Log file.

Thank you for your valuable suggestions in advance..

Help not a lost. It is always our asset.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-18 : 04:27:58
do you have a backup of databse stored?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-08-18 : 08:13:52
Log recovery tools cost at least $1000. Got that much budget?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-08-18 : 09:44:28
If you are using transaction log backups:

Take a log backup (if one has not been done since the accident)
Restore - to a new, temporary, database and NOT to the current database! - the most recent full backup, followed by most recent differential backup [if you have one] and then all TLog backups [from the differential if you have one, otherwise from the full backup] upto a point just before the accident (using the STOPAT option of the restore command)

Copy back the missing rows from the table in the restored database to your main database's table.

Overview of the Restore commands is here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300


If you are NOT using transaction log backups you are fresh out of luck (apart from SQL Log readers and recovery specialists and $,000's ...)
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-08-18 : 10:18:24
If he's not using log backups then he can do the same with the last full backup and just restore to the time of the last backup. Probably will lose some data, but better than nothing.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-08-18 : 10:23:12
Good point Gail.
Go to Top of Page

alicesmith
Starting Member

1 Post

Posted - 2011-09-08 : 01:07:08
If you accidentally deleted data from SQL table you may use available backup to restore lost data.Stellar SQL Recovery software application helps you to recover lost data

unspammed
Go to Top of Page

manju3606
Yak Posting Veteran

78 Posts

Posted - 2011-09-08 : 16:22:54
Hi Gail,

If he have only full backup and he don't have any log and diff back up. Then he can restore full back up with stop at command ?



Manju
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-09-08 : 17:04:26
No. Stop at is only for log backup. (It's a valid option on a full backup, SQL just ignores it as a full backup can only restore to one time - the time it finished)

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -