Backup/Restore of Sybase Database

Posted on 2007-10-12
Last Modified: 2008-01-09
In Sybase ASE 12.5.2, is it possible that a database backup can be split across 2 files? if so how can they be restored?
Question by:Singnetsvc
    LVL 19

    Accepted Solution

    If you look at the doc for "dump database....", you will see that you can specify "stripe on" multiple times.  Each time points to a dump device, either implicit or explicit.  You are probably using implicit dump devices; that is you just specify the file name you want the dump to go to.

    There is another option to do compression as well which can reduce your headaches if you are bumping up against a 2GB file size limitation or simply don't have enough disk space.

    Finally, the "restore database" command allows you to specify multiple "from" files which is how you get the whole thing back into the database.

    Dump Database doc is here:

    There is also a great deal of information about backups and recovery procedures in the Admin manual, here:

    LVL 3

    Author Comment

    Using load database with stripe parameters seems to have worked.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Outlook Free & Paid Tools
    PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    728 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

    16 Experts available now in Live!

    Get 1:1 Help Now