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.

Răspunsul a fost util?

 Tipărire

V-ar mai putea interesa și

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...