Results 1 to 4 of 4

Thread: Master Database

  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Unanswered: Master Database

    Hi,

    master database is full. How can I increase the size of the master database.
    Can anyone help me in this.

    Thanks,
    Arun N.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Lightbulb

    If master device is not full:
    BEGIN
    Code:
    ALTER DATABASE master on default=n
    END
    else
    BEGIN
    if ASE version > 12.0
    Code:
    disk resize name="d_master", size=51200
    else
    BEGIN
    1) dump database master to a file
    2) Recreate a new ASE with a biger master device
    3) stop your initial ASE
    4) reload the master dump to the new ASE
    5) Stop it, rename it and restart it
    END
    END

  3. #3
    Join Date
    Feb 2004
    Posts
    9
    Thanks a lot.

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Small detail : to reload a master database, you must start your ASE using -M flag

Posting Permissions

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