Database Maintenance Tips
Have you been given the role of Database Administrator but you are not a professional DBA? I have found this to be a common situation, and if you answered yes you are not alone. When a person is put in the role of DBA when it is not his/her area of expertise troubles can arise, but effective database management can be learned. I found a wonderful article published by TechNet Magazine that offers top tips for effective database maintenance. There areas covered in this article are:
- Data and log file management
- Index Fragmentation
- Statistics
- Corruption detection
- Backups
While this article is a generic overview of database maintenance, the areas covered are key to almost all DBA's. Read Database Maintenance Tips.
-Brianna