Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    24

    Unanswered: Recovering from lost master database

    A win2k server lost the drive that the master.dat was on, but no other drives. I rebuilt the master database with the buildmastr command, updated the entry on the backup server name and when I try to load the master from a dump I get an error in regards to the character set and sort order.

    The solution in the sybase manual is to use dbcc traceflag 3100. This didn't work for me. I should probably also mention that the sybsystemprocs isn't online, so I can't do an sp_configure on the charset or sortorder.

    Any thoughts?
    Last edited by madamos; 10-16-06 at 14:16.

  2. #2
    Join Date
    Sep 2006
    Posts
    15
    If you have a backup of the master.
    1. Create a new server with the master size the same as your backup.
    That includes the sybsystemprocs.
    2. Change your sort order from the sybinit(Unix) or SYCONFIG(Windows)

    3. Restart the server in single user mode -m

    4. Load the backup master database.

  3. #3
    Join Date
    Apr 2004
    Posts
    24
    Yeah, seemed like something in that vein would be the answer, in the end pretty much what I did last night. Since I could start sybase with the blank master that the utility had made I opened syconfig and went to configure adaptive server and reset the sort order and charset. Apparently when I ran it it created a sybsystemproc to allow it to run, so I guess that it must have ran the sybinit when I changed the setting.

    In the end I'm not sure I saved a lot of time, I still had to restore the databases from backups as the transaction logs were on the same disk as master.

    Thanks for the assistance.

Posting Permissions

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