Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
SQL Server 2014 Backup and Recovery Paperback – September 30, 2014
|New from||Used from|
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
On time, as described, perfect condition.
I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.
This book aims to give you a strong understanding of SQL Server’s backup and restore functionality, how does it fare?
This is a short book, consisting of around 150 pages, divided into 11 chapters. This book is aimed at the beginner or mid-level DBA, and assumes only some basic T-SQL skills.
Backup and recovery are the most important topics for many DBAs, so it’s paramount to have an excellent understanding of them. Being involved in a recovery after a crash can be a stressful event, so it makes sense to learn and practise the subject under less troublesome circumstances (ideally using an up-to-date step-by-step document that anyone with an understanding of SQL Server could implement).
Below is a chapter-by-chapter exploration of the topics covered.
Chapter 1 SQL Server Database Files
This chapter opens with at look at the underlying files that make up a SQL Server database i.e. a primary data file (.MDF), zero or more secondary data files (.NDF), and a log file (.LDF). Data is stored in 8K pages, and 8 pages make up an extent.
The chapter then discusses, in outline, the different types of backup:
*Full – backup of the whole database
*Differential – backup of the data changed since the last full backup
*Copy – backup of the whole database, without interfering with the backup strategy
*Transaction log – backup of transactions since the last transaction log backup
Each chapter ends with useful summary, points to ponder, and review quiz sections. There are useful diagrams and links to other chapters in the book.
I had problems with several aspects of this chapter, which is unfortunate because the rest of the book mostly doesn’t have these problems. Problems included:
*Uses terms before they are defined, including unnecessary material, some awkward analogies, and some bad logic/arguments
*p11 talks about moving a row from the leads table to the customer table, later p26 suggests a row in the leads table can convert from ‘new’ to ‘customer’ (in leads table) - this information is unnecessarily confusing, it would be better to omit it
*Giving a File Backup as a type of SQL Server backup, this is confusing, and unnecessary
Maybe it would have been better to stick to the point, but don’t be put off, the remainder of the book is clearer.
This book aims to give you a strong understanding of SQL Server’s backup and restore functionality. It is generally: easy to read, has useful step-by-step walkthroughs, helpful diagrams, and good links between chapters. The end of each chapter contains a helpful summary, points to ponder, and a review quiz. Much of the material is applicable to earlier versions of SQL Server too. The book is relatively cheap in price, so cost should not be a consideration in understanding this important topic.
This small book contains good base material, but much more information could have been provided, especially if you want a strong understanding. The book reads much better if you already know the subject matter. Parts of Chapter 1 should be rewritten.
Overall, this is an instructive overview of SQL Server’s backup and restore options, a very important topic.