Planning for Disaster Recovery for PowerPivot Mid-Tier Server

Every experienced DBA is familiar with the software equivalent of "Murphy's Law" and the notion that if something can go wrong, it will. We all know that hardware can and does fail. Now that I think about it, that's where I first became acquainted with the term "mean time between failures." As a result, bad things can occasionally happen to good databases and it's usually at a very inopportune time. That probably explains why, as a group, we tend to be real concerned with having something that resembles a well-designed and tested plan for backing up and restoring databases after a disaster. It's not terribly surprising that most of us are reasonably familiar with the SQL Server Recovery Models and the implications of each for disaster recovery. Analysis Services ships with SQL Server, which probably explains why we're administering this type of server in addition to the relational database servers. Like any other database, it can fall victim to hardware failures, corruption, fire, flood, pesky rodents or other issues that make one or more databases inaccessible.