Skip to Content
Author's profile photo Former Member

Backup & restore operations in sybase

Procedure -2:

Sybase backup using isql command through cmd


new3.PNG

Step-1:connect with database using isql –Usapsa –S<sid> -X


Step-2:enter the password


Step 3:enter the command for taking the backup and specify the location and file name

DUMP DATABASE SID TO “LOCATION\FILENAME.DMP”


Step-4:enter go

new4.PNG

Step-5:

Later on backup is done at specified location

/wp-content/uploads/2016/03/new5_907633.png


Done


Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Pradeep Kumar
      Pradeep Kumar

      Hi Santhosh,

      Nice and clear however could you please add restore part as well since the blog title itself backup and restore. At least add the best practices/SAP recommendations/SAP notes/Wiki links for restore which will make the blog complete!.

      Thanks,

      Pradeep

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi pradeep,

      Thanks for your comments and i will update the document as per your suggestions.

      Thanks,

      Mpssanthosh.

      Author's profile photo Priyatha Jeyarhaaj
      Priyatha Jeyarhaaj

      thank you.