首页 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 收藏0 阅读量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页

职业精品

分销渠道选择.ppt

辞职申请书(优质范文).doc

公司年检申请书doc.doc

厂家和经销商代理合同.doc

用户评论

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

精彩专题

相关资料换一换

资料评价:

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

意见
反馈

返回
顶部