The statement BACKUP LOG is not allowed while the recovery model is SIMPLE

If you received this error message: "[Microsoft][ODBC SQL Server Driver][SQL Server]The statement BACKUP LOG is not allowed while the recovery model is SIMPLE"

You need to change the Recovery model to FULL. If you are using Microsoft SQL Server 7.0/2000, please refer to the following MSDN article:

1. http://msdn.microsoft.com/en-us/library/aa173678.aspx

Alternatively if you are using MSDE (Used by some desktop applications), please issue the following commands:
osql -E -S [Server Name] -Q "ALTER DATABASE [Database Name] SET RECOVERY FULL"

These will enable transaction logging option for your MSDE databases and allow incremental/differential backup to be run properly.

Was this answer helpful?

 Print this Article

Also Read

Expect log sequence 'xxx' but found '...\E000xxx.log'

"Expect log sequence 'xxx' but found 'SERVERNAME\Microsoft Information Store\First Storage...

CExBackup::backupFile:WriteFile: Error Number 0x6: The handle is invalid

If you see this error message: "CExBackup::backupFile:WriteFile: Error Number 0x6: The handle is...

An incremental backup cannot be performed when circular logging is enabled

If you get the following error message: "CExBackup::backupService:HrESEBackupSetup: Error Number...

The process cannot access the file because it is being used by another process

If you get the following error message: "The process cannot access the file because it is being...