Database maintenance failed: The statement BACKUP LOG is not allowed while the recovery model is SIMPLE

From WebWatchBotWiki
Jump to: navigation, search

PROBLEM/SYMPTOMS

While performing a backup or database maintenance, the following error occurs: "Error: Database maintenance failed.Please check the event log for more detail."

Check the event log. If the following entries are present, use the workaround:

Error, Text: Database Maintenance failed (DoDatabaseBackup)
CDBCoreEx::CaptureError: CDBCoreEx::CaptureError: Microsoft OLE DB Provider for ODBC Drivers
[Executing Non Query]
Error: -2147217900 Msg: IDispatch error #3092 Description: [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
Error 1 of 5)
Number      	= -2147217900
Source      	= Microsoft OLE DB Provider for ODBC Drivers
Description 	= [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
HelpFile    	= (null)
HelpContext 	= 0
SQLState    	= 3
NativeError 	= 4208

Error 2 of 5)
Number      	= -2147217900
Source      	= Microsoft OLE DB Provider for ODBC Drivers
Description 	= [Microsoft][SQL Server Native Client 10.0][SQL Server]BACKUP LOG is terminating abnormally.
HelpFile    	= (null)
HelpContext 	= 0
SQLState    	= 3
NativeError 	= 3013

Error 3 of 5)
Number      	= -2147217900
Source      	= Microsoft OLE DB Provider for ODBC Drivers
Description 	= [Microsoft][SQL Server Native Client 10.0][SQL Server]Processed 24832 pages for database 'WebWatchBot', file 'WebWatchBot' on file 1.
HelpFile    	= (null)
HelpContext 	= 0
SQLState    	= 0
NativeError 	= 4035

Error 4 of 5)
Number      	= -2147217900
Source      	= Microsoft OLE DB Provider for ODBC Drivers
Description 	= [Microsoft][SQL Server Native Client 10.0][SQL Server]Processed 4 pages for database 'WebWatchBot', file 'WebWatchBot_log' on file 1.
HelpFile    	= (null)
HelpContext 	= 0
SQLState    	= 0
NativeError 	= 4035

Error 5 of 5)
Number      	= -2147217900
Source      	= Microsoft OLE DB Provider for ODBC Drivers
Description 	= [Microsoft][SQL Server Native Client 10.0][SQL Server]BACKUP DATABASE successfully processed 24836 pages in 5.802 seconds (33.441 MB/sec).
HelpFile    	= (null)
HelpContext 	= 0
SQLState    	= 0
NativeError 	= 3014

Query: DBMAINT_Backup 'WebWatchBot', '20130205_1', ''

RESOLUTION/WORKAROUND

  1. Change the recovery model of the WebWatchBot database to "Full"
    1. Open SSMS (SQL Server Management Studio)
    2. In the Object Explorer, locate the WebWatchBot database
    3. Right click on the WebWatchBot database
    4. Select "Properties"
    5. In the "Database Properties" window, select the "Options" page.
    6. Change the Recovery Model to "Full"
    7. Click OK to close the window.
  2. Back-up your WebWatchBot database in WebWatchBot
    1. In WebWatchBot Manager, select the menu options: Tools -> Database -> Backup
    2. Click OK to begin the backup.