• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1704
  • Last Modified:

Unable to perform database backup on network drive using sybase central.

Hello I user Adaptive Server Enterprise version 8.0.2

I am facing a problem while backing up the database to a network driver.
The error i get is unable to determine disk free space on (mapped drive location).
This is inspite of the shared folder network folder having full write permissions.
ASA Error -697.

Is there any work around for this ? I faced this problem no matter if i try via Sybase central or Via a backup statement.
0
bijuck
Asked:
bijuck
  • 5
  • 5
  • 2
  • +3
2 Solutions
 
ChrisKingCommented:
Please confirm: you are using ASA, not ASE (as stated on the first line)

I am not aware of any "free space" checks on ASE.
0
 
bretCommented:
It has to be ASA - there never was a version 8.0 of Enterprise, went directly from 4.9.2.x to 10.0.

-bret
0
 
ChrisKingCommented:
then I can't help then ... I only use ASE  :)
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
bijuckAuthor Commented:
To reconfirm..The version of SYBASE i use is ASA.
Could anyone help out on this.
0
 
mansoor_a_khanCommented:
Check for the permissions on the mapped drive and give all permission on the map drive.
0
 
ChrisKingCommented:
> This is inspite of the shared folder network folder having full write permissions.
Windoze has 2 level of permissions, file system level and share level. Have you checked both ?

Can you write some other file to the same location, just to remove ASA from the problem (for the moment)
0
 
bijuckAuthor Commented:
I have tried it again. Same problem.

The share has 'Full permission' for everyone.
I am able to create other files without sybase. Also create\Delete\modify etc works with windows explorer on the shared drive.

This fix is important for me. Any help will be great. Thanks in advance.

The full error code is as below
ASA Error - 697. Error during backup: Unable to determine disk freespace on z:\mydb.db (The storage control block address is invalid)
0
 
ChrisKingCommented:
what OS is your ASE server running on ?
0
 
bijuckAuthor Commented:
Faced the problem while trying running SYBASE CENTRAL on both on  win XP and windows 2000 proffessional.
Tried having the share on both Win XP and Win 2k again same problem.
0
 
bijuckAuthor Commented:
Chris Its a SYBASE ASA. Ver 8.02. (3601)
0
 
mansoor_a_khanCommented:
BJ,
Instead of Backing up at z:\mydb.db, create a sub directory eg. z:\backup\ and give full permission in this subdir and then try backup this should work for you.

Cheers,
Mansoor
0
 
bijuckAuthor Commented:
Mansoor,
Same problems. It doesnt work.
Its pretty crazy. The online help doesnt mention anything about this either.
0
 
ChrisKingCommented:
does it help if you "mount" the NTFS drive instead of mapping the drive ?
0
 
pitsnogleCommented:
Another option is to back it up locally, then copy it over to the network drive, and finally delete the local backup copy.

Another idea is to declare the network drive as a tape and backup to the tape.

good luck.
Rich
0
 
lcomesCommented:
Bijuck,

I am running into the same issue.  For what it's worth, it does work if you do not specify a drive or folder destination.  Just specify nameofdatabase.db and it work.  It saves the db copy into c:\winnt\system32 of the server!
I'll keep trying with commands to get a better path destination...

Laurent.
0
 
lcomesCommented:
Create a shortcut and paste something like that:

"C:\Program Files\Sybase\SQL Anywhere 9\win32\dbbackup.exe" -c "eng=engine_server_name;dbn=database_name;uid=dba;pwd=sql;commlinks=tcpip" -x -y "\\server_destination_name\apps\data\database_name.db"

Make sure to keep the quotes for each part of the line.  The server_destination_name can be an IP address.  This creates a folder with name same as database_name.db and creates copies of db and log files in folder.  The -x and -y flags are to reset the log (transaction) file and to overwrite files in folder.

Hope this helps,

Laurent.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 5
  • 5
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now