[설치버전]
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
