Backups
Although not necessary for performance, database backups taken on a routine schedule are crucial to the safety, integrity, and security of your system. Not only do database backups protect you from data loss in the event of system failure, they also protect you in the case of data corruption. Database backups are typically scheduled and handled by the database administrator, but it should also be the responsibility of the geodatabase administrator to ensure that this process is in place and carried through.
Just as important as taking the backups, is to routinely, yet randomly, test your database backups. This entails restoring backups to a different SQL Server instance to ensure that the backups are valid and current. This also keeps ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access