3
votes
3answers
726 views

SQL Server transaction log BACKUPS are very large

In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model. The problem is that the backup files for ...
1
vote
0answers
1k views

How do deal with SQL Server transaction log corruption

We had a failure with our SQL Server log shipping job. sp_readerrorlog reported: Backup detected log corruption in database X. Context is Bad Middle Sector. LogFile: 2 'D:\Database\X_log.MDF' VLF ...
7
votes
1answer
190 views

Does a failed full backup invalidate future transaction log backups?

I have a server running SQL Server 2005. I have nightly full backups, with transaction log backups every 15 minutes. This is a relatively small server so I am not doing any differential backups. If ...