Backing Up Databases

Sometimes your job as a DBA may seem like all you are doing is verifying that backups are running successfully and restoring testing environments with those backups. This is definitely an important task for the system DBA, and backups are key to providing a secure and reliable database environment.

Backup Strategies

As a DBA, no matter which database platform you are administering, you need to plan a backup strategy that makes recovery a simple process and fits the needs of the business. There are several strategies for backing up databases, depending on resources, the importance of the data, and if it is needed for recovery and running the business.

For SQL Server databases, creating maintenance plans sets up some backup ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.