备份系统当前的概况

备份系统当前的概况目前可支持策略全备份差异备份日志备份最小频率每天每天每小时最大频率每周//数据保留周期8周B．覆盖的业务系统，数据库备份策略说明所属系统hostnameSQLIPDatabase_Name全备差异日志PMS主库HQ-C0SQL-01HTPMS√√√HTPMSBase√√√ReportServer√√√PMS分库SQLSEV-02HTPMS√×√HTPMSBase√×√ReportServer√×√PMS分库SQLSEV-03HTPMS√×√HTPMSBase√×√ReportServer√×√PMS分库SQLSEV-04HTPMS√×√HTPMSBase√×√ReportServer√×√ECRMHQ-S0SQL-03HanTing_Audit√×√HTCRM√××HTCRM_CalResult√××PCRMHQ-C0SQL-02HtinnsCRM√×√RCITDB√××AutoPos√×√HTcallCenter√×√免房券HZVM0049HtECoupons√×√HtScratchCard√×√HtECouponsHelper√×√官网INTERWEBAPP_PUSH√√×AutoCheckIn√√×CentralGateway√√×HomeInnsWarning√√×HTCampus√√×HTWiki√√×NewSMS√√×ThankfulEmail√√√WebADTraceDB√√√WebSiteDBTest√××HTPayCenter√××中介直连HQ-S0SQL-10ACCM_DB√√×ReportServer√××大活动Vact-sql-01Activity√×√银联支付Vpay-sql-01UnionPayDB√×√采购报销vrds-work-01HT_eAccounting√√×HT_eAccounting_Attachment√√×HT_eAccounting_Log√√×NCOraclHQ-S1NCS-05htjd√×√IPL人事系统hq-s1hrs-02HITINNSSession√××Ipl.Hrms.Htinns.Sys√××Ipl.Hrms.Htinns.JM√××IncentivePlan√××TM1hq-s1bis-01ReportServer√√×HTFPM√√×WEBSITEDB√√×CM√√×ETLTemp√√×BI_ODS√√×HtECoupons√××HtECouponsHelper√√×NCLinkServer√√×GateLockUpload√√×TFS源代码管理HQ-S1TFS-01ReportServer√√×ReportServerTempDB√√×SharePoint_Config√√×SharePoint_AdminContent_87a8d6ae-0a39-4f1d-9213-c6d92d1508da√√×WSS_Content√√×WSS_Content_TFS√√×Tfs_Warehouse√√×Tfs_DefaultCollection√√×Tfs_Configuration√√×Solarwinds监控系统hq-slo-03ConfigMgmt√××SolarWindsOrion√××虚拟化VcenterHZVC-01.VCServerName_VCDB√××BIHQ-S0SQL-06DB_Budget√××DB_DW√××GOP√××SyncWebPMS√××HT_eProcurement√××DB_ODS√√×FranchiseFee√√√Hostel√√×HT_DR√√×HTHotelWage√√×MDM√√×USERBASE√√×USERPLUS√√×YUNYING√√×C．磁带备份周期及周转情况说明常规备份（每日1盘），只写入除PMS主库全备份以外所有的备份数据。全备份（每周2盘）：只写入PMS主库全备份数据。磁带周转明细如下（4/1-5/31）：磁带编号对方公司磁带编码备份日期备注B03911L4T0000927712014/4/1000226L4T0000905312014/4/2000230L4T0000905272015/4/2PMS全备份403484L4T0000947702015/4/2PMS全备份000227L4T0000905302014/4/3000228L4T0000905292014/4/4000229L4T0000905282014/4/5B03850L4T0000905262014/4/6B03851L4T0000905252014/4/7B03853L4T0000905222014/4/8B03854L4T0000905202014/4/9403483L4T0000915152015/4/9PMS全备份403452L4T0000947692015/4/9PMS全备份B03855L4T0000905192014/4/10B03856L4T0000905182014/4/11B03857L4T0000905172014/4/12B03858L4T0000905162014/4/13B03840L4T0000905152014/4/14B03841L4T0000905142014/4/15B03842L4T0000905132014/4/16B03859L4T0000905212015/4/16PMS全备份403482L4T0000947682015/4/16PMS全备份B03843L4T0000905122014/4/17B03844L4T0000905112014/4/18B03845L4T0000905102014/4/19B03846L4T0000905092014/4/20B03848L4T0000905072014/4/21B03849L4T0000905062014/4/22B03860L4T0000905052014/4/23B03847L4T0000905082015/4/23PMS全备份403465L4T0000947672015/4/23PMS全备份B03861L4T0000905042014/4/24B03862L4T0000929362014/4/25B03863L4T0000929382014/4/26B03864L4T0000929392014/4/27B03866L4T0000929352014/4/28B03867L4T0000929342014/4/29B03868L4T0000929332014/4/30B03865L4T0000929372015/4/30PMS全备份403491L4T0000947662015/4/30PMS全备份B03869L4T0000929322014/5/1B03870L4T0000929312014/5/2B03871L4T0000929302014/5/3B03872L4T0000929292014/5/4B03874L4T0000929262014/5/5B03875L4T0000929252014/5/6B03876L4T0000929242014/5/7B03873L4T0000929282015/5/7PMS全备份403477L4T0000947652015/5/7PMS全备份B03877L4T0000929232014/5/8B03878L4T0000929222014/5/9B03879L4T0000929272014/5/10B03880L4T0000927402014/5/11B03882L4T0000927422014/5/12B03883L4T0000927432014/5/13B03884L4T0000927442014/5/14B03881L4T0000927412015/5/14PMS全备份403453L4T0000947952015/5/14PMS全备份B03885L4T0000927452014/5/15B03886L4T0000927462014/5/16B03887L4T0000927472014/5/17B03888L4T0000927482014/5/18B03890L4T0000927502014/5/19B03891L4T0000927512014/5/20B03892L4T0000927522014/5/21B03889L4T0000927492015/5/21PMS全备份403456L4T0000947712015/5/21PMS全备份B03893L4T0000927532014/5/22B03894L4T0000927542014/5/23B03895L4T0000927552014/5/24B03897L4T0000927572014/5/25B03898L4T0000927582014/5/26B03899L4T