Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Unanswered: shrink data device

    hi Guys,
    I've accidentally resize logical data device with the last same logical device name, unfortunately when i checked the space i don't need to add new data space since the space already enough. is there an option on sybase to revert back the resize logical space?

    I'm running
    sybase ASE 12.5


  2. #2
    Join Date
    Jan 2004
    Provided Answers: 4
    There is no command to shrink a data device, and no other safe, supported way.
    If you have not yet extended your database on that device so it uses the huge amount of space you can follow these steps:
    - make sure you write down in what order your database has been created on the devices (i.e. data, log, data, data, log) so you can recreate the database in the exact same order.
    - backup your database
    - drop your database
    - drop the device that is too big and recreate it with the normal/previous size
    - recreate your database according to the script/specifications you wrote down in step 1
    - load the dump
    I'm not crazy, I'm an aeroplane!

Posting Permissions

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