by
LOAD DATABASE BILLTEST FROM DUMP_BILLROLL
Server Message: Number 3216, Severity 10
Server 'BACKUP_SVR', Line 1:
Backup Server session id is: 13. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume
change request from the Backup Server.
Server Message: Number 5702, Severity 10
Server 'BACKUP_SVR', Line 1:
The SQL Server is terminating this process.
Server Message: Number 3230, Severity 24
Server 'BACKUP_SVR', Line 1:
For logical disk device 'BILL_TEST', neither primary device
'E:\sybase\data\billtest.dat' nor secondary device '' is active. LOAD
DATABASE cannot continue.
Client Message: Layer 1, Origin 1, Severity 1, Number 60
ct_cmd_drop(): user api layer: external error: There is a usage error.
This routine has been called at an illegal time.
Failure has occurred in CT-Library call. Connection is no longer usable
and will be automatically dropped.
errorlog
===============
00:00000:00015:1999/02/01 15:31:10.28 server Error: 3230, Severity: 24,
State: 1
00:00000:00015:1999/02/01 15:31:10.30 server For logical disk device
'BILL_TEST', neither primary device 'E:\sybase\data\billtest.dat' nor
secondary device '' is active. LOAD DATABASE cannot continue.
00:00000:00015:1999/02/01 15:31:10.33 kernel
************************************
00:00000:00015:1999/02/01 15:31:10.34 kernel SQL causing error : LOAD
DATABASE BILLTEST FROM DUMP_BILLROLL
00:00000:00015:1999/02/01 15:31:10.34 kernel curdb = 5 pstat =
0x1010000 lasterror = 3230
00:00000:00015:1999/02/01 15:31:10.36 kernel preverror = 0 transtate =
1
00:00000:00015:1999/02/01 15:31:10.36 kernel curcmd = 229 program =
SQL_Advantage
00:00000:00015:1999/02/01 15:31:10.45 kernel pc: 0x7c6a19 pcstkwalk +
0x29(0x1b4d580, 0x1b4d9a4, 0x270f, 0x2, 0x2001aafc)
00:00000:00015:1999/02/01 15:31:10.45 kernel pc: 0x7c679f ucstkgentrace
+ 0x1cf(0x200020, 0x2, 0x270f, 0x0, 0x0)
00:00000:00015:1999/02/01 15:31:10.45 kernel pc: 0x7a4994 ucbacktrace +
0x84(0x0, 0x1, 0x18, 0x0, 0x3)
00:00000:00015:1999/02/01 15:31:10.45 kernel pc: 0x4041b3
terminate_process + 0x833(0x0, 0xffffffff, 0x1b4dd50, 0x4163c8,
0x1b4ddb0)
00:00000:00015:1999/02/01 15:31:10.47 kernel pc: 0x41648a close_network
+ 0x1a(0x1b4ddb0, 0x4c108a, 0x20, 0x1e, 0x18)
00:00000:00015:1999/02/01 15:31:10.47 kernel pc: 0x4163c8 hdl_default +
0x48(0x20, 0x1e, 0x18, 0x1, 0x1b4dde4)
00:00000:00015:1999/02/01 15:31:10.47 kernel pc: 0x4c108a s_handle +
0x48a(0x20, 0x1e, 0x18, 0x1, 0x1b4dde4)
00:00000:00015:1999/02/01 15:31:10.47 kernel pc: 0x416203 ex_raise +
0x153(0x20, 0x1e, 0x18, 0x1, 0x9)
00:00000:00015:1999/02/01 15:31:10.47 kernel pc: 0x6901ec
dmpld_fill_devinfo + 0x19c(0x221b3000, 0x1a000000, 0x1a, 0x1b4eaac,
0x1b4e8c8)
00:00000:00015:1999/02/01 15:31:10.49 kernel pc: 0x68eaf8
find_ldxact_type + 0x118(0x221b3000, 0x210320d0, 0x20762af0, 0x1a000000,
0x1b4e8e8)
00:00000:00015:1999/02/01 15:31:10.49 kernel pc: 0x68f37f
dmpld_send_dbmaps + 0x1cf(0x221b3000, 0x20762af0, 0x0, 0x0, 0xffffffff)
00:00000:00015:1999/02/01 15:31:10.49 kernel pc: 0x687926
dmpld_begin_load + 0x406(0x221b2c9c, 0x8, 0x1b4f9f4, 0x221b3000, 0x4b)
00:00000:00015:1999/02/01 15:31:10.49 kernel [Handler pc: 0x6887f0
lddb_handle installed by the following function:-]
00:00000:00015:1999/02/01 15:31:10.49 kernel pc: 0x684a6a lddb_main +
0x37a(0x221b2c04, 0x20762a00, 0x0, 0x3, 0x20762a00)
00:00000:00015:1999/02/01 15:31:10.50 kernel pc: 0x5bb85c s_execute +
0x2e1c(0x20762a00, 0x1, 0x0, 0x20762a00, 0x1b4fe68)
00:00000:00015:1999/02/01 15:31:10.50 kernel [Handler pc: 0x4c0c00
s_handle installed by the following function:-]
00:00000:00015:1999/02/01 15:31:10.50 kernel pc: 0x4bebf8 sequencer +
0xaf8(0x2218a000, 0x20762a00, 0x21, 0x0, 0x20762a00)
00:00000:00015:1999/02/01 15:31:10.50 kernel pc: 0x5924f1
tdsrecv_language + 0x341(0x0, 0x2001aafc, 0x0, 0x0, 0x0)
00:00000:00015:1999/02/01 15:31:10.50 kernel [Handler pc: 0x416320
hdl_backout installed by the following function:-]
00:00000:00015:1999/02/01 15:31:10.50 kernel [Handler pc: 0x509ad0
ut_handle installed by the following function:-]
00:00000:00015:1999/02/01 15:31:10.52 kernel pc: 0x45c383 conn_hdlr +
0x1483(0x9, 0x4000, 0x2001aafc, 0x0, 0x0)
00:00000:00015:1999/02/01 15:31:10.52 kernel pc: 0x7d9f06 kpsuspend +
0xf6(0x2001aafc, 0x0, 0x0, 0x2001aafc, 0x0)
00:00000:00015:1999/02/01 15:31:10.52 kernel pc: 0x77f04f2c end +
0x77604f2c(0x7d9e70, 0x2001aafc, 0x0, 0x0, 0x0)
00:00000:00015:1999/02/01 15:31:10.52 kernel end of stack trace, spid
15, kpid 2097184, suid 3
===============
print 'BILL_TEST'
substring(convert(binary(4),d.low), v.low,1))) + 1
from master.dbo.sysdevices d, master.dbo.spt_values v
where v.type = 'E' and v.number = 3
disk init name='BILL_TEST',physname='E:\sybase\data\billtest.dat',
go
--
My best regards,
Vitaly Lipovetsky.