Problem with writing backup utility (in Sybperl) 
Author Message
 Problem with writing backup utility (in Sybperl)

Hi all,

I am writing a "friendly" utility in Sybperl that will guide user
step by step backing up a database.  

With databases that only require one tape to back up completely there
are no problem.  I'd just issue the commands through &dbcmd and
&dbsqlexec and when it's done my msg_handler will receive a message
with $msg == 602801 and then I regex-parse $text for the dumpfile
name and section number.

However when the database requires multiple tapes to back it up then I
run into problem.  Normally when backing up using isql and the tape is
full, isql would say "oh this tape is full so insert another" and also
"by the way the session id is 13 so use it in the next sp_volchanged
command".  However within Sybperl script I don't seem to be able to
intercept those messages.  I would get the message saying "this tape
is done" and nothing else (same as in the previous paragraph).  What I
really need is intercept some message that will tell me whether the
backup is done or the tape is full and I need to tell the user to
insert another.

I would be grateful if someone can show me a way, be it clean or
kludge, to do that, or even just point me to the right document
to read.  If I can get it to work I'd promise to post solutions to
the Net.


--



Sun, 02 Feb 1997 10:18:52 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Can I write my own NT backup utility?

2. NEW FREE SYBASE UTILITIES (PERL/SYBPERL)

3. SQL Server backup utility vs Seagate Backup Exec

4. Solstice Backup and Enterprise Backup Utility

5. Online checkpoint problems, vendor backup utilities

6. writing a job to automate backups via InCD problems

7. XML SDK - Is there a utility to write XML

8. Writing files on 6.5 sql server using BCP utility

9. looking for utility that checks for a write-protected disk

10. Backup/restore utilities

11. DB compare utility for either on-line db's or backups(including data)

12. SQL Server 2K and Win2K backup utility


 
Powered by phpBB® Forum Software