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 |
|
dhruvachandra
Starting Member
1 Post |
 Posted - 2009-09-04 : 10:50:01
|
| Hi,i have not taken the backup of my database and mistakely i have deleted a table's all data ,can any one please help me regarding this, can i restore the data of the table using the .ldf or the .mdf file.please help me in this regard at: dhruvamca@gmail.comthanks.dhruva chandra vishwakarma |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-04 : 12:21:19
|
| If you have never taken a backup of that database ever, then you're pretty unlikely to get anything back. Without a backup the transaction log is truncated on a regular basis (about every minute) and entries relating to old transactions are discarded.You can try downloading RedGate's SQL Log rescue and having a go at the transaction log with that, but the chances are slim.Why no backups?--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Data Recovery if back up not taken