关闭

关闭

关闭

封号提示

内容

首页 SQL Server 2008 In-Place Upgrade.doc

SQL Server 2008 In-Place Upgrade.doc

SQL Server 2008 In-Place Upgrad…

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

简介:本文档为《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

职业精品

用户评论

0/200
    暂无评论

精彩专题

上传我的资料

热门资料

资料评价:

/12
0下载券 下载 加入VIP, 送下载券

意见
反馈

返回
顶部