Backup & Recovery CYA
May 21, 2019, 5:30pm
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.
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.
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.