PowerShell evening event with Rob Sewell and Stuart Moore


Stuart Moore on Automating SQL Server Backups, Restores and verifications with PowerShell

Rob Sewell on his box of Powershell tricks



Automating SQL Server Backups, Restores and verifications with PowerShell
SQL Server makes it simple to automate backups with jobs and maintenance, but doesn't provide a simple method to schedule test restores to prove the backups have worked. Using PowerShell we can write simple scripts that allow us to automate test restores from our SQL backups, and then check that the restored database is valid, consistent and usable. This session will introduce you to the basics of restoring simple databases with PowerShell scripts, and then extending this to cope with more complex situations including data file relocation, point in time restores and running DBCC checks against the restored database

PowerShell Box Of Tricks

The life of a SQL Server DBA is a busy one. A fount of all knowledge, the SQL Server DBA is often interrupted with small questions and routine tasks. This session will show you some functions that you can use to save time spent on this and hopefully inspire SQL DBAs to explore PowerShell further by showing how easy it is to explore SQL Server properties with it.


Stuart started working with SQL Server 7 in 1999, having spent the intervening years working up through the versions as with time spent as both a DBA and a Developer. Now firmly in the DBA camp and busily automating as much as possible.


Rob is a SQL Server DBA currently supporting several hundred databases ranging from SQL 2000 to SQL 2012 and including Ingres and Oracle for a government organisation. Rob has a fabulous beard and loves to use Powershell to make his life easier.

Join or login to comment.

  • Rhiannon R.

    Thanks both! V interesting.

    October 3, 2013

  • Rob S.

    Thankyou for having me at your User Group. I had a great evening.


    1 · October 2, 2013

  • Stuart M.

    I'll be covering Automating SQL Server backups, restores and verification with PowerShell.

    Looking forward to it.

    September 3, 2013

12 went

Our Sponsors

  • Pluralsight

    Free 30day passes and able to show vids at the UG/SQLLunch

  • O'Reilly

    Book discounts - use DSUG at the checkout for up to 50% off

  • PASS

    Content, deals, and whatever else they'll give us

Create your own Meetup Group

Get started Learn more

I started the group because there wasn't any other type of group like this. I've met some great folks in the group who have become close friends and have also met some amazing business owners.

Bill, started New York City Gay Craft Beer Lovers

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy