Question Re: Sybase ASE database backup procedure. in Additional Q&A

Sybase ASE database backup procedure.

Former Member — Wed, 24 Feb 2016 06:55:22 GMT

Hi all,

Actually i configure the solution manager 7.1 system preparation and basic settings also finished. Currently i configured MOPZ for updating the Patch sp9 to sp14. So that now i want to take backup of sybase backup, i am new to sybase database . Please tell the procedure for sybase ASE databse backup.

Regards

Rajesh

Re: Sybase ASE database backup procedure.

yakcinar — Wed, 24 Feb 2016 08:15:53 GMT

Hello Rajesh,

These blogs can help you.

Backup and restore Sybase ASE 15.7 database | SCN

Regards,

Yuksel AKCINAR

Re: Sybase ASE database backup procedure.

hans-juergen_schwindke — Wed, 24 Feb 2016 12:14:28 GMT

Hi,

you can find a description in my reply in this discussion:

Best regards,

Juergen

Re: Sybase ASE database backup procedure.

Former Member — Fri, 26 Feb 2016 05:44:50 GMT

Hi Yuksel,

I have login with my solman and executed tcode db13 but its shows correctly, then how do take backup.

Re: Sybase ASE database backup procedure.

yakcinar — Fri, 26 Feb 2016 21:36:03 GMT

Hello Rajesh,

Goto Database SMR first.

There you can see "Backup and Recovery" and "Jobs" tabs.

In Backup and Recovery you can see database dump history.

In Jobs you can use "Add" button to schedule an action.

In action selection there is SQL Script. For SQL script you can write "dump database SMR using config = 'SMRDB'" to schedule your DB backup and write dump transaction SMR using config = 'SMRLOG' for log backup.

(SMRDB and SMRLOG configurations must be prepared like the ones in note 1588316 - SYB: Configure automatic database and log backups)

If you donot want to use configurations you can write below SQL scripts directly for DB and transaction backups.

dump database SMR to 'D:\backup\SMRbck.dmp' with verify = full, compression = 100

dump transaction SMR to 'D:\backup\SMRTrns.trn' with compression = 101

You can define schedule date, recurrence in Add action wizard.

Regards,

Yuksel AKCINAR

Re: Sybase ASE database backup procedure.

former_member212573 — Tue, 08 Mar 2016 14:45:45 GMT

Hi Rajesh,

Please tell me about the below points

1.whether you have configured the backup dumping setup?

2. The OS you are using...

Regards,

Pankaj

Re: Sybase ASE database backup procedure.

Former Member — Wed, 09 Mar 2016 04:57:55 GMT

Hi Pankaj,

Just few weeks before i installed solman with sybase OS , i am not configured dumping setup.

I am using OS is Windows 2012 R2 standard.

Regards

Rajesh

Re: Sybase ASE database backup procedure.

former_member212573 — Wed, 09 Mar 2016 05:51:08 GMT

Hi Rajesh,

Please follow the below step for dumping the database and its log in sybase ASE

configuration for Database backup in SYBASE

____________________________________________

1) Login to OS level and switch to syb<sid>

2) Ensure you have the folders created for backup

e:\backup

e:\backup\db #(for dumping database backup file)

e:\backup\log #(for dumping database log backup file)

2(A) to give permission and assign group to directory

3) Login to command line sql utility of sybase database as:

Here I have taken SID as SMD

isql64 -Usa -P<password> -S<SID> -X

Example:-isql64 -Usa -PApassw0#d -SSMD -X

4) You are only allowed to create the backup config in master database, the below command will help you create a config to be used for database backup

1>sp_config_dump @config_name = 'SMDDB' ,

2>@stripe_dir = 'E:\backup\db' ,

3>@compression = '101' ,

4>@verify = 'header'

5>go #watch out for the ','

5) in case you are not in master database, you can check this and go to master database as follows:

1>select db_name()

2>go #this command will give you the name of the database you are currently using

6) in case the result is not master, you can use master database using the following command:

1>use master

2>go

7) if the creation of backup config is successful, you will get the below confirmation message:

The change is completed. The option is dynamic and ASE need not be rebooted for

the change to take effect.

(return status = 0)

configuration for transaction log backup in SYBASE

___________________________________________________

1) You are only allowed to create the backup config in master database, the below command will help you create a config to be used for transaction backup

1>sp_config_dump @config_name='SMDLOG' ,

2>@stripe_dir = 'E:\backup\log' ,

3>@compression = '101' ,

4>@verify = 'header'

5>go

2) if transaction log truncate option se set to true, the log backup will not work and you will get a prompt from sybase database to set it to false, the message back from the sybase is as below:

Msg 4208, Level 16, State 1:

Server 'PID', Line 1:

DUMP TRANsaction to a dump device is not allowed while the trunc. log on chkpt.

option is enabled. Disable the option with sp_dboption, then use DUMP DATABASE,

before trying again.

You can set the truncate option to false as below:

1>sp_dboption SMD,'trunc',false

2>go

3) After this you will be prompted to execute checkpoint in <SID> database which is done as below:

1>use SMD

2>go

1>checkpoint

2>go

Note:- After dumping transaction log you will be able to do database dumps

4) Once you are done with this, you may go back to master database and fire the dump transaction

(You will have to execute dump database before you can use dump transaction) as shown below:

1>dump transaction SMD using config='SMDLOG'

2>go

5) Now, you will be able to trigger the backup using the below command:

1>dump database SMD using config = 'SMDDB'

2>go

6) Once, this is successful, you may want to schedule this as a regular task in your database calender using DBACOCKPIT

Regards,

Pankaj

M:-+91 8511730039

mail:-pankaj3176@gmail.com

Re: Sybase ASE database backup procedure.

Former Member — Wed, 09 Mar 2016 11:27:45 GMT

Hi Pankaj,

Thank you for valuable reply, I am having the issue i.e isql utility is not connecting.

Regards

Rajesh

Re: Sybase ASE database backup procedure.

Former Member — Wed, 09 Mar 2016 12:53:54 GMT

Hi Rajesh,

Could you please brief step-by-step where you are failing

Regards,

Pankaj