Database Backups for the Accidental DBA
Backups and Restores for the Accidental DBA: You've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. We'll introduce the Backup & Restore GUI, including new functionality with SQL Server 2012, as well as TSQL statements. We'll go over how to automate the process through the SQL Agent. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session.
Sorry, there are no downloads available for this session.
Grant Fritchey, SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG). He earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.
The video is not available to view online.