Free SQL Server Training!
Join us for the April 19, 2015 meeting of the Pinellas SQL User Group.
Summary: Beginning DBA's think of a RESTORE as something that gets done when something goes wrong. In practice we restore all the time, perhaps most often to refresh our QA and Development environments. Doing one restore isn't hard, but what about when you get five or ten requests a day? It's not just the restore either, you have to alter permissions, change the recovery model, set the database owner, perhaps update synonyms or mask out sensitive data. Restores are a pattern and if we see the pattern, we can do things to make it faster and repeatable. This presentation will show you one way to do it; a table driven design with two jobs that will get the latest backup, restore it, and then apply a configurable set of post-restore options. I'll show you the code and talk to you about some of the design decisions, mistakes, and trade-offs that we made.
About: Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
Food and drinks will be provided