Solved

How to restore a database backup using Sybase Central?

Posted on 2001-07-19
6
1,765 Views
Last Modified: 2011-09-20
I am looking for a way to have my database backup then of course to restore it in case disaster happen.  The backup utility of the Sybase Central did the first step of backing up my database.  The big question is the second step; How can I restore the database I previously backed-up.

Any suggestions?
0
Comment
Question by:Sandy Kalugdan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 10

Expert Comment

by:bret
ID: 6300743
Is this ASE?

You create a database with the same order and size of segments  (see the sp__revdb procedure
at http://www.isug.com/Sybase_FAQ/ASE/section9.html#9.8.1 as a way to reverse engineer the
database DDL), then issue the LOAD DATABASE command.  Details are in the documentation,
which is available at http://sybooks.sybase.com.  (See the REFERENCE MANUAL for the
DUMP DATABASE and LOAD DATABASE commands, and the SYSTEM ADMINISTRATION GUIDE for
general advice).

-bret
).
0
 
LVL 3

Author Comment

by:Sandy Kalugdan
ID: 6300790
bret,

thanks for the early reply.  I've checked both links but neither mentioned about the DUMP/LOAD database.
0
 
LVL 10

Accepted Solution

by:
bret earned 100 total points
ID: 6300800
You do have to drill down from product area to product to the manuals for the version you are runnning to the
book in question.

Here is the ASE 12.0 generic doc set:

http://manuals.sybase.com:80/onlinebooks/group-as/asg1200e/asesag/@Generic__BookView

Here is a direct link to the LOAD DATABASE page in the reference manual for ASE 12.0

http://manuals.sybase.com:80/onlinebooks/group-as/asg1200e/aserefmn/@Generic__BookTextView/67339;pt=67339#X

Here is a direct link to Chapter 27 of the 12.0 SA Guide:

http://manuals.sybase.com:80/onlinebooks/group-as/asg1200e/asesag/@Generic__BookTextView/65043;pt=65043/*#X

-bret
0
 
LVL 3

Expert Comment

by:knel1234
ID: 6302258
Sandy...

Retrieving information from Sybase's online site can be really awkward at times.  You might want to get your hands on the Sybase Unleashed Book.  I dont have it on me but I can get you the publisher if needed (might be sybase press).  The commands (as bret stated) are basically "dump database 'database name'" and "load database 'database name'".  However, you may want (need?) to take advantage of stripping or other available options.

I went to sybooks.sybase.com (note: it moves you to a different URL) then in the search window i typed "dump database" and chose the first available selection.  It sent me to a page that discussed dumping to a tape and dumping to a hard drive, etc.

Let us know where you stand...
Is any of this helpful or do you need more info?

knel

ps the select i made sent me to this URL

http://manuals.sybase.com/onlinebooks/group-as/asp1150e/ntconfig/@ebt-link;pt=5817?target=%25N%14_5954_START_RESTART_N%25
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 9882655
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: bret

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

ChrisKing
EE Cleanup Volunteer
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
Gain an elementary understanding of Blockchain technology.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

688 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