Managing Database Operations for SharePoint

Database operations for SharePoint can include a wide variety of tasks, perhaps more database and database server–related tasks than you might consider for a SharePoint administrator. However, all of the content consumed in SharePoint is stored in databases, and to ensure the smooth operation of your environment, you must be able to manage and monitor the databases you rely upon.

Administering Database Operations

Although this might sound like you are being turned into a database administrator (DBA) instead of a SharePoint administrator, you aren’t actually responsible for managing all database operations. You do have a responsibility to manage those aspects of the database that have a direct impact on SharePoint operations, including monitoring the health of the database. You also need to be able to add database content, move site collections from one database to another, and, if necessary, manage a server farm using a read-only content database.