“Several times a week I’m asked for advice on how to effectively maintain a production [SQL Server] database. Sometimes the questions come from DBAs who are implementing new solutions and want help fine-tuning maintenance practices to fit their new databases’ characteristics. More frequently, however, the questions come from people who are not professional DBAs but for one reason or another have been given ownership of and responsibility for a [SQL Server] database. I like to call this role the “involuntary DBA.” The focus of this article is to provide a primer of database maintenance best-practices for all the involuntary DBAs out there.”
Note: I added [SQL Server] as appropriate.