DataManagementEngineer.com

My Expertise is Your Solution

Skill No.2 - Backup and Restore Databases

Skill2_Backup.jpg

A correct backup strategy helps ensure that you incur minimal or no data loss. Developing this correct backup strategy is probably the most important task you will have as a database administrator. Do not make assumptions about what your organization requires, but instead engage the relevant stakeholders within your organization.

We would like to introduce you to the SQL Server and Oracle backup component. Backing up your database is essential for protecting your data.

back up [verb]
Copies the data or log records from a database or its transaction log to a backup device, such as a disk, to create a data backup or log backup.

backup [noun]
A copy of data that can be used to restore and recover the data after a failure. A backup of SQL Server data is created at the level of a database or one or more of its files or filegroups. Table-level backups cannot be created. In addition to data backups, the full recovery model requires creating backups of the transaction log.

Join me to configure and start from scratch how to do it in SQL Server and Oracle.

Backup Overview (SQL Server) - SQL Server | Microsoft Docs

Orange Splash

Jairo Alberto Suarez Carrillo - System Engineer - Database Specialist