Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Posts
    18

    Unanswered: How to delete a corrupted Sybase database

    This morning, I interrupted a Sybase database which was being restored for some reasons.
    I want to delete it and then restore it again, however, it doesn't allow me to delete and only provided 4 options to me when I righ-clicked it :
    Restore, Reallocate Space, Delete and Properties.

    Can I choose 'Restore' to continue the Restore ?
    Or I want to start again from fresh, how can I delete this db ?

    Please tell me, thanks.

  2. #2
    Join Date
    Aug 2008
    Posts
    3
    dbcc dbrepair ("dbname", dropdb)

  3. #3
    Join Date
    Sep 2008
    Posts
    18
    Thanks.
    But can I choose "Restore" to continue the Restore process ?

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    No, can't continue the restore. Just start another restore.
    No need to drop the database.

    For dbcc dbrepair ("dbname", dropdb) to work
    The database must be marked suspect
    You might have to
    update sysdatabases set status=320 where name="dbname"

  5. #5
    Join Date
    Sep 2008
    Posts
    18
    Last night, I dropped the db successfully (thanks your "dbcc" reply) and started the restore again and completed successfully.
    Thanks a lot.

Posting Permissions

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