数据库安装与配置-SQL2008 - Install Service Pack 1.doc

ComputerCenterServices

ComputerCenterServices

Title: SQL2005–InstallServicePack3 Date:25.08.2009

Editor: MarkWU

Version: 1.0

MSSQL2008-InstallServicePack1

MSSQL2008-InstallServicePack1

Summary:

TOC\o1-3\h\z\u1.Preparetheinstallation 1

1.1Backup 2

1.2Verifyserviceaccouts 4

1.3StopServicesandApplications 5

2.InstallSQLServer2005SP3 5

DocumentHistory:

Name

Date

Changes/Remarks

MarkWU

25.08.2009

CreationoftheDocument

1.Preparetheinstallation

1.1Backup

BeforeyouinstallSP1,backupthemaster,msdbandmodeldatabases.InstallingSP1modifiesthesedatabases,makingthemincompatiblewithpre-SP1versions.BackupisrequiredifyoudecidetoreinstallSQLServer2008withoutSP1.

CalltheSQLServerManagementStudio.

Right-clicktoDatabases-Management-MaintenancePlans-MaintenancePlanWeekly

?Execute

?Close

CalltheBackup-ArchiveGUI.

?Backup

ChecktheBackupPartition

?Backup

?OK

1.2Verifyserviceaccouts

CalltheServices.

Ifthevalueforstartuptypeis“Disabled”,double-clicktheservicesname,andthenchangeStartupTypeto“Manual”.

1.3StopServicesandApplications

StopallApplicationsandservicesthatmakeconnectionstotheinstancesoftheSQLServerthatisbeingupgraded,includingSQLServerManagementStudio,BusinessIntelligenceDevelopmentStudio,ControlPanelandAddorRemovePrograms,beforeinstallingSP3.

CallSQLServerConfigurationManager.

Right-clicktoallSQLServer2008Services.

?Stop

ClosetheSQLServerConfigurationManager.

2.InstallSQLServer2008SP1

CalltheExplorerandmapthenetworkdrive\\blksfs01\Computer_Center

?Finish

Double-clicktoY:\Software_Packages\MS_SQL_Server\MS_SQL_Server_2008\SQL_Server_2008_SP1\SQLServer2008SP1-KB968369-x86-ENU.exe

?Run

?Next

Check“Iacceptthelicenseterms.”

?Next

?Next

?Next

?Update

?Next

?Close