Skip to Content
avatar image
Former Member

Backup database into manifest file

Hi,

I try to use QUIESCE command to generate the manifest file from my old server where I wish to restore it into my new server by running the following command code:

QUIESCE database name_tag hold databasename for external

dump to 'D:\name.manifest'

After I execute the command, system throw me an error message as below:

QUIESCE/PREPARE DATABASE: Device 'master' is also used by database 'master', which is not specified in this command.

SQLCODE=14538

May I know any idea to resolve this error. Please kindly advise.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 22, 2015 at 04:25 AM

    Are you trying to use the 'relocatable database' feature to unmount and move a database to another server? Or just needing to back it up to allow the backup to be reloaded on another server (and keep the database on the original server).

    Backup dumps can be performed on any online database just by running 'dump database ...' without preparation.  The backup files consume space and can be moved/loaded into another server.

    Using the 'relocatable database' feature actually unmounts the the database devices from the original server (writes the information into the manifest file - data remains on the original devices) and allows the devices to be physically moved to another ASE.  The database no longer exists on the original server.  The manifest file just contains information on how to remount the devices.  As such, the devices cannot contain any other database.  This is the error you are receiving - in this case the database also on the devices you are trying to unmount is 'master' (you are trying to unmount the master device) but could be any other database.

    To unmount a database requires it to be the only database on those devices.

    if you are just trying to perform a backup/restore, you should ensure the backup server is running and use 'dump database' on the source and 'load database' on the target..

    Chris

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Choon Fatt,

      The next window will ask for you hostname and port number

      You will then supply your hostname followed by a comma followed by a port number as shown in the highlight above.

      Capture.PNG (18.8 kB)
  • Oct 22, 2015 at 03:21 AM

    Dear Choon Fatt,

    I have moved your question to this space as it is a standalone ASE issue.

    Please post future questions to this space if they are involved on standalone ASE issue.

    Best regards,

    Gek

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 03:58 AM

    Dear Choon Fatt,

    The issue is that the databasename you pass in your command shares the same device as the one which is used by master database. That is why it complains master database is not specified in the command.

    You will need to move your databasename from the same device master to a different device not used by master database.

    Hope this helps.

    Cheers,

    Gek

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gek,

      May I know how I actually can move my database from device master to another device that not used by master database because the remove button is dim out.

      Please advise.

      Thank you.

  • avatar image
    Former Member
    Oct 27, 2015 at 01:42 AM

    Hi Guys,

    I have resolved my issue by install another new environment as a checkpoint for my old environment and I found that the sql.ini in the old environment is messed up. Hence, I copy the sql.ini from new environment to old environment, the backup server is up and running. I manage to backup the database and restore to other server.

    Thank you for providing the useful information.

    Add comment
    10|10000 characters needed characters exceeded