Knowledge Base & Discussion Forum

OBM 5.5.8.0 MS SQL Server "Operating system error 5(Access is denied.) " Any ideas on how to resolve this failing backup?

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

Moderator: Support Team

OBM 5.5.8.0 MS SQL Server "Operating system error 5(Access is denied.) " Any ideas on how to resolve this failing backup?

Postby Dsamson » Thu May 03, 2012 9:41 pm

Here is a copy of log:

1 Info 2012/05/02 21:00 Start [ Windows XP (Georgi01), AhsayOBM 5.5.8.0 ]

2 Info 2012/05/02 21:00 Start [ Windows XP (Georgi01), AhsayOBM 5.5.8.0 ]

3 Info 2012/05/02 21:00 Start running pre-commands

4 Info 2012/05/02 21:00 Finished running pre-commands

5 Info 2012/05/02 21:00 Start running pre-commands

6 Info 2012/05/02 21:00 Finished running pre-commands

7 Info 2012/05/02 21:00 Database "master" cannot run Log backup. "Database - complete"
backup will perform.

8 Info 2012/05/02 21:00 [Start] Backing up "GEORGI01\SQLEXPRESS\master" using "Database -
complete" to C:\Documents and Settings\Georgi\.obm\cache\
1327441920156\GEORGI01\SQLEXPRESS\master

9 Info 2012/05/02 21:00 Database "master" cannot run Log backup. "Database - complete"
backup will perform.

10 Info 2012/05/02 21:00 [Start] Backing up "GEORGI01\SQLEXPRESS\master" using "Database -
complete" to C:\Documents and Settings\Georgi\.obm\cache\
1327441920156\GEORGI01\SQLEXPRESS\master

11 Error 2012/05/02 21:00 [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-05-02-21-00-00-000.ADD'. Operating
system error 5(Access is denied.).

12 Error 2012/05/02 21:00 [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-05-02-21-00-00-000.ADD'. Operating
system error 5(Access is denied.).

13 Error 2012/05/02 21:00 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.

14 Error 2012/05/02 21:00 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\master" does not exist!

15 Info 2012/05/02 21:00 [End]

16 Info 2012/05/02 21:00 [Start] Backing up "GEORGI01\SQLEXPRESS\model" using "Transaction
log" to C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\model

17 Error 2012/05/02 21:00 [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.

18 Error 2012/05/02 21:00 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

19 Error 2012/05/02 21:00 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\model" does not exist!

20 Info 2012/05/02 21:00 [End]

21 Info 2012/05/02 21:00 [Start] Backing up "GEORGI01\SQLEXPRESS\msdb" using "Transaction
log" to C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\msdb

22 Error 2012/05/02 21:00 [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.

23 Error 2012/05/02 21:00 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

24 Error 2012/05/02 21:00 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\msdb" does not exist!

25 Info 2012/05/02 21:00 [End]

26 Info 2012/05/02 21:00 [Start] Backing up "GEORGI01\SQLEXPRESS\Dokmee" using
"Transaction log" to C:\Documents and Settings\Georgi\.obm\cache\
1327441920156\GEORGI01\SQLEXPRESS\Dokmee

27 Error 2012/05/02 21:00 [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.

28 Error 2012/05/02 21:00 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

29 Error 2012/05/02 21:00 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\Dokmee" does not exist!

30 Info 2012/05/02 21:00 [End]

31 Info 2012/05/02 21:00 Start running post-commands

32 Info 2012/05/02 21:00 Finished running post-commands

33 Warn 2012/05/02 21:00 No file is being upload

34 Info 2012/05/02 21:00 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.

35 Error 2012/05/02 21:00 Backup completed with error(s)

36 Error 2012/05/02 21:01 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.

37 Error 2012/05/02 21:01 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\master" does not exist!

38 Info 2012/05/02 21:01 [End]

39 Info 2012/05/02 21:01 [Start] Backing up "GEORGI01\SQLEXPRESS\model" using "Transaction
log" to C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\model

40 Error 2012/05/02 21:01 [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.

41 Error 2012/05/02 21:01 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

42 Error 2012/05/02 21:01 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\model" does not exist!

43 Info 2012/05/02 21:01 [End]

44 Info 2012/05/02 21:01 [Start] Backing up "GEORGI01\SQLEXPRESS\msdb" using "Transaction
log" to C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\msdb

45 Error 2012/05/02 21:01 [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.

46 Error 2012/05/02 21:01 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

47 Error 2012/05/02 21:01 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\msdb" does not exist!

48 Info 2012/05/02 21:01 [End]

49 Info 2012/05/02 21:01 [Start] Backing up "GEORGI01\SQLEXPRESS\Dokmee" using
"Transaction log" to C:\Documents and Settings\Georgi\.obm\cache\
1327441920156\GEORGI01\SQLEXPRESS\Dokmee

50 Error 2012/05/02 21:01 [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.

51 Error 2012/05/02 21:01 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.

52 Error 2012/05/02 21:01 Path "C:\Documents and Settings\Georgi\.obm\cache\1327441920156\
GEORGI01\SQLEXPRESS\Dokmee" does not exist!

53 Info 2012/05/02 21:01 [End]

54 Info 2012/05/02 21:01 Start running post-commands

55 Info 2012/05/02 21:01 Finished running post-commands

56 Warn 2012/05/02 21:01 No file is being upload

57 Info 2012/05/02 21:01 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.

58 Error 2012/05/02 21:01 Backup completed with error(s)
Dsamson
 
Posts: 14
Joined: Thu Jan 19, 2012 1:41 am

Postby PG » Fri May 04, 2012 4:24 am

Yeah as it says. change the recovery model to 'full' instead of 'simple'


In the source window for the SQL databases in Ahsay, right click on each database, anc set the recovery model to full.
PG
 
Posts: 1023
Joined: Thu Feb 18, 2010 5:57 am

Expect log sequence

Postby Wayne » Fri Sep 21, 2012 12:14 am

We've been getting the following WARNING

Expect log sequence '383d' but found 'MAIL\Microsoft Information
Store\First Storage Group\E0003851.log'

I've seen it before as an error and it normally asked for a full backup to be run, but in this case it doesn't.

the obm = 6.9.4.0
the obs = 6.7.2.0

Will this warning cause any issues if we needed to restore?



1 Info 2012/09/18 21:15 Start [ Windows 2003 (mail), AccessOBM 6.9.4.0 ]
2 Info 2012/09/18 21:15 Microsoft Exchange Server 2003 (6.5.7638)
3 Info 2012/09/18 21:15 Start running pre-commands
4 Info 2012/09/18 21:15 Finished running pre-commands
5 Info 2012/09/18 21:15 Using Temporary Directory G:\Abaxio Exchange Temp\1324580636591
6 Info 2012/09/18 21:15 Start running post-commands
7 Info 2012/09/18 21:15 Finished running post-commands
8 Info 2012/09/18 21:15 Using Temporary Directory G:\Abaxio Exchange Temp
9 Warn 2012/09/18 21:15 Expect log sequence '383d' but found 'MAIL\Microsoft Information
Store\First Storage Group\E0003851.log'
10 Info 2012/09/18 21:22 Deleting temporary file G:\Abaxio Exchange Temp\1324580636591
11 Warn 2012/09/18 21:22 Backup completed with warning(s)
Wayne
Wayne
 
Posts: 229
Joined: Tue Oct 07, 2008 4:01 am
Location: Canada


Return to Microsoft SQL Server Database

Who is online

Users browsing this forum: No registered users and 1 guest

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]