Backup MaxDB to Linux (or NAS) share

[Former Member]

Hello,

I use MaxDB 7.6.03.09 on Windows 2003 64 bit servers, but the issue I have occurs on more versions, also on 32 bit servers.

I have some difficulties backing up my DB to a Linux NAS. When I define a backup medium using a file on a share on a Windows server, everything goes fine. When I use the same mechanism using our Buffalo TeraStation, wich is a Linux based NAS, I get the following error:

-24988 SQL error [backup_save "<medium_name>" LOG RECOVERY]; -903, Host file I/O error

knldiag.err shows me:

2009-01-09 12:10:21 0x118C ERR 18611 SECURITY Access denied

2009-01-09 12:10:21 0x1174 ERR 52012 SAVE error occured, basis_err 3700

I have given the MaxDB service in Windows the 'logon as' account from which I connect to the Terastation and made an account on the Terastation with the same credentials. If I do this to a Windows share, everything goes fine. So I have no clue why it's telling me 'Access denied'. I can browse perfectly well with the given account to the share on the Terastation and create and delete files. I also have a Suse 11 server with Samba on it, on which I have exactly the same problem. So it must be some sort of Linux problem. The disks on the Terastation are mounted with XFS filesystem, the Suse has EXT3. Again, I have no trouble writing and deleting files. We have 2 of these devices, both with the same problem.

Anyone seen this before?

[lbreddemann · Accepted solution]

Hi Martin,

please check the setting of the parameter USE_BACKUP_SECURITY_DESCRIPTOR.

Set it to "NO" to use the backup with SAMBA shares.

(description of the parameter:

Specifies whether Windows operating system security descriptor is to be used for file backups.

USE_BACKUP_SECURITY_DESCRIPTOR = 'YES' or 'NO'

'YES': Use Windows security descriptor on file backups

'NO' : Do not use Windows security descriptor on file backups (e.g., backing up to Samba share)

)

Hope that helps,

Lars

[Former Member · Accepted solution]

That's exactly it. Feel a little frustrated now, I've googled this for days, but it HAS to be documented somewhere. Guess I didn't searched well enough

Thanks a million Lars!

[lbreddemann · Accepted solution]

Hi Martin,

actually it is documented... e.g. SAP Note 85736 SAVE DATA on network disk drive.

And in DBMGUI you can doubleclick on the parameter to view the parameter description.

Anyhow, glad this helped you.

regards,

Lars