A database is a collection of logically related data that are processed by software systems and are used to meet the needs of users in various kinds of information. When the database "crashes", that is, fails, do not pull your hair out in a panic. There are several ways to get things back on track.
Instructions
Step 1
Check for the presence of the base to which you will dump the dump. If there is none, then it must be created. Remember that the database dump will only fall on the same size as when it was saved. The dimensions of the base are specified at the time of its creation.
Step 2
Raise the base from the ISQL command line or any editor like DbArtisan. To do this, consider the isql command line. At the start command prompt, type c:> isql -Usa -P (password, if any) - S (default server name is the current computer). This will bring up the prompt 1>. Type 1> use master. 2> go. 1> load database NameDB from `c: ???. Dmp`. 2> go; / * ------- * / If required, then roll up the logs: 1> load transaction NameDB from `c: ???. Log`. 2> load transaction NameDB from `c: ???. Log`; 3> load transaction NameDB from `c: ???. Log`; 4> go. / * ------- * /; 1> online database database name. 2> go.
Step 3
Restore the database from Sybase Central. To do this, go to the Databases folder, right-click on the base barrel and click restore / next. Click the Add / Explicit Dump Device button / specify the Physical Path: `c: ???. Dmp / ok. Then click the Next and Finish buttons. With this method, the database will remain unavailable until you run the command from SQL Advantage> online database database name for it.
Step 4
Bring up the database using the DUMP up command. To do this, on the command line, type dump database akvilon to “c: /dump_name.dmp”, then go, then type online database database name and go again.
Step 5
Also, the database can be "rolled back". To make a backup press the Start / Run button. In the window that appears, type cmd and hit enter. For sequential authorization, type osql - S (server) –U (login) –P (password), for Windows: osql - S (server) –E. Then type the backup program: 1> backup batabase BASE NAME to disk = `PATH TO THE LOCATION WHERE THE BACKUP WILL LIE 'with stats = 1; 2> go; 1> exit.
