本文为【选择是否恢复整个SQL Server的方法介绍】的汉字拼音对照版显示拼音
这zhe有you一yi个ge具ju体ti例li子zi:如ru果guo你ni有you一yi个ge单dan个ge的de出chu现xian问wen题ti的de文wen件jian。这zhe个ge文wen件jian有you50MB大da小xiao,而er你ni的de整zheng个ge数shu据ju库ku运yun行xing着zhe大da约yue有you几ji十shi亿yi的de字zi节jie,这zhe样yang的de话hua如ru果guo能neng恢hui复fu单dan个ge失shi败bai文wen件jian的de话hua就jiu显xian的de非fei常chang有you意yi义yi。这zhe样yang的de事shi情qing发fa生sheng的de一yi个ge情qing景jing是shi当dang文wen件jian或huo者zhe文wen件jian组zu在zai单dan独du的de驱qu动dong器qi上shang,而er驱qu动dong器qi出chu现xian了le问wen题ti。通tong常chang,仅jin仅jin恢hui复fu单dan个ge文wen件jian或huo者zhe文wen件jian组zu会hui使shi总zong的de停ting止zhi时shi间jian缩suo短duan,因yin为wei它ta明ming显xian减jian少shao了le需xu要yao恢hui复fu的de总zong的de数shu据ju量liang。为wei什shen么me你ni不bu选xuan择ze这zhe么me做zuo呢ne?这zhe有you一yi些xie原yuan因yin:
你ni需xu要yao有you事shi务wu日ri志zhi备bei份fen。如ru果guo你ni想xiang从cong备bei份fen中zhong恢hui复fu一yi个ge文wen件jian或huo者zhe文wen件jian组zu,你ni同tong时shi也ye需xu要yao恢hui复fu与yu它ta们men一yi起qi创chuang建jian的de事shi务wu记ji录lu备bei份fen,从cong而er使shi整zheng个ge数shu据ju库ku能neng够gou处chu于yu一yi个ge一yi致zhi的de状zhuang态tai。在zaiSQL Server 2000 和he 2005中zhong,你ni需xu要yao使shi用yongFull Recovery或huo者zheBulk-Logged Recovery模mo式shi(也ye就jiu是shi说shuo不bu是shiSimple Recovery)来lai使shi它ta成cheng为wei可ke能neng。我wo应ying该gai指zhi出chuSQL Server的de实shi现xian者zhe们men并bing没mei有you尽jin他ta们men的de努nu力li来lai完wan成cheng判pan断duan从cong上shang一yi次ci备bei份fen一yi个ge文wen件jian或huo者zhe文wen件jian组zu是shi否fou已yi经jing被bei修xiu改gai了le的de功gong能neng。如ru果guo没mei有you被bei改gai变bian,那na么me事shi务wu记ji录lu是shi没mei有you什shen么me必bi要yao的de。但dan是shi,总zong的de来lai说shuo,还huan是shi需xu要yao事shi务wu记ji录lu备bei份fen的de,如ru果guo你ni现xian在zai还huan没mei有you一yi个ge备bei份fen事shi务wu记ji录lu的de恢hui复fu或huo者zhe备bei份fen计ji划hua,那na么me现xian在zai就jiu创chuang建jian一yi个ge吧ba。
在zai要yao恢hui复fu的de文wen件jian或huo者zhe文wen件jian组zu中zhong的de表biao格ge与yu数shu据ju库ku中zhong其qi他ta的de表biao格ge之zhi间jian的de数shu据ju不bu一yi致zhi性xing成cheng为wei需xu要yao考kao虑lv的de一yi个ge问wen题ti。如ru果guo你ni有you相xiang互hu之zhi间jian依yi赖lai的de表biao格ge,并bing且qie这zhe些xie表biao格ge没mei有you被bei存cun储chu在zai相xiang同tong的de物wu理li文wen件jian或huo者zhe文wen件jian组zu中zhong(这zhe有you时shi是shi不bu可ke避bi免mian的de),仅jin仅jin恢hui复fu一yi个ge文wen件jian或huo者zhe文wen件jian组zu可ke能neng会hui导dao致zhi它ta与yu数shu据ju库ku其qi他ta部bu分fen不bu同tong步bu。例li如ru,你ni有you一yi个ge表biao格ge被bei另ling一yi个ge表biao格ge用yongJOIN关guan联lian,并bing且qie这zhe个geJOIN使shi用yong了le一yi个ge视shi图tu和he存cun储chu过guo程cheng,这zhe时shi仅jin仅jin恢hui复fu一yi个ge而er不bu恢hui复fu另ling一yi个ge可ke能neng会hui有you问wen题ti。
当dang你ni在zai数shu据ju库ku中zhong只zhi有you一yi个ge文wen件jian组zu。如ru果guo你ni的de所suo有you的de数shu据ju仅jin仅jin存cun储chu在zai一yi个ge文wen件jian或huo者zhe文wen件jian组zu中zhong,并bing且qie它ta又you不bu是shi一yi个ge特te别bie大da的de数shu据ju库ku时shi,会hui发fa生sheng什shen么me事shi情qing呢ne?那na时shi恢hui复fu一yi个ge文wen件jian或huo者zhe文wen件jian组zu的de努nu力li就jiu变bian的de没mei有you什shen么me意yi义yi了le。
选xuan择ze性xing的de恢hui复fu文wen件jian或huo者zhe文wen件jian组zu的de主zhu要yao原yuan因yin是shi当dang恢hui复fu数shu据ju库ku很hen大da,以yi至zhi于yu恢hui复fu整zheng个ge数shu据ju库ku的de代dai价jia很hen大da的de时shi候hou,使shi得de对dui数shu据ju库ku的de局ju部bu损sun坏huai的de恢hui复fu成cheng为wei可ke能neng。在zai一yi个ge非fei常chang小xiao的de轻qing量liang级ji的de数shu据ju库ku里li,和henonproduction系xi统tong中zhong,或huo者zhe数shu据ju库ku中zhong只zhi有you一yi个ge文wen件jian组zu的de时shi候hou,实shi现xian选xuan择ze性xing的de恢hui复fu功gong能neng就jiu显xian的de没mei有you太tai大da的de意yi义yi,因yin为wei这zhe时shi恢hui复fu整zheng个ge数shu据ju库ku和he恢hui复fu单dan个ge的de文wen件jian或huo者zhe文wen件jian组zu没mei有you什shen么me太tai大da的de区qu别bie。
我wo发fa现xian大da多duo数shu时shi候hou当dang人ren们men想xiang使shi用yong文wen件jian或huo者zhe文wen件jian组zu恢hui复fu时shi,他ta们men实shi际ji上shang是shi想xiang把ba一yi个ge特te定ding的de表biao格ge恢hui复fu到dao先xian前qian的de一yi个ge点dian的de时shi刻ke的de状zhuang态tai。这zhe在zaiSQL Server中zhong不bu是shi一yi个ge显xian式shi支zhi特te的de特te性xing,但dan是shi存cun在zai这zhe么me做zuo的de方fang法fa,倘tang若ruo你ni不bu介jie意yi由you于yu采cai用yong这zhe种zhong方fang法fa而er需xu要yao手shou工gong的de来lai管guan理li可ke能neng产chan生sheng的de不bu一yi致zhi(就jiu想xiang上shang面mian#2所suo说shuo的de)。如ru果guo你ni手shou边bian就jiu有you一yi个ge数shu据ju库ku备bei份fen的de话hua,你ni可ke以yi简jian单dan的de恢hui复fu那na个ge备bei份fen,仅jin仅jin把ba它ta看kan作zuo是shi相xiang同tong数shu据ju库ku的de不bu同tong名ming字zi的de实shi例li。接jie着zhe,通tong过guo事shi务wu记ji录lu把ba数shu据ju库ku向xiang前qian滚gun动dong到dao指zhi定ding的de点dian(如ru果guo需xu要yao这zhe样yang做zuo的de话hua),然ran后hou手shou工gong的de把ba当dang前qian的de数shu据ju库ku拷kao贝bei到dao目mu标biao数shu据ju库ku中zhong。
我wo自zi己ji已yi经jing实shi验yan过guo这zhe种zhong方fang法fa几ji次ci,但dan是shi仅jin仅jin只zhi有you一yi个ge表biao格ge没mei有you与yu相xiang同tong数shu据ju库ku中zhong的de其qi他ta的de表biao格ge有you很hen大da的de关guan联lian。我wo的de例li子zi涉she及ji了le一yi个ge包bao含han了le留liu言yan版ban系xi统tong的de聊liao天tian网wang站zhan。我wo不bu得de不bu经jing常chang恢hui复fu一yi些xie在zai留liu言yan版ban上shang被bei意yi外wai删shan除chu的de消xiao息xi,这zhe些xie是shi自zi包bao含han的de:从cong留liu言yan版ban表biao格ge的de数shu据ju产chan生sheng的de唯wei一yi的deJOINs是shi外wai部bu的de而er不bu是shi内nei部bu的de。因yin此ci,我wo可ke以yi随sui意yi的de更geng新xin表biao格ge因yin为wei我wo知zhi道dao我wo不bu会hui让rang那na个ge表biao格ge与yu其qi他ta表biao格ge不bu同tong步bu的de。
在zaiSQL Server 2000和he它ta更geng高gao的de版ban本ben中zhong,当dang你ni做zuo一yi个geRESTORE操cao作zuo的de时shi候hou你ni可ke以yi使shi用yongPARTIAL子zi句ju,从cong而er使shi仅jin仅jin需xu要yao的de文wen件jian组zu数shu据ju被bei恢hui复fu。这zhe作zuo为wei一yi个ge时shi间jian和he空kong间jian上shang的de节jie约yue开kai销xiao的de措cuo施shi是shi非fei常chang有you用yong的de:你ni不bu需xu要yao进jin行xing繁fan重chong的de恢hui复fu所suo有you数shu据ju的de工gong作zuo,而er仅jin仅jin只zhi需xu要yao对dui一yi个ge表biao格ge进jin行xing操cao作zuo。而er且qie很hen可ke能neng也ye没mei有you足zu够gou的de空kong间jian来lai进jin行xing完wan全quan的de恢hui复fu操cao作zuo。【原文】