O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Backup and Restore

You might be surprised to see this topic addressed so early in the book. We’ve chosen to place it here to help you avoid the unpleasant surprises that we saw occur with a couple of our customers. These scenarios revolve around backups that either aren’t running regularly, backups that aren’t run at all, those that are incomplete, and, worst of all, those that are unrestorable. The time to begin regular backup routines for your BI project is immediately after your development environment is set up.

As with the security solution setup for BI, backup scenarios require that you consider backup across all the tiers you’ve chosen to install in your development environment. At a minimum, that will usually consist of SSAS, SSIS, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required