Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Backup Problem, please advise.

3 posts in Windows NT Last posting was on 2000-01-05 21:55:25.0Z
Thomas Go Posted on 2000-01-05 13:56:19.0Z
Message-ID: <38734D83.C25C3979@wsc.com>
Date: Wed, 05 Jan 2000 08:56:19 -0500
From: Thomas Go <tgo@wsc.com>
Organization: Wall Street Concepts
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
CC: tgo@wsc.com
Subject: Backup Problem, please advise.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 23
NNTP-Posting-Host: phorcys.wscis.wsc.com 198.4.125.27
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2742
Article PK: 1090135

Hi,

I have sporadic problems with my backup situation. Normally it runs
fine, but at times, I get the following problem.


Backup Server: 4.141.2.37: [2] The 'WriteFile' call failed for device
'\\.\TAPE0' with error number 1111 (The I/O bus was reset). Refer to
your
operating system documentation for further details.
Backup Server: 4.141.2.37: [2] The 'WriteFile' call failed for device
'\\.\TAPE0' with error number 1 (Incorrect function). Refer to your
operating
system documentation for further details.

I would do an incremental backup and when I get the following message it
will mess up my entire backup. I'm just using a the following command.

dump database data to "\\.\tape0" with notify=client

Is there something wrong with my media or tape device or the way that I
backup my data?
Please advice.

Thanks,
Thomas
P.S. I'm using verion 11.5.2 on Windows NT.


Bill Robinette Posted on 2000-01-05 21:52:46.0Z
From: "Bill Robinette" <William.Robinette@ValueOptions.com>
References: <38734D83.C25C3979@wsc.com>
Subject: Re: Backup Problem, please advise.
Date: Wed, 5 Jan 2000 16:52:46 -0500
Lines: 83
Organization: ValueOptions
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <Y4Wn8d8V$GA.184@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: pixa6.optionshealthcare.com 208.140.249.6
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2736
Article PK: 1090125

I ran into a similar problem. This lies in the NT operating system. Do you
have ARCserve or another backup utility installed on this server? What type
of hardware are you using?

I have ARCserve installed on an HP netserver with NT 4.0 SP4 and I see a
similar problem when trying to dump multiple databases to one tape. However,
I have the same tape drive in a different HP server with out ARC serve and
everything works fine.

I opened a case twice on this issue and Sybase was unable to find a solution
since the backup server is working correctly and the call that is failing is
a NT OS call. Instead of spending days trying different scsi Configs, The
way I got aroung this was to dump to a file and backup that file using arc
serverather than dumping directly to tape. Sybases solution is listed below.

You may try defining the tape device as a dump device is Sybase.

Sybases reccommened steps: My comments are in parentheses

This is looking more and more like a hardware or operating system
problem. Sybase has no problem with dumping to the tape, it is in
appending a file where the problem lies. The failure is with the
GetTapeStatus call which is not a Sybase call.

I will continue to work with you on this issue and have the following
questions and suggestions:

1 - Does the Event Viewer show any additional information with regards
to this process? Check in System and Application, if there are any
related events, please send me the Event Id # and source. (Nothing here)

2 - Was the tape newly formatted on this hardware? If it is not a brand
new tape, try a brand new tape, format it and try the dumps again. (no
didn't work)

3 - After the first dump, eject and reload the tape then try to append
the next dump file (you'll have to use isql rather than your
scripts).(didn't work)

4 - If #3 fails, log off after issuing dump #1, log on as another user
then try to append dump #2. This will show if the O/S is not allowing
access to the tape after the first dump is completed, which would fit
with the return value to the GetTapeStatus call (1104 - No more data is
on the tape). (didn't work)

5 - In searching the Microsoft Tech Support database, the MS SQL server
6.5 had a problem dumping to tape returning an 1104 error. The
suggestions from MS in that case were:
- Try to put the tape drive on a different SCSI adapter (don't have one)
- Upgrade to Windows NT 4.0. (already there)
- Dump to disk files instead of tape files. (worked Great)

Thomas Go wrote in message <38734D83.C25C3979@wsc.com>...
>Hi,
>
>I have sporadic problems with my backup situation. Normally it runs
>fine, but at times, I get the following problem.
>
>
>Backup Server: 4.141.2.37: [2] The 'WriteFile' call failed for device
>'\\.\TAPE0' with error number 1111 (The I/O bus was reset). Refer to
>your
>operating system documentation for further details.
>Backup Server: 4.141.2.37: [2] The 'WriteFile' call failed for device
>'\\.\TAPE0' with error number 1 (Incorrect function). Refer to your
>operating
>system documentation for further details.
>
>I would do an incremental backup and when I get the following message it
>will mess up my entire backup. I'm just using a the following command.
>
>dump database data to "\\.\tape0" with notify=client
>
>Is there something wrong with my media or tape device or the way that I
>backup my data?
>Please advice.
>
>Thanks,
>Thomas
>P.S. I'm using verion 11.5.2 on Windows NT.


Bill Robinette Posted on 2000-01-05 21:55:25.0Z
From: "Bill Robinette" <William.Robinette@ValueOptions.com>
References: <38734D83.C25C3979@wsc.com>
Subject: Re: Backup Problem, please advise.
Date: Wed, 5 Jan 2000 16:55:25 -0500
Lines: 69
Organization: ValueOptions
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <ZFi5bf8V$GA.300@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: pixa6.optionshealthcare.com 208.140.249.6
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2735
Article PK: 1090170

I had a similar problem with a slightly different error. here is sybases
solution. I'm assuming the 'WriteFile call is an NT call as well. Solution 5
worked for me the others did not. Dumping to a file was fine then I backed
up that file on the tape with ARCServe

This is looking more and more like a hardware or operating system
problem. Sybase has no problem with dumping to the tape, it is in
appending a file where the problem lies. The failure is with the
GetTapeStatus call which is not a Sybase call.

I will continue to work with you on this issue and have the following
questions and suggestions:

1 - Does the Event Viewer show any additional information with regards
to this process? Check in System and Application, if there are any
related events, please send me the Event Id # and source.

2 - Was the tape newly formatted on this hardware? If it is not a brand
new tape, try a brand new tape, format it and try the dumps again.

3 - After the first dump, eject and reload the tape then try to append
the next dump file (you'll have to use isql rather than your scripts).

4 - If #3 fails, log off after issuing dump #1, log on as another user
then try to append dump #2. This will show if the O/S is not allowing
access to the tape after the first dump is completed, which would fit
with the return value to the GetTapeStatus call (1104 - No more data is
on the tape).

5 - In searching the Microsoft Tech Support database, the MS SQL server
6.5 had a problem dumping to tape returning an 1104 error. The
suggestions from MS in that case were:
- Try to put the tape drive on a different SCSI adapter
- Upgrade to Windows NT 4.0.
- Dump to disk files instead of tape files.

Thomas Go wrote in message <38734D83.C25C3979@wsc.com>...
>Hi,
>
>I have sporadic problems with my backup situation. Normally it runs
>fine, but at times, I get the following problem.
>
>
>Backup Server: 4.141.2.37: [2] The 'WriteFile' call failed for device
>'\\.\TAPE0' with error number 1111 (The I/O bus was reset). Refer to
>your
>operating system documentation for further details.
>Backup Server: 4.141.2.37: [2] The 'WriteFile' call failed for device
>'\\.\TAPE0' with error number 1 (Incorrect function). Refer to your
>operating
>system documentation for further details.
>
>I would do an incremental backup and when I get the following message it
>will mess up my entire backup. I'm just using a the following command.
>
>dump database data to "\\.\tape0" with notify=client
>
>Is there something wrong with my media or tape device or the way that I
>backup my data?
>Please advice.
>
>Thanks,
>Thomas
>P.S. I'm using verion 11.5.2 on Windows NT.