Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sql sever Recovery methods
- Thread starter ferortiz
- Start date
If your batch process uses transactions a rollback transaction executed on the same connection should work. If fact it if the batch process failed (and it wsa using transactions) it should have already rolled back. If not you are probably stuck restoring last nights backup and any tranaction log backups you have prior to the batch process starting. Also if it makes sense in your situation you might consider restoring the backup to a different database name and working to see what if anything is savable from your current databases and combining them. Obviously this is major surgery an wold depend on what data entry you were trying to save and if it was totally segregated from whatever the batch process munged.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
