Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Location
    India
    Posts
    50

    Unanswered: Move device fragment to other device

    Hi All,

    Could you please confirm me on below

    (1) How to move a device fragment from one device to other device in sybase.
    (2) how to drop the device fragment on a device.
    Last edited by Neevarp; 11-14-10 at 02:35.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    backup the database
    drop and recreate the db for load with fragments on desired devices
    Note: fragments must be in same sequence as from the original db
    load the db from backup

    Are you maybe looking for
    sp_addsegment
    sp_dropsegment

Posting Permissions

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