topic Re: Can we restore a specific Data library from SAS Metadata Backup? in Administration and Deployment

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

Jyothi_Swaroop — Mon, 21 Feb 2022 01:10:27 GMT

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 ?

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

LinusH — Mon, 21 Feb 2022 08:23:45 GMT

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.

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

SASKiwi — Mon, 21 Feb 2022 20:09:59 GMT

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.

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

Jyothi_Swaroop — Tue, 22 Feb 2022 07:21:55 GMT

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.

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

LinusH — Tue, 22 Feb 2022 09:27:14 GMT

So what does the users log say?

options msglevel=i; might give some extra information.

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

Jyothi_Swaroop — Sun, 24 Apr 2022 06:50:04 GMT

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

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

SASKiwi — Sun, 24 Apr 2022 23:08:38 GMT

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