Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Unanswered: Unable to extend database

    I am unable to extend a database on sybase server and am getting the following errors

    Attempt to insert duplicate key row in object 'sysusages' with unique index 'sysusages'

    The device is not allocated to any other database and shows all 10gb as availaible for allocation

  2. #2
    Join Date
    Aug 2004
    Try putting the database into single user and then using:

    dbcc dbrepair(databasename,remap)

    Although if this is a prod database/server you might want to give Sybase Tech Support a call first as I'm not sure that this is a documented fix.

Posting Permissions

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