Next Meeting: Wed, Sep 16 2015
JSSUG Monthly Meeting - September 16, 2015
Event Type: In-Person
Online Meeting URL: None
Monthly user group meeting
UTC : Wed, Sep 16 2015 22:00 - 00:00
Event Time : Wed, Sep 16 2015 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Wed, Sep 16 2015 22:00 - 00:00
3105 Beach Blvd
Avoiding, Detecting, and Repairing SQL Server Database Corruption
Andy Warren, President SQLAndy
This presentation will discuss how to avoid, detect, and repair database corruption - the kinds of problems that can happen due to a bad shutdown due to a power outage or a bad storage drive or controller. Some of the topics we'll cover include page verify settings, backup with checksum, the right way to shutdown your instance, how to check for corruption, and the basics of repairing corruption. Corruption doesn't happen often, but knowing what to do (and what NOT to do) can save you a lot of time and energy if it does happen to one of your databases.
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.