O'Reilly logo

SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Restoring a database to a point-in-time

In this recipe, we will use the different backup files which we have to restore to a point-in-time.

Getting ready

In this recipe, we will use the SampleDB database. The SampleDB database has a single filegroup that contains a single data file. We will restore this database to another SQL Server instance, and to a point-in-time using three different backup files from three different backup types:

  • Full backup
  • Differential backup
  • Transaction log backup

You can use the following script to create your files in B04525 - Ch05 - 10 - Restoring a Database to a Point in Time – Prep.ps1 (this is available in the code bundle available with the book), which is included in the downloadable files for this book. The prep file ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required