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 |
vijram711
Starting Member
1 Post |
Posted - 2013-01-20 : 23:40:10
|
How to recover the deleted record? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-21 : 00:10:47
|
http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-21 : 10:49:20
|
keep in mind This technique completes the recovery on the basis of log data if the data is available in the log .So it's possible, it's available for awhile but disappears. so if there are certain restrictions on growth and Simple Recovery - then recovering may not be possibleJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-22 : 10:07:58
|
if its not in log, then only way is to restore the last available backup------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-22 : 10:07:58
|
if its not in log, then only way is to restore the last available backup------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-23 : 06:44:24
|
Ensure your backup strategy reflects the accpetable levels of data loss for the organisation.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|