Administering a Data Warehouse
Administering a data warehouse is both similar to and different from administering an online transaction processing (OLTP) system. It is similar in that data warehouse data is stored and maintained in a relational database, so the tools used to administer relational databases can be used with data warehouses. It is different in that OLTP systems are generally characterized by high-volume transaction updates to volatile data, whereas data warehouses are generally characterized by massive amounts of stable historical data. These differences call for different approaches to data warehouse administrative tasks such as backing up data and automating recurring tasks.
See Also
Administering SQL Server Overview
Administering Analysis Services