O'Reilly logo

SQL Server 2012 with PowerShell V3 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 we have to restore to a point in time.

Getting ready

In this recipe, we will use the AdventureWorks2008R2 database. You can also substitute this with your preferred database on your development environment.

The AdventureWorks2008R2 database has a single filegroup that contains a single datafile. We will restore this database to another SQL Server instance at a different point in time using three different backup files from three different backup types:

  • Full backup
  • Differential backup
  • Transaction log backup

We can create these three types of backups on the AdventureWorks2008R2 database using PowerShell as illustrated in previous recipes. If you are fairly comfortable ...

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