Chapter 12: Common Administration and Maintenance Tasks

Now that we have our models created and secured, we will wrap up the book with some maintenance and administration tasks that are common to database and Analysis Services solutions. We have some key topic areas to start the chapter, covering larger topics such as backups and scaling. The chapter wraps up with a section on several smaller topics to support your models as you move forward.

The tasks described in this chapter are key to making your SQL Server Analysis Services (SSAS) models production ready. Whether you need to plan for business continuity, expanding data needs, or better performance, the techniques you will learn in this chapter will provide the basic skills you need in order to manage production deployments.

In this chapter, we're going to cover the following main topics: 

• Understanding the languages
• Backing up and restoring SSAS databases
• Processing or refreshing the data in your...