Difference between revisions of "RecoverSybase"
From Tranzman Documentation
| Line 32: | Line 32: | ||
> go | > go | ||
|} | |} | ||
| + | |||
| + | ---- | ||
| + | Use this link to go back to the main [[recoverydocs]] Page. | ||
Revision as of 09:38, 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 |
Use this link to go back to the main recoverydocs Page.