Book Image

Microsoft SharePoint 2013 Disaster Recovery Guide

By : Peter Ward
Book Image

Microsoft SharePoint 2013 Disaster Recovery Guide

By: Peter Ward

Overview of this book

Where does it all go wrong with disaster recovery? Yes, why a disaster recovery plan fails the business and costs IT staff their jobs or a promotion? This book is an easytounderstand guide that explains how to get it right and why it often goes wrong. Given that Microsoft's SharePoint platform has become a missioncritical application where business operations just cannot run without complete uptime of this technology, disaster recovery is one of the most important topics when it comes to SharePoint. Yet, support and an appropriate approach for this technology are still difficult to come by, and are often vulnerable to technical oversight and assumptions. Microsoft SharePoint 2013 Disaster Recovery Guide looks at SharePoint disaster recovery and breaks down the mystery and confusion that surrounds what is a vital activity to any technical deployment. This book provides a holistic approach with practical recipes that will help you to take advantage of the new 2013 functionality and cloud technologies. You will also learn how to plan, test, and deploy a disaster recovery environment using SharePoint, Windows Server, and SQL tools. We will also take a look at datasets and custom development. If you want to have an approach to disaster recovery that gives you peace of mind, then this is the book for you.
Table of Contents (19 chapters)
Microsoft SharePoint 2013 Disaster Recovery Guide
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
4
Virtual Environment Backup and Restore Procedures
Index

Point in time backup and restore


Every once in a while, an event might happen that corrupts a database and a database backup is required. If there is at least a complete database backup then the corrupted database is recoverable. However, if this backup is corrupted then a point in time restore is required.

Note

A point in time recovery is a method to recover a database to any point in time since the last database backup.

SQL Server has the ability to recover the data point in time from the last committed transition before the system crashed.

Incremental backups require the database to run on full recovery mode. This means that every transaction will be stored on the transactional logs and it must be backed up in order to be overwritten. Depending on the load, some transactional logs can grow up to 100 GB if they are not backed up frequently.

Point in time backup and restore can be performed with Management Studio and PowerShell.

Backing up DB in SQL Server Management Studio with SQL statements...