O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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

Database Restores

Database backups are like insurance policies—you have backups in case something bad happens, but you hope that you never need to use your backups. In the event you need to recover a database, SQL Server has several options that can be used to allow you to utilize your full, differential, transaction log, and/or filegroup backups to recover the maximum amount of data possible.

All restore sequences begin with either a full or filegroup backup. When restoring backups, you have the option to terminate the restore process at any point in time and make the database available for transactions. Once the database or filegroup being restored has been brought online, you can’t apply any additional differential or transaction log backups ...

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