Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Post Unanswered: Pls. view the error message and suggest

    Hi Friends,

    This error message was shown when RESTORING the database

    Backup Server session id is: 45. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
    Backup Server: 6.28.1.1: Dumpfile name 'platdb0328806A19 ' section number 1 mounted on disk file 'e:\platdb.dump'
    Attempt to read a dump header failed; returned error code is 10.
    Unexpected end of file while reading beginning of dump. Please confirm that dump media contains a valid SQL Server dump. The SQL Server error log may contain more information on the problem.
    Database 'mdrrepdb' is now online.


    Thanks
    A friend in need is a friend in deed

  2. #2
    Join Date
    Nov 2002
    Posts
    94
    Can you give some more details . what platform you are on, Unix - AIX, Solaris, NT ? , Sybase 11..12.5 ?
    dump taken with strip ? , loading with strip ?

  3. #3
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33
    Originally posted by ramshree
    Can you give some more details . what platform you are on, Unix - AIX, Solaris, NT ? , Sybase 11..12.5 ?
    dump taken with strip ? , loading with strip ?
    I use windows 2000 server, Sybase adaptive server enterprise 12.5
    A friend in need is a friend in deed

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Your dump file is incomplete or corrupt

  5. #5
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Post Restore (load) error

    Dear friends,

    I would like to give you more hint. The dump which i have recieved is from a sun unix machine and the sybase version is 11.9.2.4, i am using version 12.5 on a windows 2000 server.

    Does the OS platform matter. what are the other things i should keep in mind, eg. pagine etc., while creating a blank database so i can restore the dump into it. the size of the dump is 1.5 GB.

    Pls. let me know if you need any more info.

    This matter is of utmost urgency

    Thanking You,
    Amit
    A friend in need is a friend in deed

  6. #6
    Join Date
    Jan 2004
    Location
    Munich/Germany
    Posts
    12

    Re: Pls. view the error message and suggest

    You can not use cross platform backup files

    Use some modelling tool (power designer, ERWIN) to reverse engineer the database, then use bcp out/in to copy the data over.



    Originally posted by versoft
    Hi Friends,

    This error message was shown when RESTORING the database

    Backup Server session id is: 45. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
    Backup Server: 6.28.1.1: Dumpfile name 'platdb0328806A19 ' section number 1 mounted on disk file 'e:\platdb.dump'
    Attempt to read a dump header failed; returned error code is 10.
    Unexpected end of file while reading beginning of dump. Please confirm that dump media contains a valid SQL Server dump. The SQL Server error log may contain more information on the problem.
    Database 'mdrrepdb' is now online.


    Thanks

  7. #7
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Talking Re: Pls. view the error message and suggest

    Thanks for the suggestions. I have created the schema on my machine, can you please tell me how to use BCP utility from grounds up

    Thnaking You!


    Originally posted by stormnorm
    You can not use cross platform backup files

    Use some modelling tool (power designer, ERWIN) to reverse engineer the database, then use bcp out/in to copy the data over.
    A friend in need is a friend in deed

  8. #8
    Join Date
    Jan 2004
    Location
    Munich/Germany
    Posts
    12

    Re: Pls. view the error message and suggest

    1- use the following to bcp out
    bcp db_name.object_owner(eg. dbo).tab_name out file_name(i.e. table_name.bcp) -C -Uuser_id -Sserver_name -Ppassword

    2- ftp the files to the target machine
    3- use the following to bcp in

    bcp db_name.object_owner(eg. dbo).tab_name in file_name(i.e. table_name.bcp) -C -Uuser_id -Sserver_name -Ppassword -e error_output_file(a file to hold errors if any occur)


    For more information on bcp check this link for unix
    http://sybooks.sybase.com/onlinebook...okView;lang=de

    and this link for NT
    http://sybooks.sybase.com/onlinebook...okView;lang=de

    Good luck




    Originally posted by versoft
    Thanks for the suggestions. I have created the schema on my machine, can you please tell me how to use BCP utility from grounds up

    Thnaking You!

  9. #9
    Join Date
    Jan 2004
    Location
    Munich/Germany
    Posts
    12

    Re: Pls. view the error message and suggest

    Appologies

    the "-C" should be lower case letter "-c"


    Originally posted by versoft
    Thanks for the suggestions. I have created the schema on my machine, can you please tell me how to use BCP utility from grounds up

    Thnaking You!

  10. #10
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Cool Re: Pls. view the error message and suggest

    Thank you my friend, that will help me a lot. Hoping to see you again.

    Thanks
    Amit V
    A friend in need is a friend in deed

Posting Permissions

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