关闭

关闭

封号提示

内容

首页 SQL Server 2008 In-Place Upgrade.doc

SQL Server 2008 In-Place Upgrade.doc

SQL Server 2008 In-Place Upgrad…

上传者: 逍遥汉 2011-11-03 评分 5 0 138 19 629 暂无简介 简介 举报

简介:本文档为《SQL Server 2008 In-Place Upgradedoc》,可适用于IT/计算机领域,主题内容包含SQLServer:UpgradeStrategies(part)InPlaceUpgradeSQLServer:UpgradeStrategies符等。

SQLServer:UpgradeStrategies(part)InPlaceUpgradeSQLServer:UpgradeStrategies(part)InPlaceUpgradeOnceyouhavedeterminedthatyourdatabasesarecompatiblewithSQLServer,youarereadytoperformanupgradeTherearetwowaystoperformanupgradeThefirstisknownasaninplaceupgrade,andasthenameimplies,itupgradesanentireinstance"inplace"byconvertingthedatafilestothenewformatThesecondapproachisknownasasidebysideupgrade,whichconsistsofinstallingasecondinstanceofSQLServerandmovingthedatafilestothenewversionBothmethodshavetheirprosandcons,andthebestmethodforoneapplicationmaynotbethebestmethodforanotherAninplaceupgradeprovidessimplicitybutlackstheflexibilityofferedbyasidebysideupgradeInPlaceUpgradeAninplaceupgradecanbeusedtoupgradeaninstanceofSQLServerorSQLServerdirectlytoSQLServerSearchfor"VersionandEditionUpgrades"onMSDNforspecificsonthesupportedupgradepathsforeachversionandeditionOneofthebenefitsofperforminganinplaceupgradeisthatyoucanusethesameserverandinstancenamesThismaysaveyoufromhavingtotrackdownalltheconnectionstothedatabaseandpointthemtoanewserverorinstancenameItisafairlysimpleprocess,muchlikeperforminganinstallationYoudonotneedextradiskspacetomakeacopyofthedatafilesbecausetheywillbeconvertedtothenewformatduringtheupgradeThedownsideisthatthereisapointduringtheupgradeprocesswherethereisnoturningbackTheonlybackoutistoreinstallthepriorversionofSQLServerandrestorethedatabasesfromabackupthatwasmadepriortotheupgradeYoucannotrestoreabackupofadatabasethathasbeenconvertedtoSQLServeronapreviousversionIfyoudeterminethataproblemhasbeencausedaweeklaterbytheupgrade,youwillhavetorestorethedatabasefromabackuppriortotheupgradeandhopeyouhaveawaytorecoverthetransactionsthathaveoccurredsincetheupgradeItisimportanttohaveatestedbackupinasafelocation,sincethatistheonlywaytobackoutofaninplaceupgradeYoumaywanttotakeanimageoftheserveraswellandstoreitinasafelocationtoreducethebackouttimeThestepstoperforminganinplaceupgradeincludethefollowing:​ Makesureyouhavecurrentbackupsinasafelocation​ RunSQLServersetupexeInstallanyprerequisitesandexittheinstallIfarebootisrequiredduetotheprerequisites,rebootandrunsetupexeagain​ FromtheSQLServerInstallationCenter,selectUpgradefromSQLServerorSQLServer,asshowninFigureFigureSQLServerInstallationCenter​ SQLServerwillinstallanyrequiredsupportfiles,andyoumayberequiredtorebootandstartsetupexeagain​ TheSystemConfigurationCheckerwillrunadiscoveryandsetuplogfileswillbecreatedfortheinstallationTheSetupSupportRulesscreen,showninFigure,identifiesanyproblemsthatyoumayencounterwheninstallingthesetupsupportfilesTheseerrorswillneedtoberesolvedinordertocontinueFigureUpgradeSetupSupportRules​ OntheProductKeyscreen(seeFigure),entertheproductkeyorindicatethatyouareupgradingtoafreeversionFigureUpgradetoafreeeditionorenteraproductkey​ Acceptthelicenseagreement,asshowninFigureFigureUpgradelicenseagreement​ SelecttheinstanceofSQLServeryouwillbeupgradingYou'llbepresentedwithalistlikethatshowninFigureFigureUpgradeinstanceselection​ ThefeatureselectionswillbepreselectedandcannotbechangedThechecklistoffeatureswillbegrayedout,asshowninFigureIfyouneedtoaddadditionalfeatures,youwillneedtorerunsetupexeaftertheupgradeFigureUpgradefeaturesselection​ SpecifythenameofthenewinstanceInFigure,wespecifiedSQLEXPRESSasourinstancenameFigureUpgradetheinstanceconfiguration​ Continuethroughtheupgradescreens,validatingthediskspacerequirementsandselectingErrorandUsageReporting​ TheinstallerwilldoafinalchecktomakesuretheupgradeprocesswillnotbeblockedYou'llbepresentedwithupgraderuleslikethoseinFigureYou'llbeabletoseewhichrulesyoupass,andwhichrequiresomeactiononyourpartFigureUpgraderules​ TheReadytoUpgradescreeninFigureallowsyoutoverifyallthefeaturesthatwillbeupgradedpriortoperformingtheupgradeFigureUpgradefeaturesverification​ Next,theUpgradeProgressscreeninFigureallowsyoutoviewthestatusoftheupgradeasitprogressesFigureUpgradeProgressscreen​ ReviewthelogfileaftertheupgradehascompletedTheinstallerwillprovidealinktothelogfileontheCompletescreen,shownattheupperrightofFigureFigureUpgradecompletionOnceyouhavecompletedtheupgrade,itisalwaysagoodideatologintotheapplicationandrunsometeststomakesuretheupgradewastrulyasuccessbeforereleasingthedatabasebackintoproductionItwillhelpifyouhavesomebaselineperformancestatisticspriortotheupgradethatyoucanusetocomparetotheupgradeddatabaseUnfortunately,somepeoplearereluctanttochangeandthinkeverythingusedtoworkbetterontheoldversionInrarecases,somequeriesmayactuallyperformworseaftertheupgradeHavingabaselinewillhelpyoudetermineifthereisactuallyanissue,orifitisjustuserperception

类似资料

该用户的其他资料

中药典故--百合.doc

中药典故--白芨.doc

中药典故--知母.doc

中药典故--白芍.doc

中药典故--紫花地丁.doc

职业精品

精彩专题

上传我的资料

精选资料

热门资料排行换一换

  • 少林拳术秘传 (下册)—德虔 编…

  • 复杂性科学的哲学反思.pdf

  • 花旗帝国.pdf

  • 初三数学圆的复习课件_人教版.p…

  • 古代希腊史.pdf

  • 点校本二十四史_《汉书》. 第0…

  • 机械振动与噪声学.pdf

  • 汉英数学词典.pdf

  • 汉英中国文化词典.pdf

  • 资料评价:

    / 12
    所需积分:0 立即下载

    意见
    反馈

    返回
    顶部