• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Database Maintenance

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:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint