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.
No comments:
Post a Comment