Question on Metadata Server Backup Schedule

[kumarsandip975]

Hi Co's,

I would like to understand the difference between the Reorganize and day wise schedule metadata backup. 

[PaulHomes · Accepted solution]

Most daily metadata backups (without reorganization) have no downtime. Metadata backups with reorganization involve the metadata server going offline for a short time to do the reorganization work (purging logically deleted metadata objects that are taking up storage space). Because reorganization means some unavailability it is scheduled by default for Monday 1am (or overnight Sunday if you look at it another way) when the likelihood of anybody being affected is lower.

You can find out more in the documentation section "About the SAS Metadata Server Backup and Recovery Facility" and subsection  "About the Reorganize Repositories Backup Option" at https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/p16vd44w7smqlsn1a4eygd88gm6f.htm#n0pgxrqfbt5...   It includes the caution "The Reorganize Repositories option should be used only during times of little or no user activity. The metadata server is paused during the reorganization process, and any update transactions that are issued during this process will fail." and the note "The Reorganize Repositories option is ignored if it is used on a metadata server that has been started with clustering."