on 02-24-2016 6:55 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rajesh,
These blogs can help you.
Backup and restore Sybase ASE 15.7 database | SCN
Regards,
Yuksel AKCINAR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
go
dump transaction SMR to 'D:\backup\SMRTrns.trn' with compression = 101
go
You can define schedule date, recurrence in Add action wizard.
Regards,
Yuksel AKCINAR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.