Discussion:
Load errors
(too old to reply)
unknown
2006-07-31 11:42:30 UTC
Permalink
This is a database dump of database ID 4, name 's2000', from
Jul 31 2006 2:30AM. SQL Server version: Adaptive Server
Enterprise/12.5.1/EBF 11665 ESD#2/P/NT (IX86)/OS
4.0/ase1251/1838/32-bit/OPT/Fri Feb. Backup Server version:
Backup Server/12.5.1/EBF 11428/P/NT (IX86)/OS
4.0/ase1251/2268/32-bit/OPT/Wed Sep 17 13:54:22 2003.
Database page size is 2048.
Database contains 51712000 pages; checkpoint RID=(Rid pageid
= 0x281c94b; row num = 0x9); next object ID=1114955544; sort
order ID=44, status=57; charset ID=2.
Database log version=6; database upgrade version=31.

I'm getting inconsistent failures reading from backup files.
Anyone else come across this error and any possible
solutions?
Backup Server: 4.124.2.1: Archive API error for
device='compress::f:\sybbackup\backups\s2000_1.dmp::00':
Vendor application name=Compress API, Library version=1, API
routine=syb_read(), Message=
A.M.
2006-07-31 12:08:26 UTC
Permalink
Post by unknown
This is a database dump of database ID 4, name 's2000', from
Jul 31 2006 2:30AM. SQL Server version: Adaptive Server
Enterprise/12.5.1/EBF 11665 ESD#2/P/NT (IX86)/OS
Backup Server/12.5.1/EBF 11428/P/NT (IX86)/OS
4.0/ase1251/2268/32-bit/OPT/Wed Sep 17 13:54:22 2003.
Database page size is 2048.
Database contains 51712000 pages; checkpoint RID=(Rid pageid
= 0x281c94b; row num = 0x9); next object ID=1114955544; sort
order ID=44, status=57; charset ID=2.
Database log version=6; database upgrade version=31.
I'm getting inconsistent failures reading from backup files.
Anyone else come across this error and any possible
solutions?
Backup Server: 4.124.2.1: Archive API error for
Vendor application name=Compress API, Library version=1, API
routine=syb_read(), Message=
Can you post what you are actually entering for the load
database command? The device doesn't look exactly right
for a compressed dump, but that may not be the problem.

Are you loading into another server at the same version
or different? What about the backup server versions?

Do the dump load if they aren't compressed?

-am © MMVI
m***@tinyonline.co.uk
2006-08-07 13:29:36 UTC
Permalink
/* test from live script */
load database test
from 'compress::f:\sybbackup\backups\s2000_1.dmp'
stripe on 'compress::f:\sybbackup\backups\s2000_2.dmp'
stripe on 'compress::f:\sybbackup\backups\s2000_3.dmp'
stripe on 'compress::f:\sybbackup\backups\s2000_4.dmp'
with headeronly
go
load database test
from 'compress::f:\sybbackup\backups\s2000_1.dmp'
stripe on 'compress::f:\sybbackup\backups\s2000_2.dmp'
stripe on 'compress::f:\sybbackup\backups\s2000_3.dmp'
stripe on 'compress::f:\sybbackup\backups\s2000_4.dmp'
go
select getdate()
go

Loading...