systemdatabase备份及恢复策略.docx

System Database n eed to backup: master:记录所有系统级信息的数据库 Simple model:所有数据库创建的模板 full msdb : SQL Server代理用来安排警报和作业及记录操作员信息的数据库。还有备份和还 原记录等历史记录 simple Restore Master Database 必须将实例数据库服务切换成： 单用户启动实例 单用户启动数据库实例服务及还原 master数据库: Shutdow n all SQL Server relava nt services: Mamg Slatm? SQL Scrw [ntcq s Step ped ^SQL FuhtectFIte.-. Stopped ^SQ L Sciver (MSS.k Ste p ped Mamg Slatm ? SQL Scrw [ntcq s Step ped ^SQL FuhtectFIte.-. Stopped ^SQ L Sciver (MSS.k Ste p ped ? 5QI Serve* An ? 井 Stop p ed 迪 ￡Q L Server Rep%? Step ped ￡QL Server Rrovmii Stepped SQL Server Agent?, Stepped Stsrt Mode Autoniatic Me n us I Autonintic Adtonuntic AjtDfDEltic Other (Boot Systc?. AutDfYiatic Log On As Process [D Lfcs?S)rtcnn 0 NTAUTHORITYaO- 0 Lci：0i9Sy3tem fl Lc cm Sy stem 0 Lo cd Wystan 0 MTAUTHOMTYaO.- 0 Lot a System 0 SQL Scr^xr Anclysis Jrcivcr Reoori Server SQL Agent Open cmd, and run net start mssqlserver /m (use single user to launch MSSQLSERVE service) C： MJsers：\(]i^uD(fuan n^t start The SQL Seruer CM￡SQLSERUER fThe SQL Seruep CnSSQLSERUEHms：sqlsei?ve]? Zn seill ice is stcurtrin^ C： MJsers：\(]i^uD(fuan n^t start The SQL Seruer CM￡SQLSERUER fThe SQL Seruep CnSSQLSERUEH ms：sqlsei?ve]? Zn seill ice is stcurtrin^ --- service uas started successfully After step 2, run sqlcmd , the n in put “ use master ” and “ go” . As below scree nshot: C = Misers \qzLguoquan sqlcmd 1 use n^stei1 2 go 目將数据库上下文更改为宀 In put “ Restore database master from disk y T*ftstove datraiha^e128080 9673054.bafcf y T*ftstove datraiha^e 128080 9673054.bafcf Fm-as tRp 1 f ron diffiUc = , D : \lMKSGI-_RftCKIIP^jnasteFi_l?ackiip_201 witli replace er KM8PU 鼻为誓L _?匕匕已SQ master1 ,文件‘财球? C位于交件 masteF* ,区件 （位-1-文 |牛 ST master数招电正柱关闭SQL Sb 正在终0遥程。 Restore master task is done. The n start all SQL Server related services. C:: XiJsers \qiflruQquan net start nis：s：(f lserver ths SQL Servep (t1SS4LS￡RVER sepvice is st^rtinsr... The SQL Ser-ver- CN￡SQLSERUER seimicc 甘辭 started successfully 常用查询语句： select* from sys.dm_exec_requests SEL