Understanding backups is extremely important for every database administrator (DBA)—it can make or break your career. If you need to restore a database, you can be a hero in a matter of minutes. Conversely, if you don’t have a good backup to restore, you may end up looking for a new job. In our opinion, having the knowledge to properly back up and restore a database is the most important skill a DBA can possess. That being said, we think backing up a database is often the most easily overlooked process. It’s easy to set up a maintenance plan or backup job and think you are covered—a kind of set-it-and-forget-it mentality. The problem with this attitude is that you do not know a backup is being performed incorrectly until you need to use it, which is not the best time to find out. There are several backup options available in SQL Server 2012 that you should master to ensure you do not find yourself explaining why you cannot restore a database everyone thought was being backed up.
KeywordsRecovery Model Backup Statement Differential Base Backup Operation Backup Device
Unable to display preview. Download preview PDF.