備份系統(tǒng)當(dāng)前的概況

備份系統(tǒng)當(dāng)前的概況目前可支持策略全備份差異備份日志備份最小頻率每天每天每小時(shí)最大頻率每周//數(shù)據(jù)保留周期8周B．覆蓋的業(yè)務(wù)系統(tǒng)，數(shù)據(jù)庫(kù)備份策略說(shuō)明所屬系統(tǒng)hostnameSQLIPDatabase_Name全備差異日志PMS主庫(kù)HQ-C0SQL-01HTPMS√√√HTPMSBase√√√ReportServer√√√PMS分庫(kù)SQLSEV-02HTPMS√×√HTPMSBase√×√ReportServer√×√PMS分庫(kù)SQLSEV-03HTPMS√×√HTPMSBase√×√ReportServer√×√PMS分庫(kù)SQLSEV-04HTPMS√×√HTPMSBase√×√ReportServer√×√ECRMHQ-S0SQL-03HanTing_Audit√×√HTCRM√××HTCRM_CalResult√××PCRMHQ-C0SQL-02HtinnsCRM√×√RCITDB√××AutoPos√×√HTcallCenter√×√免房券HZVM0049HtECoupons√×√HtScratchCard√×√HtECouponsHelper√×√官網(wǎng)INTERWEBAPP_PUSH√√×AutoCheckIn√√×CentralGateway√√×HomeInnsWarning√√×HTCampus√√×HTWiki√√×NewSMS√√×ThankfulEmail√√√WebADTraceDB√√√WebSiteDBTest√××HTPayCenter√××中介直連HQ-S0SQL-10ACCM_DB√√×ReportServer√××大活動(dòng)Vact-sql-01Activity√×√銀聯(lián)支付Vpay-sql-01UnionPayDB√×√采購(gòu)報(bào)銷vrds-work-01HT_eAccounting√√×HT_eAccounting_Attachment√√×HT_eAccounting_Log√√×NCOraclHQ-S1NCS-05htjd√×√IPL人事系統(tǒng)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監(jiān)控系統(tǒng)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．磁帶備份周期及周轉(zhuǎn)情況說(shuō)明常規(guī)備份（每日1盤），只寫入除PMS主庫(kù)全備份以外所有的備份數(shù)據(jù)。全備份（每周2盤）：只寫入PMS主庫(kù)全備份數(shù)據(jù)。磁帶周轉(zhuǎn)明細(xì)如下（4/1-5/31）：磁帶編號(hào)對(duì)方公司磁帶編碼備份日期備注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