Most companies store mission-critical information on their SQL Servers. If your data is important to you, it is imperative that you properly maintain your databases. Database maintenance generally includes backing up your database and auditing database access. It is also important that you understand how to restore a database in the case of a failure.
Backing Up Your Databases
Think of backing up your database like brushing your teeth. It is something that you don't think about; you just do it unequivocally each and every day, without exception! Four types of backups are available:
Full database backups— Back up the entire database and portions of the log.
Differential database backups— Back up data modified since the last ...