Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Question Unanswered: dump databse / load database command

    Hi all,

    We have a number of 3590 tape cartridges that are not labeled with run dates. The backups on the tapes were created with 'dump database' command in sybase.

    Is there a way to read the headers on the tapes...just to obtain the date the dumps were created, in order for the tapes to be properly labeled.

    I have done some research and found that the 'load database' command is probably the one to be used, but I am unsure of the proper syntax, being an AIX admin...and have never used sql / sybase.

    Thanks in advance for any help.

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    1> load database pubs2 from '\archive\pubs2.dmp' with listonly
    2> go
    Backup Server session id is: 5. Use this value when executing the
    'sp_volchanged' system stored procedure after fulfilling any volume change
    request from the Backup Server.
    Backup Server: Device '\archive\pubs2.dmp':
    Volume name:' '

    Backup Server: Device '\archive\pubs2.dmp':
    File name: 'pubs2'
    Create date & time: Tuesday, Aug 26, 2003, 11:03:49
    Expiration date & time:
    Tuesday, Aug 26, 2003, 00:00:00
    Database name: 'pubs2'

    Backup Server: Device \archive\pubs2.dmp: Volume cataloguing complete.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts