02-08-2016 12:42 AM
We want to have a full environment backup for our SAS Environment which includes below products.
So Can any one guide me on this topic, thanks in advance.
02-08-2016 01:03 AM
Backing up your SAS server environment is best done with server backup tools like Comvault.
The best approach is to do a complete server backup of all drives with software installed (eg C and D drives if on Windows) across all of your SAS servers: metadata, compute, mid-tier etc.
02-08-2016 03:54 AM
As @LinusH has explained IT departments use backup tools for making copies of file systems in case there is a storage failure or some other problem that requires files to be restored from backup. You need to talk to your organisation's IT backup people to find out what is available at your site.
By taking backups of all of a server's disks you can then ensure that the server can be re-built should a major hardware or software problem happen.
A backup of a SAS server does not need to be treated as different to any other type of server.
If you have more specific questions, please post them.
02-08-2016 02:37 AM
02-08-2016 04:16 AM
We are more concern with our SAS Metadata, Let say my server got crashed and have to install SAS from scratch so The inbuilt backup of SAS Metadata will be usefull to have my SAS Environment back?
02-08-2016 09:09 AM
With a proper backup, should never need to reinstall SAS from scratch (unless you have it installed on some old server where there are no spare parts to require).
With metadata backup in place, you still need a file system backup, since the metadata server backup is just "files" in the file system.
I suggest that you read the documentation carefully, and plan the backup strategy with key stakeholders/service personnel.
02-08-2016 05:18 PM
what version of SAS are you using? Depending on the version and maintenance release, there are different
options for backing up your environment.
Generally speaking, it is very important that, when you use any OS or third party backup tools, you stop the SAS services - Metadata Server!! - to make sure that all data kept in memory are being flushed to disk! Once the Metadata Server is stopped, make sure that the metadata server backup location (default is something like \\Lev1\SASMeta\MetadataServer\Backupxxx) is included in the OS or third party backup. This is the most important thing!!! (see "How Metadata Server Works" for more details: http://support.sas.com/documentation/cdl/en/bisag/68240/HTML/default/viewer.htm#p1jsr78x5kda05n1fc7p...
If you do run os backups without having the Metadata Server stopped, all data that is being stored in memory, will be lost and not recoverable!
If you do run SAS 9.4, the following info will be helpful: http://support.sas.com/documentation/cdl/en/bisag/68240/HTML/default/viewer.htm#p1u29z4y7j3spvn1gaqz...
Are you looking for a backup plan solely, meaning, restoring in case something goes wrong, or, are you thinking about failover/high availabilty?
02-10-2016 11:29 AM
I believe you have a SAS 9.4 installation, since you mention SAS Studio between your components installed.
Keep in mind what anja mentions, and the link she provides: http://support.sas.com/documentation/cdl/en/bisag/68240/HTML/default/viewer.htm#p1u29z4y7j3spvn1gaqz...
Still,as an alternative and as anja mentioned, if 24/7 service is not a requirement, you can always make a full backup (or snapshot if you are on a virtual server) when all your SAS services, Platform Computing services and SAS batches are stopped. and nobody has a table locked.
05-06-2016 12:25 PM
Yes, this documentation exists but the problem is, this backup will not be useful from my perspective if you are unable to bring your SAS Servers up and running due to corrupt config or any other bad installation and configuration related reasons. You need to have a healthy SAS environment to recover something from the backup mentioned in this SAS documentation.
This backup might be more useful when a developer or user deletes some metadata object (table, report etc) by mistake.
But there has to be a plan to take the backup at the OS or file system level as other also mentioned in this thread. I was going to post a new thread but found this one relevant and here is my post.
All - Please advise.
Hello SAS Administrators,
If you are a SAS Administrator on Windows Server operating system, I am pretty sure you would have encountered the 200 characters Windows directory path limit problem while taking the backup of SASHome or SASConfig directories (mostly the SASConfig directory on the middle/web tier machine that has light-year-lengthy directory paths that stubbornly deny to get copied) whenever you intended to update, upgrade, hotfix your SAS environment.
Another problem you might have encountered is the symbolic links in SASHome directory, if you copy and paste them, they become an actual Windows directory with the same name. You have to use maklink.exe to recreate the symbolic links.
So, if you intend to take the backup of SASHome and SASConfig directories by copying and pasting them to some location, this does not work.
My organization uses Tivoli Storage Manager to take "incremental" backup of the servers, but let me tell you this did not help me when I had to recover SASHome and SASConfig from this backup once.
I might have taken the “clone” of *.vmdk or *.vhd file if I had a Virtualized SAS Environment, but fortunately/unfortunately I have been dealing with physical machines.
So, my question to you all is, do we have any better backup strategy for the backup of overall SAS installation that is sitting on a physical server/machine? Or migrating to a virtualized environment is the only way to go?
Thanks and regards,
05-06-2016 04:40 PM
I am not sure yet which version of SAS you have there.I also don't know if you really require a 24/7 SAS service or you can allow yourself some downtime. And I don't know how. Muchrhe size of the data you need to backup.
In any case, I understand you are dealing with physical servers, therefore no VM snapshots there.
It is also very important if you can understand, that SAS is no different to other systems, backup wise.
What you need to ensure is, each time you have a backup, is a consistent one. Eg, you cannot backup a file that is currently in use, or you should not do a backup in the middle of an ETL process. Therefore you need either a time window to backup and/or plan a very good sync process, which is a great option, specially on volume clusters, RAID, etc
And of course a simple copy might not be a good idea, specially under Windows, but the you have great tools as Robocopy and others. I feel confident your company already uses a great tool and processes for backups.