Offsite Computer Backup - Help desk & Knowledgebase

Knowledgebase

. > Offsite Computer Backup - Help desk & Knowledgebase > Knowledgebase

» Category: MS SQL Server Related (Go back)

» Articles in this category:

ISSUE: The statement BACKUP LOG is not allowed while the recovery model is SIMPLE (MS SQL transaction log backup)

Summary: The recovery mode for SQL Server databases need to be in FULL mode. SIMPLE mode is not compatible. Applies to: OS: Windows Server 2000, Windows Server 2003, Windows Server 2008 Backup Set Type: MS SQL Server Backup Backup Manager version: 5.X.X.X Description: When performing a MS SQL transaction log backup, the following error message is received...