RecoverSybase - Revision history

Admin at 13:28, 17 January 2019

2019-01-17T13:28:48Z

Admin at 13:28, 17 January 2019

2019-01-17T13:28:25Z

Admin at 13:26, 17 January 2019

2019-01-17T13:26:45Z

Admin at 14:23, 28 September 2018

2018-09-28T14:23:32Z

Admin at 09:38, 28 September 2018

2018-09-28T09:38:32Z

Admin at 09:37, 28 September 2018

2018-09-28T09:37:42Z

Admin: 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%..."

2018-09-28T09:37:29Z

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%..."

New page

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

{|style="padding: 5px; width: 85%;"
| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''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.
|
|}
__NOTOC__

===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.
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
|
> create database pubs3
> on default = 4
|}

===Step 3===
Load the dump file.
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
|
> load database pubs3 from "compress::C:\Backup\BP\pubs3.dump"
> go
|}

===Step 4===
Bring the database online using online database command.
{| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
|
> online database pubs3
> go
|}

@@ Line 18: / Line 18: @@
 ==='''Step 3'''===
-Under '''Browse Directory''' select the Sybase database backup files to restore. In this example we are restoring database '''Pubs3'''
+Under '''Browse Directory''' select the Sybase database backup files to restore. In this example we are restoring database '''pubs3'''
 [[File:Sybase-RestoreSelection.jpg]]
 ==='''Step 4'''===
-Chose to restore to a different location, and change the target destination to a temporary location on the Sybase Server. '''i.e. C:\Backup'''
+Chose to restore to a different location, and change the target destination to a temporary location on the Sybase Server. '''''i.e. C:\Backup'''''
 ===Step 5===

@@ Line 18: / Line 18: @@
 ==='''Step 3'''===
-Under '''Browse Directory''' select the Sybase database backup files to restore.
+Under '''Browse Directory''' select the Sybase database backup files to restore. In this example we are restoring database '''Pubs3'''
 [[File:Sybase-RestoreSelection.jpg]]

← Older revision		Revision as of 09:38, 28 September 2018
Line 32:		Line 32:
	> go		> go
	\|}		\|}
		+
		+	----
		+	Use this link to go back to the main [[recoverydocs]] Page.

@@ Line 6: / Line 6: @@
 |}
 __NOTOC__
-===Step 1===
+==='''Step 1'''===
 Restore the image on the SQL client as a ".dump" file.
-===Step 2===
+===Step 6===
 Log in to the "isql utility" and  create the database to be restored.
 {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
@@ Line 17: / Line 36: @@
 |}
-===Step 3===
+===Step 7===
 Load the dump file.
 {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;
@@ Line 25: / Line 44: @@
 |}
-===Step 4===
+===Step 8===
 Bring the database online using online database command.
 {| class="wikitable" style="padding-left: auto; color:#FFFFFF; background-color: black; width: 600px; FONT-FAMILY:monospace,monospace; LINE-HEIGHT:15px; white-space: pre-wrap;

@@ Line 2: / Line 2: @@
 {|style="padding: 5px; width: 85%;"
-| style="width: 1%;"|[[File:Note.png|30px]]|| style="padding: 10px; width: 85%;"|'''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.
+| 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.
+|
 |}