Move ASE 12.5.1 to a different server

Posted on 2005-04-13
Last Modified: 2007-12-19
I have a Sybase ASE 12.5.1 running on Solaris 8.
I need to create an identical database on another Solaris 8 server.

Can I restore all the related files to server 2 from the backup of server 1? Backup was taken after the server was shutdown. Also if this is going to work is this way supported by Sybase?

Question by:sdrozd
    LVL 10

    Assisted Solution

    It can work.  The important thing is that there be no activity in the database as it is being
    copied.  This can be ensured using either the QUIESCE DATABASE command, or shutting the server

    In general - search the ASE documentation for QUIESCE to find out how it is supported.
    In particular, see chapter 27 on mounting and unmounting databases.

    LVL 2

    Author Comment

    Thanks Bret.

    I shutdown the server, so I shouldn't need to consider using quiesce command. My paths to the devices are the same, so it doesn't look like I need to use mount either.

    I also don't see why it shouldn't work, but I am more concerned about doing things the supported way. For example, if I have a production problem on that server I would like to make sure Sybase will not frown upon using this method..

    Please let me know if you have the answer to this.

    Thanks a lot!
    LVL 24

    Accepted Solution

    Copying the underlying files in the way you've said isn't supported by Sybase as a backup method.

    It's supported when used in conjunction with quiesce database, or unmount/mount.
    LVL 2

    Author Comment

    Thanks to both of you. I split the points evenly
    LVL 24

    Expert Comment

    by:Joe Woodhouse
    Glad we could help! Since you very specifically asked for supported methods, I was conservative - but with the servers shut down, and with you editing the interfaces file to reference the second host, it will work.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now