Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2013
    Posts
    2

    Unanswered: Sybase log and data device issue

    I am a newbie to Sybase, been doing MS SQL for a while

    Made a mistake the other day. here it goes:

    Server: Sybase ASE15

    databases-4

    DB1
    DB2
    DB3
    DB4

    Devices-4(2 data and 2 log)(size 600 MB each)

    DEV_DAT1
    DEV_DAT2
    DEV_LG1
    DEV_LG2

    Each db has 100 MB dATA assigned on each of the 2 data devices
    Each db has 100 MB LOG assigned on each of the 2 LOG devices
    /all devices are shared by all databases/

    Made a mistake when expanding log device DEV_LG2, added 200 MB additional space
    as DATA (executed the wrong script with OVERRIDE clause)for database DB4 instead of LOG. Now the device shows as "log and data device" instead of "log only"

    database DB4 has select "into/bulk copy" checked, no logs are dumped, only truncate log at night, before full backup

    All other databases are in full recovery mode

    How can I fix this issue? or should I even worry about this?

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    You should be able to drop the data segment from the device
    sp_dropsegment segname, dbname , device

  3. #3
    Join Date
    Aug 2013
    Posts
    2
    What if some data is already written to it. how do I find out and if something is already written to it will Sybase warn me ?

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    If data already written I suggest you backup the db. Recreate db with data segments on data devices and log on log devices
    e.g. create database db4 on dat2=100,lg2=100,dat2=100 for load
    Make sure the sequence and size of the segments match as from sysusages order by dbid, lstart
    Load the DB and drop the log segment from the accidental data segment.

    If you don’t really need log backups then probably not too serious to leave as is depending on performance impact.

Posting Permissions

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