Sybase backup and restore
来源:互联网 发布:php判断时间范围 编辑:程序博客网 时间:2024/05/16 10:30
SAP Notes: 1588316 - SYB: Configure automatic databaseand log backups
1. Createfolder for backup databases and transaction logs
/sybase/DL4/sapdata_1/backups
/sybase/DL4/sapdata_1/log_archives
2. Createyour dump configuration with stored procedure 'sp_config_dump'. If the name ofthe database is, for example, DL4:
use master
sp_config_dump @config_name ='DL4DB',
@stripe_dir = '/sybase/DL4/sapdata_1/backups',
@compression = '101' ,
@verify = 'header'
go
Configuration DL4LOG:
sp_config_dump @config_name ='DL4log',
@stripe_dir = '/sybase/DL4/sapdata_1/logarchives',
@compression = '101' ,
@verify = 'header'
go
3. Changethe DB parameter below:
sp_dboption 'DL4','trunc log on chkpt','false'
sp_dboption 'DL4','enforce dump tran sequence','true'
4. Databaseand transaction dumps can now be performed using the 'using config' syntax.
Example:
dump database DL4 using config = 'DL4DB'
go
dump transaction DL4 using config = 'DL4log'
go
5. Restoredatabase:
load database DL4 from '/sybase/DL4/sapdata_1/backups/DL4.DB.20160330.153542.000'
Recovery log files:
load transaction DL4 from'/sybase/DL4/sapdata_1/log_archives/DL4.TRAN.20160330.155435.000'
6. Createand schedule ASE jobs to backup databases and transaction logs
Use the DBA Planning Calendar in the DBACOCKPIT toautomatically call the 'DUMP DATABASE' and the 'DUMP TRANSACTION' commands.
- Sybase backup and restore
- XCloner - Backup and Restore
- Ubuntu backup and restore
- DB2 Backup and Restore
- MySQL Backup and Restore
- SQL Server backup and restore
- win 7 backup and restore
- MySQL Database backup and restore
- TFS Express backup and restore
- Backup/Restore Redis and ElasticSearch
- BACKUP... VALIDATE、VALIDATE and RESTORE VALIDATE
- Howto: Backup and restore your system!
- Backup and Restore MySQL Database Using mysqldump
- sharepoint Backup and Restore using STSADM
- mysql export & import (backup and restore)
- MySQL 编码转换,backup and restore
- quick ubuntu system backup and restore
- Backup and Restore Search Service Application
- dijkstra算法与prim算法的区别
- selector 选择器基础用法
- 对象的比较与排序:IComparable和IComparer接口
- Qt设置窗口标题和exe图标
- 淘宝手机刷钻可行性分析
- Sybase backup and restore
- Android IntentService完全解析 当Service遇到Handler
- Android开发中adb启动失败adb连接异常的解决办法
- mongodb数据结构-树
- Qt组件之文本框类
- 17. Letter Combinations of a Phone Number(46.02%)
- 史上最全远程推送详解之极光推送
- jar包安装到本地库 maven
- RAID基础知识