BookmarkSubscribeRSS Feed
WouterG
Fluorite | Level 6

Hi All,

 

I  have a user that deleted a nummber of libnames from a server definition in EG.

We can recover the metadata from backup but that requires some user impact.

 

is there a way to find the deleted libnames in a log / audit file and manually recreate them  ?

 

Any help will be greatly appreciated.

 

 

6 REPLIES 6
RahulG
Barite | Level 11

I think you may find entries in the metadatserver log file of the day when library was deleted.

 

Go to below folder in your set up and find the relevnat logs. 

<SASHOME>/Config/Lev1/SASMeta/MetadataServer/Logs

 

JuanS_OCS
Amethyst | Level 16

Hi,

 

to be clearer, what @RahulG indicated is useful to know when the libraries have been deleted. If you find the date, and you have a metadata or server backup from that date, you can make a SAS export package from the metadata of that day, restore again the backup of the current date, and import the SAS package.

 

Another option,if you can find the libname definitions on the logs, as you mention, you can recreate them. This you can find most likely on the Workspace server logs, or on the Stored Process Log, or batch jobs, if you have them configured appropiately.

anja
SAS Employee

Hi,

 

which SAS version are you running on which OS?

 

Thanks

Anja

WouterG
Fluorite | Level 6
Hi

9.4 m3 on RHEL
anja
SAS Employee

Hi,

 

do you by any chance have the Environment Manager set up? i believe in the Report Center, there are reports

that you could use to find deleted tables, libraries and information on changes a user made.

 

Another more adventurous option is to restore to a test system and then move the missing data to the prod system.

Granted that your environment consists of a dev/test/prod environment.

With this, production would continue w/out effecting any users.

 

Thanks

Anja

 

 

WouterG
Fluorite | Level 6

Thank you all for ytour input. We had to restore eventually.

 

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1425 views
  • 0 likes
  • 4 in conversation