太太药业SAP R3系统备份策略及操作指.DOCVIP

备份策略 Online Backup Database Cause SQL server has an very highly automatic online backup ability, so the database online backup will be an complete backup on 00:00 Saturday and an differential backup on everyday. R3 database – full backup on Sunday and differential everyday All database – all full backup on Sunday Database Transaction Log 由于以上的Full Backup和Differential Backup，进一步进行Transaction Log Backup的最大好处在于在保证每次Differential Backup和Transaction Log Backup之间几个小时的交易数据的安全，但实际作用有限，并且较为消耗磁盘存储系统，故不再进行Transaction Log Backup. Offline System Full 定于每周六下午两点至晚上七点为作Offline Backup时间，此时间SAP R3系统将不可用 备份相关设置 R3DEV(开发系统)与R3PRD(生产系统)的不同－备份设备及备份策略 鉴于在项目的不同阶段对系统数据的改变和数据的依赖性不同，在项目上线前对开发系统的备份优先级要设为最高，必须针对开发系统和\\MYCWSERVER\SAP999目录同时作以上两种备份，而生产系统在做完数据转换之后，备份的优先级要升为最高，对于培训系统则不计划作备份，依靠系统自身硬件的冗余来保证可靠性 考虑到生产系统为最终实时使用系统，其备份设备使用容量和传输率较高的QUANTUM DLT8000磁带机作为备份设备，而开发系统使用一台HP DAT40E磁带机，对\\MYCWSERVER\SAP99的备份则纳入CA Archserve的网络备份任务当中 备份软件CA Archserve和Windows NT Backup的设置 CA Archserve: Network backup ArcserveIT – Job Status – Modify Job – Source – Network – Microsoft Windwos Network – Xldomain – Exchange_server – Registry, Microsoft Exchange Server – Brick Level – Client Agents – Windows NT Agents – Cwserver_IP (Registry, E:\cyb,E:\hscw,E:\mycydep,E:\mypccw,E:\Pccw,E:\YJ999,E:\考勤系统)；Home_IP(registry,d:\inetpub\wwwroot); MYCWSERVER_IP(REGISTRY,D:\ERPARCH,D:\MSSQL7\DATA,D:\TEMINALSALES); PDC_IP(REGISTRY, C:\) ArcserveIT – Job Status – Modify Job – Destination – Blank ArcserveIT – Job Status – Modify Job – Schedule – Use Rotation Scheme –Scheme Name: 7-day weekly differential backup, full backup on Sunday, with … Disable GFS Media Pool Name – SERVERS_WEEKLY ArcserveIT – Job Status – Modify Job – Options – Log option Windows NT – Offline system Controll Panel – service – MS SQL 7.0 Database and transaction log backup can be setup in database – management – database maintenance plan. Database differential must use database – all tasks – backup Master database can’t use differential backup method R3 d