Within a cluster setup I am attempting to run a backup and it fails with just a 64kb file created. Within the backup command I have the OLRMAP=1 parameter to optimize the backup for Object Level Recovery.
It looks like on a cluster the temp directory of the user running the cluster service is used, rather than the temp directory of the user running SQL server.
WORKAROUND:
The issue is caused by a permissions problem, to create the file for the Object Level Recovery optimization the temp directory of the cluster service user is being used, therefore permission to this is required.
Also the removal of the OLRMAP=1 parameter would overcome this problem - however if Object Level Recovery is attempted rights to this temp directory is going to be required.
To provide an alternative to this way of working, has been raised, this is for the creation of an additional parameter to specify the exact temporary directory to be used with OLRMAP=1 is used or when using the wizard 'Optimize backup for Object Level Recovery' is selected.
STATUS:
Enhancement request CR0199893 has been submitted to Development for consideration in a future release of LiteSpeed for SQL Server.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy