Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    42

    Red face Unanswered: problem will restoring D/b

    All,
    I have a dat file which i want to restore.When I try to restore it I get follwing Error.

    Backup Server session id is: 19. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
    Backup Server: 4.10.2.1: Label validation error: first label not VOL1.
    Backup Server: 6.31.2.4: Volume rejected.
    Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
    Backup Server: 6.32.2.3: C:\bala_Proj\andy\winmail.dat: volume not valid or not requested (server: , session id: 19.)
    Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
    Error encountered by Backup Server. Please refer to Backup Server messages for details.


    Can Any body provide me vaiable solution.

    Regards
    Bala

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Off-hand I'd say that the file you are trying to use to load the database is not a Sybase dump. The "winmail.dat" name looks suspisciously like something generated by certain mail clients, and has strictly nothing to do with a Sybase db dump.

    Here's what the first part of a Sybase dump file looks like:

    [pepm01a@gvas1tkc6001 backup]$ od -a testdb.dat | head
    0000000 V O L 1 sp sp sp sp sp sp sp sp sp sp sp sp
    0000020 sp sp sp sp sp sp sp sp sp sp sp sp sp sp sp sp
    0000040 sp sp sp sp 0 sp sp sp sp sp sp sp sp sp sp sp
    0000060 sp sp sp sp sp sp sp sp sp sp sp sp sp sp sp sp
    0000100 sp sp sp sp sp sp sp sp sp sp sp sp sp sp sp 7
    0000120 nul nul nul nul nul nul nul nul nul nul nul nul nul nul nul nul
    *
    0004000 H D R 1 t e s t d b 0 6 0 4 0 0
    0004020 B 3 A E sp soh nul nul nul soh nul nul nul soh nul nul
    0004040 nul nul nul nul nul 0 0 0 1 0 0 sp 0 6 0 4
    [pepm01a@gvas1tkc6001 backup]$

    So the first 4 bytes in the file are VOL1.

    Michael

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    It might be a compressed file, try
    load database database_name
    from "compress::file_name"

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    if load database with listonly can read it then you can load it. Otherwise the dump file is unreadable by BS

Posting Permissions

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