O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required