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 |
|
alistair4267
Starting Member
10 Posts |
 Posted - 2008-09-01 : 05:56:44
|
| Hello just a quick question. If i have deleted the contents of a table and haven't taken a backup of it, is it possible to restore the contents of that table that i deleted ???so SQL 2005 have any sort of TombStone Restore like exchange 2003 does ?????regardsalistair |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-09-01 : 08:46:42
|
| Not without a backup.You might (emphasis might) be able to use a log recovery tool to recover deleted rows. I don't know if there's one for SQL 2005, they've not free and they're not guaranteed to work, especially if the DB is in simple recover model.--Gail ShawSQL Server MVP |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-01 : 09:07:09
|
quote:
Originally posted by alistair4267
Hello just a quick question. If i have deleted the contents of a table and haven't taken a backup of it, is it possible to restore the contents of that table that i deleted ???so SQL 2005 have any sort of TombStone Restore like exchange 2003 does ?????regardsalistair
Familiar road  Rule of thumb. Never use dynamic SQL and always backup |
|
|
|
alistair4267
Starting Member
10 Posts |
Posted - 2008-09-01 : 11:05:50
|
| Thanks for all your help i have decided to put this to rest for now. i have also setup a job to do a daily backup of our DB'sregardsalistair |
|
|
|
|
|
|
restoring a table after its been deleted.