Difference between revisions of "RecoverSybase"

From Tranzman Documentation
Jump to: navigation, search
(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%...")
(No difference)

Revision as of 09:37, 28 September 2018

Follow the steps on this page to recover a Sybase database.

Note.png 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