sybperl-l Archive

From: s9ulzf <s9ulzf at fanniemae dot com>
Subject: Re: dump db through perl
Date: Jun 5 1998 9:24PM

Thanks, Michael

> However you should make sure that you call dbresults() in a loop until 
> it returns NO_MORE_RESULTS.

This is exactly what I needed. It works now. 

Lin 


> s9ulzf writes:
>  > Hi,
>  > 
>  > I'm trying to do a dump through sybperl:
>  > 
>  > 	$sql = qq[ dump database master to '/tmp/s11bld.testdump' ];
>  >     $dbh->dbcmd("$sql");
>  >     $dbh->dbsqlexec;
>  >     $dbh->dbresults;
>  > 
>  > The dump works partially with the following error:
>  > 	
>  > Msg 404101, Level 1, State 1
>  > Server 'CSYSADM21DS1_BACKUP', Procedure 'bs_write_header', 
>  >         Backup Server: 4.41.1.1: Creating new disk file /tmp/s11bld.testdump.
>  > 
>  > 
>  > Has anyone else seen this.
> 
> This is perfectly normal. If you dump via isql you will get the same
> messages (which are informational messages, btw).
> 
> However you should make sure that you call dbresults() in a loop until 
> it returns NO_MORE_RESULTS.
> 
> Michael
> -- 
> Michael Peppler         -||-  Data Migrations Inc.
> mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com
> 
>