May 21, 2019 – Backup & Recovery CYA with PowerShell

Matt Anderson

Backup & Recovery CYA

May 21, 2019, 5:30pm

Matt Anderson

Target Audience: DBAs, Developers, or anyone who is responsible for SQL database backups.

Do you practice restores on a regular basis, but others in your organization do not? Are you worried that a restore may not be complete?

As a DBA you are responsible for much more than simply backup and recovery of databases. This session will go over how to backup some SQL Server objects like Alerts, DBMail, LinkedServers, SQL Agent properties, and others with PowerShell.

I have not always trusted others to be able to restore a machine. This talk walks through how to CYA in the event of an emergency by backing up SQL objects other than just the databases.

Speaker Bio

Matt is a new speaker and Microsoft SQL Server DBA with almost 10 years experience. He has managed databases for healthcare, manufacturing, and entertainment companies on traditional DBA teams and on BI teams.

Presentation Materials

Available on Matt’s GitHub

Important meeting information:

We meet at the offices of Wayfair, upstairs from the Copley Place Mall, at 4 Copley Place, Boston.

Due to building security at our meeting venue, attendees must be registered, and must present a valid photo ID to building security. Directions to the Wayfair offices can be found here.

Typical Meeting Format:

5:30pm – 6:00pm — food / beverages, networking and group discussion

6:00pm – 6:15pm — news, announcements, upcoming training opportunities

6:15pm – 7:30pm — guest speaker presentation … we keep it flexible. Some speakers will talk longer or shorter than others.


Each attendee must RSVP separately so that we have your name for the building security list.