Difference between revisions of "RecoverSybase"
From Tranzman Documentation
| Line 2: | Line 2: | ||
{|style="padding: 5px; width: 85%;" | {|style="padding: 5px; width: 85%;" | ||
| − | | style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' The page size of the | + | | style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''Note:''' The page size of the dump to be restored and of the ASE server should be matched. Run the batch file process located on "C:\SAP\ASE-16_0\install\RUN_WINSYBASE.bat" to display the page size. |
| | | | ||
|} | |} | ||
Revision as of 14:23, 28 September 2018
Follow the steps on this page to recover a Sybase database.
 |
Note: The page size of the dump to be restored and of the ASE server should be matched. Run the batch file process located on "C:\SAP\ASE-16_0\install\RUN_WINSYBASE.bat" to display the page size. |
Step 1
Restore the image on the SQL client as a ".dump" file.
Step 2
Log in to the "isql utility" and create the database to be restored.
|
> create database pubs3 > on default = 4 |
Step 3
Load the dump file.
|
> load database pubs3 from "compress::C:\Backup\BP\pubs3.dump" > go |
Step 4
Bring the database online using online database command.
|
> online database pubs3 > go |
Use this link to go back to the main recoverydocs Page.