01-09-2013 03:00 AM
I have mistakenly executed one data step that updated one of the permanent tables. Can anybody tell me is there any way to restore the data sets with the earlier version??
I will highly appreciate if anybody comesback with a quick and fast solution..
01-09-2013 04:01 AM
Assuming that you can't programmatically restore the tables to it's previous state, there are just a few thing that can help you:
01-09-2013 11:48 AM
I guess IT support always has physical backup for all your server drive (D:\, E:\ whatever) and retention for daily physical content also should be there. you can use their help...
01-09-2013 12:44 PM
In future you may want to add ACCESS=READONLY to your libname statements.
Or you can add ALTER or WRITE passwords to the data set you don't want to change.