Restoring a SQL Server Database Using Transaction Log Backups

It may not be often, but it will happen - you'll need to do a point in time restore of a database. If you've done your preparations well, doing a full backup and log backups on a good schedule, the restore is the easy part. Restoring a database using log backups just builds on the skills you've already learned doing a restore from a full database backup.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

yeskay on 7/8/2010

super.. thanks a lot

Raju on 7/13/2010

good learned some thing

Poonam Rane on 7/13/2010

Excellent description!!

Don Gilman on 7/13/2010

Good point on the Copy issue. Might do a separate series on file locations and organization in light, medium and heavy duty (but non-cluster) installations.

Don Weigend on 7/13/2010

It would be nice to see what the script looks like when doing this kind of restore. Or what is needed to do a point in time recovery from one server to another.

kevin on 7/13/2010

The title signaled that they would be restoring from transaction logs. I was under the impression that they would walk through the restore from a physical file or set of files. In this example, they just restored a copy of a database from another database. Not a very real world/disaser recovery situation.

Mohamed Irshad on 7/15/2010

very good. thank you.

Rob Wingate on 7/16/2010

Andy always delivers.

Catto on 7/20/2010

Good Vid!

tayyeb on 9/17/2010

thank you so much for neat explanation :)