Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008
    Posts
    1

    Unanswered:

    what r the reasons for a database to go to suspect mode in sybase and what r the steps to recover it

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Quote Originally Posted by sadishkumar
    what r the reasons for a database to go to suspect mode in sybase and what r the steps to recover it
    Looks like an interview question to me. Have you faced a suspect problem? If so, please give details. If you are just curious, then the core reasons for a db to be marked suspect is

    a) when for some reason, it doesnt have access to the devices it was originally created on.
    b) theres some corruption in the database.

    The suspect situation is not something you plan/prepare for, and thats why they termed it "suspect" and basically you react to the situation based on the errors ASE is showing you.

    So, the way to recovery totally depends on how it got into suspect mode.

Posting Permissions

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