关闭

关闭

封号提示

内容

首页 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页

类似资料

该用户的其他资料

中药典故--罂粟.doc

中药典故--肉桂.doc

中药典故--花蕊石.doc

中药典故--腊梅.doc

中药典故--艾叶.doc

职业精品

精彩专题

墨西哥——让人低估的旅游城市

墨西哥是美洲大陆上的文明古国,以阳光与热情著称,墨西哥气候宜人,风光秀丽,尤其是名胜古迹非常多。所以当您选择去墨西哥旅游时,首先要去的就是举世闻名的旅游圣地——墨西哥城。

用户评论

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

精选资料

热门资料排行换一换

  • 家具制造业管理操作实务大全.pdf

  • 江恩理论.pdf

  • 连淑能_1993-英汉对比研究.…

  • 渊海子平.pdf

  • 《海狼行动 — 第二次世界大战潜…

  • 金鱼画法.pdf

  • 白蛇传(孟庆江).pdf

  • 白蛇传(陈缘督).pdf

  • 有限单元法在传热学中的应用(第三…

  • 资料评价:

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

    意见
    反馈

    返回
    顶部