Free SQL Server Training!
Join us for the January 2016 meeting of MagicPASS, South Orlando's SQL Server User Group. Food and beverages will be served, plus we've got swag to give away!
This month we welcome Orlando's own Andy Warren to present Automating Database Restores
After the meeting we'll head to the Celebration Town Tavern for more socializing. (You are responsible for your own drinks)
Make a difference in someone's career: Invite them to attend the meeting with you! (Heck, invite them to attend even if you can't make it)
Automating Database Restores
Speaker: Andy Warren
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 the latest version of the system I use, one consisting of a couple of tables and a couple of Powershell scripts. I'll start with my design goals, show you some of the compromises I made to get to a solution that handles 90% or so of the requests, and some of the options I thought about but decided against. I used Powershell, but it's a pattern you could solve using another language, even perhaps TSQL!.
About Andy: 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.