O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

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

Chapter 2. Implementing Clustering

One fine morning, Mr. Young, who is an IT Manager at XY Incorporation, received a call from his office, asking him to rush to the office immediately, as the database server that the office uses as their production database had crashed.

Mr. Young reached the office and started restoring data from the last full database backup, followed by the incremental backup, and then Transaction log backup to recover all data lost to the point. SQL Server allows taking backups of transaction logs if the SQL Server Engine can read transaction log files, and this type of Transaction log backup is known as Tail Log backup. When Mr. Young tried to take a Tail Log backup, the log file was so corrupt that he could not take a Tail ...

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