on 01-11-2015 4:28 AM
Hi,
I want to backup Sybase IQ 16 Database to a USB external Drive (F:\) by script:
BACKUP DATABASE TO 'F:\Sybase Backup\BISYBASEIQ_bk_20150111'
However, receive an error:
Error during backup/restore: unable to determine disk freespace on F:\Sybase Backup\BISYBASEIQ_bk_20150111
Please kindly advice, many thanks!
Cliff
Hi Cliff,
This is likely a permlission issue.
Is the IQ server running as Windows service?
Regards,
Tayeb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Windows service uses, by default, "Local System account". This account is likely restricted to access system services related to the network.
To check this, you need change service account to domain account OR try stop service and restart IQ database manually (using start_iq @file.cfg file.db instead) and test.
Also as recommended by SAP/Sybase, always use double backslash (\\) in windows path :
BACKUP DATABASE TO 'F:\\Sybase Backup\BISYBASEIQ_bk_20150111' ;
Regards,
Tayeb.
Hi Tayeb, hi all:
"[restart IQ database manually (using start_iq @file.cfg file.db instead)]"
It was a very usefull solution, but I still have the problem when I start SybaseIQ as Service.
I set the user Administrator into the local policies, and add the user on the tab Log On as a service, but it does not work anyway.
Another idea?.
Thanks
Santiago
Hi Santiago,
Have a look into SAP KBA 2120514 and see if it helps :
http://service.sap.com/sap/support/notes/ 2120514
Regards,
Tayeb.
Hi Tayeb, thanks:
That was the first help I found on internet.
But I am not secure if the User that I used have the right permissions.
I had add the user as "Log on as Service right" with this Microsoft manual:
-Add the Log on as a service right to an account
-To add the "Log on as a service" right to an account on your local computer
-Open Local Security Policy.
-In the console tree, double-click Local Policies, and then click User Rights Assignments.
-In the details pane, double-click Log on as a service.
-Click Add User or Group, and then add the appropriate account to the list of accounts that possess the Log on as a service right.
But It still isn't the solution for me.
I will create a new user on the domain, and will probe.
Thank you a lot.
Santiago
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.