Brad M. McGehee is the Director of DBA Education for Red Gate Software and is an accomplished Microsoft SQL Server MVP with over 16 years SQL Server experience. Brad is a frequent speaker at SQL PASS, European PASS, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, and SQL Server user groups, where he shares his 16 years&rsquo; cumulative knowledge and experience.
Back From the Dead: How to Restore a SQL Server in 60 Minutes or Less
In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance.
While most DBAs know how to perform backups, restoring an entire SQL Server instance under the pressure of having to get the server up and running as soon as possible, is often another story. In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance. By learning how to perform a quick server restore, not only will your manager and users be happier, you will feel a lot less stress when you are under the gun. This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use the BACKUP and RESTORE commands. This session is most appropriate for DBAs who manage databases less than 100GB in size.