Heinrich, Tilo wrote:
Hello,please send replies to the mailing list, so that others can follow the topic if they encounter the same problem.
Sorry about that, hit the reply instead of reply-to all.
>, but not in dbm.utl.I can see the problematic backups in knldiag (without further useful information and the surprising message "tape: surprising blockcount")
The tape entry is a mistake, was clicked the tape icon without realizing it.
No, just trying to do a full backup.Are you trying Autosave-Log backups by any chance?
I've included the requested files but I've actually just included the interesting bits, the lines with all the errors for dbm.prt.
May we have a look into the files dbm.prt, dbm.knl, dbm.mdf and dbm.mmm too? You can also compress them, if you like.
Best Regards,
Tilo Heinrich
SAP Labs Berlin
-----Original Message-----
From: Peng Tuck Kwok [mailto:[EMAIL PROTECTED]]
Sent: Mittwoch, 11. Dezember 2002 10:24
To: Heinrich, Tilo
Subject: Re: Back up error
Two different win2k servers, one which doesn't take to kindly to backup mediums at all and one which works with certain type of names apparently, for example if the medium name is Handle and the location is
C:\DB\Athena_Backup.log it is fine. If I have somethig else like Test for medium name and for file location C:\DB\Test.log then it does not work, I would get the -903 error.
I'm attaching the files that you ask for, hope it helps.
I'm getting errors like this in the knldiag.err file
2002-12-11 15:08:20 0x504 ERR 18500 IO Wrong file or device name 'C:\DB\Mydatabase_backup.log'
2002-12-11 15:08:45 0x528 ERR 18500 IO Wrong file or device name 'C:\DB\Mydatabase_backup.log'
2002-12-11 15:09:22 0x204 ERR 18500 IO Wrong file or device name 'C:\DB\Mydatabase_backup.log'
2002-12-11 15:09:34 0x204 ERR 18500 IO Wrong file or device name 'C:\DB\Mydatabase_backup.log'
Thanks.
Heinrich, Tilo wrote:
Hello,Description sql error[backup_label "Handle"];-903,Host file I/O error,invalid file or device name.What do you find in knldiag regarding the error? Information from dbm.utl could be usefull too.I managed to get the backup working on my workstation (meaning I'm running sapdb locally) but could not get the other win2k to backup the database.
So you have two databases on two systems, or one database administrated from two systems? Best Regards, Tilo Heinrich SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
3DEC1DB60003|DAT_00002|Handle
|vftFile |NO | 2496| 8|S|c:\DB\backup.dat
3DEC1DF00004|DAT_00003|Handle
|vftFile |NO | 2496| 8|S|c:\DB\Athena_Backup.log
3DF552FF0001|DAT_00004|Handle
|vftFile |NO | 2496| 8|S|c:\DB\Athena_Backup.log
3DF6AF930002|DAT_00005|Temp
|vftFile |NO | 0| 8|S|C:\DB\testing.log
[Handle] LOCATION=c:\DB\Athena_Backup.log TYPE=FILE SAVETYPE=DATA SIZE=2496 BLOCKSIZE=8 OVERWRITE=YES AUTOLOADER=NO OSCOMMAND= EXTERN=NONE CREATED=20021203105509 MODIFIED=20021210103540 [Testing] LOCATION=C:\DB\Testing.log TYPE=FILE SAVETYPE=DATA SIZE=0 BLOCKSIZE=8 OVERWRITE=NO AUTOLOADER=NO OSCOMMAND= EXTERN=NONE CREATED=20021211150535 MODIFIED=20021211150535
2002-12-11 12:59:30 0x00000558 0 DBM command backup_label
2002-12-11 12:59:30 0x00000558 ERR -24988 DBM ERR_SQL: sql error
0x00000558 ERR -24988 DBM -903,Host file I/O
error,invalid file or device name [2]
2002-12-11 12:59:34 0x00000558 0 DBM command backup_media_delete
"Temp"
2002-12-11 12:59:46 0x00000558 0 DBM command backup_media_put
"Testing" "C:\DB\Testing.log" FILE DATA 0 8 NO NO ""
2002-12-11 12:59:58 0x00000558 0 DBM command backup_media_delete
"Testing"
2002-12-11 13:00:09 0x00000558 0 DBM command backup_media_put
"Backup" "C:\DB\Backup.log" FILE DATA 0 8 NO NO ""
2002-12-11 13:00:11 0x00000558 0 DBM command backup_label
2002-12-11 13:00:11 0x00000558 ERR -24988 DBM ERR_SQL: sql error
0x00000558 ERR -24988 DBM -903,Host file I/O
error,invalid file or device name [2]
2002-12-11 15:03:46 0x00000124 0 DBM command sql_execute
2002-12-11 15:03:46 0x00000124 ERR -24988 DBM ERR_SQL: sql error
0x00000124 ERR -24988 DBM 100,Row not found
2002-12-11 15:03:58 0x00000124 0 DBM command backup_label
2002-12-11 15:03:58 0x00000124 ERR -24988 DBM ERR_SQL: sql error
0x00000124 ERR -24988 DBM -903,Host file I/O
error,invalid file or device name [2]
2002-12-11 15:04:14 0x00000124 0 DBM command backup_label
2002-12-11 15:04:14 0x00000124 ERR -24988 DBM ERR_SQL: sql error
0x00000124 ERR -24988 DBM -903,Host file I/O
error,invalid file or device name [2]
2002-12-11 15:04:22 0x00000124 0 DBM command backup_media_put
"Backup" "C:\DB\Standard.log" FILE DATA 0 8 NO NO ""
2002-12-11 15:04:27 0x00000124 0 DBM command backup_label
2002-12-11 15:04:27 0x00000124 ERR -24988 DBM ERR_SQL: sql error
0x00000124 ERR -24988 DBM -903,Host file I/O
error,invalid file or device name [2]
2002-12-11 15:04:34 0x00000124 0 DBM command backup_label
2002-12-11 15:04:34 0x00000124 ERR -24988 DBM ERR_SQL: sql error
0x00000124 ERR -24988 DBM -903,Host file I/O
error,invalid file or device name [2]
2002-12-11 15:04:41 0x00000124 0 DBM command backup_label
2002-12-11 15:04:41 0x00000124 ERR -24988 DBM ERR_SQL: sql error
0x00000124 ERR -24988 DBM -903,Host file I/O
error,invalid file or device name [2]
2002-12-11 15:04:53 0x00000124 0 DBM command backup_media_delete
"Backup"
2002-12-11 15:04:53 0x00000124 0 DBM command backup_media_put
"Standard" "C:\DB\Standard.log" FILE DATA 0 8 NO NO ""
2002-12-11 15:04:56 0x00000124 0 DBM command backup_label
2002-12-11 15:04:56 0x00000124 ERR -24988 DBM ERR_SQL: sql error
0x00000124 ERR -24988 DBM -903,Host file I/O
error,invalid file or device name [2]
2002-12-11 15:05:02 0x00000124 0 DBM command backup_media_delete
"Standard"
2002-12-11 15:05:17 0x00000514 0 DBM command sql_execute
2002-12-11 15:05:17 0x00000514 ERR -24988 DBM ERR_SQL: sql error
0x00000514 ERR -24988 DBM 100,Row not found
3DAF7E040003| |HISTLOST | | |2002-10-18
11:20:36| | | | |
| | | 0|
|
3DEC1D660002|DAT_00001|SAVE WARM|2002-12-03 10:56:39|2002-12-03 10:56:39|2002-12-03
10:56:39|2002-12-03 10:56:39| 593| |NO |Handle
| 0| 0| -903|wrong path specified
[3] |
3DEC1DB60003|DAT_00002|SAVE WARM|2002-12-03 10:57:58|2002-12-03 10:57:58|2002-12-03
10:57:58|2002-12-03 10:58:00| 594| |NO |Handle
| 280| 1| 0|
|
3DEC1DF00004|DAT_00003|SAVE WARM|2002-12-03 10:58:56|2002-12-03 10:58:56|2002-12-03
10:58:56|2002-12-03 10:58:58| 595| |NO |Handle
| 280| 1| 0|
|
3DF552FF0001|DAT_00004|SAVE COLD|2002-12-03 10:58:56|2002-12-03 10:58:56|2002-12-10
10:35:43|2002-12-10 10:35:45| 595| |YES|Handle
| 280| 1| 0|
|
3DF6AF930002|DAT_00005|SAVE WARM|2002-12-11 11:22:59|2002-12-11 11:22:59|2002-12-11
11:22:59|2002-12-11 11:23:01| 599| |NO |Temp
| 280| 1| 0|
|
