Knowledgebase

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.

Add to Favourites    Print this Article

An incremental backup cannot be performed when circular logging is enabled (Views: 5278)

Quota Exceeded (Views: 5143)

Backing up open files (Views: 5530)

64-bit Exchange 2007 and 2010 Mail-Level Backups (Views: 5370)

Supported Platform List (Views: 6166)

Powered by WHMCompleteSolution