2007~2011/SQL Server2008. 12. 9. 23:23
SQL Server 2000 설치에 이어 Service Pack 와 Cumulative hotfix 설치를 진행합니다.


[설치버전]
1. SQL Server 2000 Enterprise Edition (x86) 
2. SP4 for SQL Server 2000
3. Cumulative hotfix build 2187



[설치과정]
Service Pack 4 for SQL Server 2000 설치
















Service Pack 설치가 완료되면 reboot 하는 센스가 필요합니다.

다음은 누적 hotfix 2187 을 설치합니다.













버전 확인을 할 차례입니다.
쿼리 분석기를 통해 SELECT @@VERSION 쿼리를 사용할 수 있지만 이번엔 조금 색다르게(?)
ERRORLOG 한 번 올려봅니다.

2008-12-08 23:28:39.20 server    Microsoft SQL Server  2000 - 8.00.2187 (Intel X86)

             Copyright (c) 1988-2003 Microsoft Corporation

             Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

 

2008-12-08 23:28:39.20 server    Copyright (C) 1988-2002 Microsoft Corporation.

2008-12-08 23:28:39.20 server    All rights reserved.

2008-12-08 23:28:39.20 server    Server Process ID is 2884.

2008-12-08 23:28:39.20 server    Logging SQL Server messages in file 'd:\Data\MSSQL\log\ERRORLOG'.

2008-12-08 23:28:39.22 server    SQL Server is starting at priority class 'normal'(1 CPU detected).

2008-12-08 23:28:39.26 server    SQL Server configured for thread mode processing.

2008-12-08 23:28:39.26 server    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

2008-12-08 23:28:39.28 server    Attempting to initialize Distributed Transaction Coordinator.

2008-12-08 23:28:41.33 spid3     Starting up database 'master'.

2008-12-08 23:28:41.48 spid3     Server name is 'VSERVER'.

2008-12-08 23:28:41.48 server    Using 'SSNETLIB.DLL' version '8.0.2039'.

2008-12-08 23:28:41.49 server    SQL server listening on 192.168.0.110: 1433.

2008-12-08 23:28:41.49 server    SQL server listening on 127.0.0.1: 1433.

2008-12-08 23:28:41.49 server    SQL server listening on TCP, Shared Memory, Named Pipes.

2008-12-08 23:28:41.49 server    SQL Server is ready for client connections

2008-12-08 23:28:41.49 spid5     Starting up database 'model'.

2008-12-08 23:28:41.49 spid8     Starting up database 'msdb'.

2008-12-08 23:28:41.50 spid9     Starting up database 'pubs'.

2008-12-08 23:28:41.50 spid10    Starting up database 'Northwind'.

2008-12-08 23:28:41.71 spid5     Clearing tempdb database.

2008-12-08 23:28:41.98 spid5     Starting up database 'tempdb'.

2008-12-08 23:28:42.05 spid3     Recovery complete.

2008-12-08 23:28:42.05 spid3     SQL global counter collection task is created.



작성자 : Lai Go / 작성일자 : 2008.12.09
Posted by Lai Go