Error During Database Backup

From WebWatchBotWiki
Jump to: navigation, search
 Share 

Summary

During database maintenance or a database backup, the following error (or similar) occurs: Error: Unable to perform backup. An error occurred during backup

In the Windows Event Viewer, Application log, the following error message (or similar) appears: [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

Full Error Text

Section: CDatabaseBackupDlg Version: 5.1.17 Build: 24422

Error: Unable to perform backup.  An error occurred during backup.

Detail: 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 1376 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 6 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 1382 pages in 1.600 seconds (6.745 MB/sec).

HelpFile = (null)

HelpContext = 0

SQLState = 0

NativeError = 3014


Query: DBMAINT_Backup 'WebWatchBot', '20120321_1', </nowiki>

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.