SQL Server Backup and Restore by Shawn Mcgehee

SQL Server Backup and Restore by Shawn Mcgehee

The duties and responsibilitie: s of a Database Administrator (DBA) make for long and dynamically changing list, ranging from offering query tuning advice, to cutting stored procedures, all the way through to system process design and implementation for high availability. A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. This means that if a database, for whatever reason, gets corrupted, dropped, or otherwise becomes unusable, then it is the DBA's responsibility to restore that database to the state it was in before the problem occurred, or as close as is possible. Of course, this doesn't mean that a DBA is required to restore a database each and every day, just that if disaster does strike the DBA must be prepared to deal with it, regardless of when or why it occurs. If a DBA isn't prepared, and significant data is lost, or databases become unavailable to end users for long periods of time, then that DBA probably won't be in their job for too long.This is why a good, and tested, SQL Server backup and restore plan must be on the top of every administrative DBA's list of tasks. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Capturing backups using SMS or simple scripts is perfectly fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated and you'll also want to build in some checks that, for example, alert the responsible DBA immediately if a problem arises. The tool of choice in this book for backup automation is Red Gate SQL Backup. Building your own automated solution will take a lot of work, but we do offer some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs

Brian K. McDonald, MCDBA, MCSD, is a business intelligence and data warehouse geek working for Acosta, the top sales and marketing company in the US. Brian was born and raised in Cincinnati, Ohio but he currently lives in Jacksonville, Florida with his beautiful wife and his two little ninja's; Bailey and Kylie. As an independent consultant, Brian has experiences in architecting data warehouses, data modeling, database administration, SQL Server Reporting Services, Integration Services, and Analysis Services. He has worked as an application developer, network administrator, and database administrator throughout his 12 years in the IT industry. A characteristic groomed while serving his country in the United States Marine Corps, Brian takes pride in all his projects and diligently works to not only meet expectations, but greatly exceed them. Brian has written for many industry websites and continually strives to improve his skill-set both professionally and personally. Brian is an active member of his local SQL Server User's Group and has presented for user groups, Code Camps and many SQL Saturday events in the southeast U.S. When not working, Brian enjoys geeking out with his wife Sherri and allowing his children to practice their UFC style moves on him.

SKU	Nicht verfügbar
ISBN 13	9781906434861
ISBN 10	1906434867
Titel	SQL Server Backup and Restore
Autor	Shawn Mcgehee
Buchzustand	Nicht verfügbar
Bindungsart	Paperback
Verlag	Simple Talk Publishing
Erscheinungsjahr	2012-05-14
Seitenanzahl	408
Hinweis auf dem Einband	Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.
Hinweis	Nicht verfügbar