首页 > > > SQL Server 2008 In-Place Upgrade.doc

SQL Server 2008 In-Place Upgrade.doc

SQL Server 2008 In-Place Upgrad…

上传者: 逍遥汉 2011-11-03 评分1 评论0 下载29 收藏10 阅读量629 暂无简介 简介 举报

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

SQLServer2008:UpgradeStrategies(part1)-In-PlaceUpgrade OnceyouhavedeterminedthatyourdatabasesarecompatiblewithSQLServer2008,you arereadytoperformanupgrade.Therearetwowaystoperformanupgrade.Thefirstis knownasanin-placeupgrade,andasthenameimplies,itupgradesanentireinstance"in place"byconvertingthedatafilestothenewformat.Thesecondapproachisknownasa side-by-sideupgrade,whichconsistsofinstallingasecondinstanceofSQLServerand movingthedatafilestothenewversion.Bothmethodshavetheirprosandcons,andthe bestmethodforoneapplicationmaynotbethebestmethodforanother.Anin-place upgradeprovidessimplicitybutlackstheflexibilityofferedbyaside-by-sideupgrade. 1.In-PlaceUpgrade Anin-placeupgradecanbeusedtoupgradeaninstanceofSQLServer2000orSQLServer 2005directlytoSQLServer2008.Searchfor"VersionandEditionUpgrades"onMSDNfor specificsonthesupportedupgradepathsforeachversionandedition. Oneofthebenefitsofperforminganin-placeupgradeisthatyoucanusethesameserver andinstancenames.Thismaysaveyoufromhavingtotrackdownalltheconnectionsto thedatabaseandpointthemtoanewserverorinstancename.Itisafairlysimpleprocess, muchlikeperforminganinstallation.Youdonotneedextradiskspacetomakeacopyof thedatafilesbecausetheywillbeconvertedtothenewformatduringtheupgrade.The downsideisthatthereisapointduringtheupgradeprocesswherethereisnoturning back.TheonlybackoutistoreinstallthepriorversionofSQLServerandrestorethe databasesfromabackupthatwasmadepriortotheupgrade.Youcannotrestoreabackup ofadatabasethathasbeenconvertedtoSQLServer2008onapreviousversion.Ifyou determinethataproblemhasbeencausedaweeklaterbytheupgrade,youwillhaveto restorethedatabasefromabackuppriortotheupgradeandhopeyouhaveawayto recoverthetransactionsthathaveoccurredsincetheupgrade. Itisimportanttohaveatestedbackupinasafelocation,sincethatistheonly waytobackoutofanin-placeupgrade.Youmaywanttotakeanimageofthe serveraswellandstoreitinasafelocationtoreducethebackouttime. Thestepstoperforminganin-placeupgradeincludethefollowing: 1. Makesureyouhavecurrentbackupsinasafelocation. 2. RunSQLServersetup.exe.Installanyprerequisitesandexittheinstall.Ifarebootis requiredduetotheprerequisites,rebootandrunsetup.exeagain. 3. FromtheSQLServerInstallationCenter,selectUpgradefromSQLServer2000or

第1页

该用户的其他资料

  • 名称/格式
  • 评分
  • 下载次数
  • 资料大小
  • 上传时间

用户评论

0/200
    暂无评论
上传我的资料

相关资料

资料评价:

/ 12
所需积分:0 立即下载
返回
顶部
举报
资料
关闭

温馨提示

感谢您对爱问共享资料的支持,精彩活动将尽快为您呈现,敬请期待!