Can we restore a specific Data library from SAS Metadata Backup?

[Jyothi_Swaroop]

I have changed name of a Data library in SAS Metadata, after which the registered tables were not visible. Can we restore a specific library from SAS Metadata Backup ?

[LinusH]

Renaming a library should not make tables lose their connection. That is in the same environment.

But in promotion the problem a problem could occur. In this scenario I think you need to lift both library and table metadata.

Metadata restores are mainly for environment recovery, so if there have been other activities in the environment this might not be a good solution.

You can restore to new location, and then migrate metadata from there, but again you will run into the same problem described above.

My gut feeling is that changing back manually and try to align metadata per environment is the way to go.

[Jyothi_Swaroop]

Thanks for the response, but now the user is unable to connect to the Database by running the libname statement in SAS EG, not sure what is the exact issue.

[LinusH]

So what does the users log say?

options msglevel=i; might give some extra information.

[SASKiwi]

If you just want to back out that change, just do a metadata restore in SMC from a date before you made the change. This will drop all changes though made after that date and I'm not aware of any way to do a selective restore.

[Jyothi_Swaroop · Accepted solution]

Hello All,

thanks for your responses, I have found the issue. While creating the issue I have checked per assign option. So, unable to launch the SASApp server. After unchecking that option I am able to launch the SASApp server

[SASKiwi]

@Jyothi_Swaroop - Good to hear your problem is solved. Please update your post as answered in that case.