Knowledge Base & Discussion Forum

Any ideas on how to resolve this failing backup?

Discuss issues about AhsayOBM's MS SQL Server Database backup and restore

Moderator: Support Team

Any ideas on how to resolve this failing backup?

Postby Dsamson » Fri Jun 08, 2012 1:11 am

1 Info 2012/06/06 20:58 Start [ Windows XP (Georgi01), AhsayOBM 5.5.8.0 ]

2 Info 2012/06/06 20:58 Start running pre-commands

3 Info 2012/06/06 20:58 Finished running pre-commands

4 Info 2012/06/06 20:58 Database "master" cannot run Log backup. "Database - complete"
backup will perform.

5 Info 2012/06/06 20:58 [Start] Backing up "GEORGI01\SQLEXPRESS\master" using "Database -
complete" to C:\Documents and Settings\Georgi\.obm\cache\
1327441920156\GEORGI01\SQLEXPRESS\master

6 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup
device 'C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\master\
DATABASE_master.bak.2012-06-06-21-00-00-000.ADD'. Operating
system error 5(Access is denied.).

7 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.

8 Error 2012/06/06 20:58 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\master" does not exist!

9 Info 2012/06/06 20:58 [End]

10 Info 2012/06/06 20:58 [Start] Backing up "GEORGI01\SQLEXPRESS\model" using "Transaction
log" to C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\model

11 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][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.

12 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

13 Error 2012/06/06 20:58 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\model" does not exist!

14 Info 2012/06/06 20:58 [End]

15 Info 2012/06/06 20:58 [Start] Backing up "GEORGI01\SQLEXPRESS\msdb" using "Transaction
log" to C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\msdb

16 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][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.

17 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

18 Error 2012/06/06 20:58 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\msdb" does not exist!

19 Info 2012/06/06 20:58 [End]

20 Info 2012/06/06 20:58 [Start] Backing up "GEORGI01\SQLEXPRESS\Dokmee" using
"Transaction log" to C:\Documents and Settings\Georgi\.obm\cache\
1327441920156\GEORGI01\SQLEXPRESS\Dokmee

21 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][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.

22 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

23 Error 2012/06/06 20:58 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\Dokmee" does not exist!

24 Info 2012/06/06 20:58 [End]

25 Info 2012/06/06 20:58 Start running post-commands

26 Info 2012/06/06 20:58 Finished running post-commands

27 Warn 2012/06/06 20:58 No file is being upload

28 Info 2012/06/06 20:58 The In-File Delta Backup feature is not enabled on this account.
Please be aware that files are being backed up in their entirety
in this backup job.

29 Error 2012/06/06 20:58 Backup completed with error(s)
Dsamson
 
Posts: 14
Joined: Thu Jan 19, 2012 1:41 am

Postby whizkidz » Wed Jun 13, 2012 8:07 pm

Hello Dsamson.

To be frank, this line gives it all away.

11 Error 2012/06/06 20:58 [Microsoft][ODBC SQL Server Driver][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.

as stated you must set te recovery type of the databases to FULL.
This can be done with Microsoft SQL Server Management Studio Express

Or read http : //forum.ahsay . com/viewtopic.php?t=7749
whizkidz
 
Posts: 14
Joined: Thu Nov 06, 2008 7:23 am


Return to Microsoft SQL Server Database

Who is online

Users browsing this forum: No registered users and 2 guests

Looking for Rbackup Alternative | Vembu Alternative | Novastor Alternative | Asigra Alternative | BackupAgent Alternative? Try our product.


A wholly owned subsidiary of Ahsay Backup Software Development Company Limited  [HKEx Stock Code: 8290]