Difference between revisions of "RecoverSybase"
From Tranzman Documentation
(Created page with "Follow the steps on this page to recover a Sybase database. {|style="padding: 5px; width: 85%;" | style="width: 1%;"|30px|| style="padding: 10px; width: 85%...") |
|||
| Line 6: | Line 6: | ||
|} | |} | ||
__NOTOC__ | __NOTOC__ | ||
| − | |||
| − | |||
===Step 1=== | ===Step 1=== | ||
Restore the image on the SQL client as a ".dump" file. | Restore the image on the SQL client as a ".dump" file. | ||
Revision as of 09:37, 28 September 2018
Follow the steps on this page to recover a Sybase database.
 |
Note: The page size of the sump 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 |