Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By : Donabel Santos
Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By: Donabel Santos

Overview of this book

Table of Contents (21 chapters)
SQL Server 2014 with PowerShell v5 Cookbook
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 5. Backup and Restore

In this chapter, we will cover:

  • Changing database recovery model

  • Checking last backup date

  • Creating a backup device

  • Listing backup header and file list information

  • Creating a full back up

  • Creating a backup on mirrored media sets

  • Creating a differential backup

  • Creating a transaction log backup

  • Creating a filegroup backup

  • Restoring a database to a point in time

  • Performing an online piecemeal restore

  • Backing up database to Azure Blob storage

  • Restoring database from Azure Blob storage