cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase IQ 16 Backup Issue: unable to determine disk freespace

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

tayeb_hadjou
Advisor
Advisor
0 Kudos

Hi Cliff,

This is likely a permlission issue.

Is the IQ server running as Windows service?

Regards,

Tayeb.

SybDBA
Participant
0 Kudos

yes, tayeb.

tayeb_hadjou
Advisor
Advisor
0 Kudos

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.

SybDBA
Participant
0 Kudos

Hi Tayeb,

As i have resolved this problem, In my case the 'Sybase Backup' (in the case) folder was not created due to that only this error raised.

when i have created the same folder('Sybase Backup') in the F: drive manually,and its done.

Regards,

Pankaj

tayeb_hadjou
Advisor
Advisor
0 Kudos

Ok. Generally, when you receive such error , think about a read/write permission missing or file/directoy path is not valid.

Regards,

Tayeb.

Former Member
0 Kudos

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

tayeb_hadjou
Advisor
Advisor
0 Kudos

Hi Santiago,

Have a look into SAP KBA 2120514  and see if it helps :

http://service.sap.com/sap/support/notes/ 2120514

Regards,

Tayeb.

Former Member
0 Kudos

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