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 Tamilarasan B
      Tamilarasan B

      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.