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