Thursday, March 3, 2011

SQL Server 2005 - Database won't backup translog

Issue: Everytime we try to backup the translog of one database it fails.

Solution: First we changed it from Simple to Full Recovery Model, Secondly we looked in the SQL Server's Log folder for a log from the backup attempt.  It contained this error "BACKUP LOG cannot be performed because there is no current database backup".  Come to find out, you have to perform a full backup, before it will let you back up the transaction log.