In this recipe, we will use the different backup files which we have to restore to a point-in-time.
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:
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 ...