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.
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
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 ShawSQL Server MVP |
|
|
|
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=54300If you are NOT using transaction log backups you are fresh out of luck (apart from SQL Log readers and recovery specialists and $,000's ...) |
|
|
|
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 ShawSQL Server MVP |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-08-18 : 10:23:12
|
| Good point Gail. |
|
|
|
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 dataunspammed |
|
|
|
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 |
|
|
|
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 ShawSQL Server MVP |
|
|
|
|
|
|
Data Recovery In SQL Server