| Author |
Topic |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
 Posted - 2005-07-22 : 08:08:36
|
| I did a search and couldn't find a tread on this question.During a DTS , I accidentally deleted some existing tables/data.I do not have a backup . Is it possible to recover this lost data .By the way , this db has the simple Recovery Model |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-22 : 08:42:56
|
| I have never used it, but you would'nt by chance be storing your packages in Meta Data Services. Otherwise, sorry.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2005-07-22 : 08:54:27
|
| The problem here is about - certain deleted records . I appreciate your point about backups - but my specific question is:if you have deleted records and you haven't got a backup , then is it possible to recover for the existing log file ?This problem is just as relevant if there was a backup, but the deletes happened after the backup |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-22 : 09:28:46
|
| simple recovery only holds stuff in the log until it written to the db if I am not mistaken. The backups stuff is in my signature.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-22 : 09:55:27
|
| With Simple Recovery model the db can be recovered to the point of the last backup.You cannot restore the db to the point of failure or to a specific point in time. To do that, you need to choose Full Recovery or Bulk-Logged Recovery model.Even Log Explorer from Lumigent (http://www.lumigent.com/) can't recover if the db is in simply recovery model.Franco |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-22 : 10:07:42
|
| franco,he already stated he does not have a backup.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-22 : 10:13:39
|
| In fact my post was just to clarify your doubt about the meaning of a simply recovery model.Franco |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-22 : 10:20:31
|
| I just do not see the correlation. I never made any point about the ability to restore a database from backup in simple recovery. This ought to be obvious. My point was he was hoping to read from the log but the log entries do not hang out very long when you are in simple recovery. Dig?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-07-22 : 12:17:15
|
mac, maybe you ought to alter your signature so the style doesn't look like your post. There have been many misunderstandings because of it.jackv, you are hosed. The very first thing you should do as a DBA is to ensure that you are getting backups and that you can actually recover your databases. Also, think about implementing a test environment that is totally separate from your production environment. Hopefully this is not an important system. If it is, well i guess you ought to polish up your resume as best as you can.  -ec |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-22 : 12:38:20
|
| signature fixed====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
|
restore deleted records