Getting Disk read failed for database device during dump
I am getting the following error when one of my cron job
runs for backup...
Sep 21 19:07:48 2005: D00: SYBMULTBUF ERROR: Disk read
failed for database device
Sep 21 19:07:48 2005: Backup Server: 220.127.116.11:  The
'read' call failed for device '/exp/dbbackup/CUSTOM_DB.dmp'
with error number 5 (I/O error). Refer to your operating
system documentation for further details. Look for 'Sep 21
19:07:48 2005: D00: SYBMULTBUF ERROR: ' i
n the backup server errorlog for additional information from
Can somebody give me any direction as to what migh...Dump database failed. A lot of space available on disk
Using Windows 2003 Server
Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS
4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004
Aug 19 23:57:00 2007: D00: SYBMULTBUF ERROR: Wait for i/o
completion failed: State=107, Msg=The request could not be
performed because of an I/O device error
Aug 19 23:57:00 2007: Backup Server: 18.104.22.168:  The
'ReadFile' call failed for device
with error number 1117 (The request could not be performed
because of an I/O device error). Refer to your ...Unable to backup database on linux using dump database
Desparately seeking help...
I am unable to produce a backup of any of our sybase databases. We are running
ASE 11.9.6 on Suse 8.1
Everything appears to be working correctly ie we can create databases/devices,
our application is creating the data in the database correctly.
The backup server is running. However when I issue a dump database command from
isql, I get the following errors
/opt/sybase-11.9.2/install/RUN_linux_back: line 14: 2978 Segmentation fault
/opt/sybase-11.9.2/bin/backupserver -Slinux_back -cdmpdev1
-e/opt/sybase-11.9.2/install/linux_back.log -N25 -C20
an...why dump database failed?
Why i cannot dump database htlsys successfully? errors as follow:
Oct 23 17:02:31 2000: Backup Server: 22.214.171.124: Dumpfile e
'htlsys002970EFA6 ' section number 0001 mounted on disk file
Oct 23 17:02:33 2000: Backup Server: 126.96.36.199: Database htlsys: 434
Oct 23 17:02:34 2000: Backup Server: 188.8.131.52: Database htlsys: 810
Oct 23 17:02:34 2000: Backup Server: 184.108.40.206: Database htlsys: 848
can anybody help?
I do not see an error in the text below. What is the problem...
...backup database fails
I believe I have posted this issue sometime before but without success.
I'm trying to implement a dayly database backup on a customers maschine
using the following code:
wait before start
wait after end
transaction log truncate
Running that I get the follwoing error message:
Error during backup: Could not create directory
"D:\Sicher\Daten\Temp\mFMBAK"-- File exists
SQLCODE=-697, ODBC 3 State="HY000"
It is true that the directory exists and I d...Dump of databases failed..
I am getting the following error when trying to dump database on one of
our production servers:
Msg 7205, Level 18, State 3:
Server 'TOTO', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the
Server boot directory.
Four other servers are using the same backup server without problem.
It started two days ago.
Our environment : Sybase SQL Server 220.127.116.11 on Alpha OpenVMS v 7.1
Restarting of backup server helped (I was able to dump databases) , but
next scheduled backup failed again
Thank you for any hints,
...dump database to disk
After years of using DLT tapes as dump devices, we are
considering dumping our 26 GB database to disk files.
The reason is that we wish to have our enterprise-wide
Tivoli Storage Manager (TSM) handling ASE backups, so
we plan dumping to flat files, then let TSM back them up.
Our first tests shown a nasty side effect, never seen
when we used tapes: dump seems to delay other Unix
processes, which run slower during the dump. To some
extent this may be the result of overloading disks
shared with other apps. Maybe this is the only reason,
as our SAN is a black box for me and I cannot te...Can't backup database after a backup fails due to broken connection
Ran into this on a customer system yesterday, ASA
Customer has a backup server running dbbackup (of db on
primary server) daily as a scheduled task. Customer LAN has
had issues lately resulting in random disconnects of db
clients from the primary server. After a daily backup fails
due to broken connection, it is no longer possible to backup
that database in any way until the database service has been
stopped and restarted. Any form of backup initiated after
the failure and before the restart just hangs and does
nothing. Other than this the database is fully functional
...Regular database backup fails occasionally with Backup Server Internal Error: 18.104.22.168: Multibuffering subprocesses died
Regular database backup fails occasionally with Backup Server Internal
Error: 22.214.171.124: Multibuffering subprocesses died, archive
This is been happening for quite time.
This gets cure when I restart my ASE server. But since we have a 24/7
production environment its become difficult for taking a down time.
I really appreciate if someone can help me for the same.
$ dataserver -v
Adaptive Server Enterprise/126.96.36.199/P/EBF 11089 ESD 1/Sun_svr...Automated Backup [Dump DataBase]
I would like to Create a procedure which does
the dump of Database to a specific file for every
This procedure I'll call from FrontEnd Application
PB, and call the procedure in Timer Interval.
I need a syntax for Dumping the Database inside
...Help: Backup database in SQLServer
Could you give me some info about how to show from powerbuilder the
percentage message given by MS SQL Server while performing a database backup
/ restore .
Thanks in advance,
PowerBuilder 8.0.1 Build 9017
Windows 2000 Pro
how is gathering this information implemented? Most times it is via a
callback which is not supported in PB. You will need to handle that from a
DLL could display the status in a dialog...
"sisgarbe" <email@example.com> wrote in message
news:MQInAuEpBHA.firstname.lastname@example.org...BackupServer fails to dump trans / database
ASE 12.5 SWR 9609 GA/P/Sun_svr4/OS 5.8/main/1647/32-bit/FBO
BackupServer fails to dump transaction logs or databases
with Msg 8009, Level 16, State 1. BackupServer error
188.8.131.52: Unable to create database information file xxx :
Too many open files.
Sybase account limit on file descriptors is 256.
/proc/'sybase bs pid'/fd shows 257 files at time of failure.
I understand the OS / process reason for the failure, but
believe this is a Sybase issue.
I can increase the resource limit on open files, but feel
this only prolongs the inevitable.
This is a multi-part messag...user database intermittently failed to backup
Operating system: Windows NT 4.0 Sp6a
ASE : 11.5.1
My query is does anyone come across this problem where one of the user
database failed to dump while all the other user databases dump OK in the
same script scheduled nightly?
It happens about twice in a week and the days it failed kept on changing
and i have to manually backup the database on the day it failed.
Any thoughts will be great.
Shaun Chanthery wrote:
> Operating system: Windows NT 4.0 Sp6a
> ASE : 11.5.1
> My query is does anyone come across this problem where one of...Why I dump database with stored procedure failed?
I'm using Sybase 11.9 for WINNT 4.0,and i wrote a stored procedure as
CREATE PROCEDURE sp_dump_db2file
DECLARE @dbfilename varchar(120)
IF @dbname IS NULL
IF @filename IS NULL
SELECT @dbfilename = @filename + ".bdb"
DUMP DATABASE @dbname to @dbfilename with init
SELECT @dbfilename = @filename + ".btr"
DUMP TRAN @dbname to @dbfilename with init
It can works fine under isql,but fails when i call it
from my application(Borland delphi 5.0 appli...