Backup detected log corruption in database Context is Bad Middle Sector.

Follow the following steps,


1. Stop all user activity in the database
2. Switch to the SIMPLE recovery model (breaking the log backup chain and removing the requirement that the damaged portion of log must be backed up)
3. Switch to the FULL recovery model
4. Take a full database backup (thus starting a new log backup chain)
5. Start taking log backups

http://www.sqlskills.com/BLOGS/PAUL/post/How-can-a-log-backup-fail-but-a-full-backup-succeed.aspx

SQL Server® 2008 R2 Service Pack

http://www.microsoft.com/download/en/details.aspx?id=26727

latest SQL Server 2000 service pack

http://support.microsoft.com/kb/290211

latest service pack for SQL Server 2005

http://support.microsoft.com/kb/913089

SQL Server 2008 SP2

•SQL Server 2008 SP2: http://go.microsoft.com/fwlink/?LinkId=196550



•SQL Server 2008 SP2 Express: http://go.microsoft.com/fwlink/?LinkId=196551


•SQL Server 2008 SP2 Feature Packs: http://go.microsoft.com/fwlink/?LinkId=202815


•SQL Server 2008 SP1 CU’s Released: http://support.microsoft.com/kb/970365


•Knowledge Base Article For Microsoft SQL Server 2008 SP2: http://support.microsoft.com/kb/2285068

Windows 7 and Windows Server 2008 R2 Service Pack

http://www.microsoft.com/download/en/details.aspx?id=5842

New T-SQL Features in SQL Server 2012

SQL Server 2012 has several major enhancements including a new look for SSMS. SSMS is now similar to Visual Studio with greatly improved Intellisense support. The main new TSQL features in SQL Server 2012 are:



WITH RESULT SETS


OFFSET AND FETCH


THROW in Error handling


SEQUENCE