bijuck
asked on
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.
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.
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
-bret
then I can't help then ... I only use ASE :)
ASKER
To reconfirm..The version of SYBASE i use is ASA.
Could anyone help out on this.
Could anyone help out on this.
Check for the permissions on the mapped drive and give all permission on the map drive.
> 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)
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)
ASKER
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)
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)
what OS is your ASE server running on ?
ASKER
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.
Tried having the share on both Win XP and Win 2k again same problem.
ASKER
Chris Its a SYBASE ASA. Ver 8.02. (3601)
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
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
ASKER
Mansoor,
Same problems. It doesnt work.
Its pretty crazy. The online help doesnt mention anything about this either.
Same problems. It doesnt work.
Its pretty crazy. The online help doesnt mention anything about this either.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
Create a shortcut and paste something like that:
"C:\Program Files\Sybase\SQL Anywhere 9\win32\dbbackup.exe" -c "eng=engine_server_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.
"C:\Program Files\Sybase\SQL Anywhere 9\win32\dbbackup.exe" -c "eng=engine_server_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.
I am not aware of any "free space" checks on ASE.