Results 1 to 2 of 2

Thread: 'sybsecurity'

  1. #1
    Join Date
    Nov 2002

    Post Unanswered: 'sybsecurity'

    Hi all

    This is the error i recieved when i was trying to delete a user from gtsecurity who is having sa and sso role.

    Database 'sybsecurity' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.

    Please can any one suggest me the reason of the error and what is the solution?


    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2002
    Hong Kong

    Re: 'sybsecurity'

    When the server starts up or when a database is brought online (online database command), the server "recovers" the database by reading the transaction log and applying any committed transactions and rolling back anything that isn't committed.

    While doing this the server may have found something nasty in the transaction log - you'll have look in the error log to get some idea of what. Anyway the server couldn't deal with whatever the problem was and you have to do some manual intervention to correct it.

    Your options are:
    1) Sort the problem out
    2) Drop and re-create the database and load from recent dumps

    Option 1 is the most preferable, 2 may result in some loss of data, depending on what is being audited in sybsecurity.

Posting Permissions

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