Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Increasing size of master database in sybase

    I would like to know is it possible to increase the space of master after your databases have been setup and populated? In running a job on the test database, the message about the transaction log is full was received.

    Comparing the production db setup with the test, we found that test master is 70MB smaller than production. However, the structure and data that is being used on test is the same that is being used on production.

    I don't know if master can be increased using the alter database command or does it mean we are out of luck unless we delete and reinstall the database.

    Help is appreciated.

  2. #2
    Join Date
    Dec 2001
    Posts
    16

    you can

    Hi ,

    you can alter master database if you have enough free space in master device. execute below command

    alter database master on master = 4
    go



    Siva

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya swimbley,

    Just adding on what Siva advised, master on be altered only onto a master device.

    Even if you run out of space on the master device and cannot alter anymore, all is not lost. Simply bcp out sysdatabases, sysusages, sysdevices, syslogins, sysloginroles, sysconfigures and syscharsets from the existing master.
    Build a new master(whatever size) and bcp back in those tables.

    Cheers
    Willy

  4. #4
    Join Date
    Oct 2002
    Posts
    2
    Originally posted by willy_and_the_ci
    Hiya swimbley,

    Just adding on what Siva advised, master on be altered only onto a master device.

    Even if you run out of space on the master device and cannot alter anymore, all is not lost. Simply bcp out sysdatabases, sysusages, sysdevices, syslogins, sysloginroles, sysconfigures and syscharsets from the existing master.
    Build a new master(whatever size) and bcp back in those tables.

    Cheers
    Willy
    Thank you very much!! I did run into the space problem and was not sure what to do.

Posting Permissions

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