갑자기 정전작업 후 서버 킨후에
데이터베이스가 느려ㅤㅈㅔㅆ네요...
pda에서 위치정보를 누르고 엔터치면 20~30후 수량 입력하는 칸으로 넘어갑니다..
근데 위치정보를 잘못입력하면 보통 5초정도 후에 잘못되었다고 나오고요..
전에는 위치정보 입력하고 2-3후에 다음라인으로 넘어갔는데...
db가 꼬인건지 어떻게 해야 할까요...

재부팅할때마다 똑같은 log 가 쌓이는 어떻게 해결해야 할지 모르겠습니다... 확인좀 부탁드릅니다....
이것때문에 죽겠네요... 도와주세요.ㅠㅠ

원격이나 전화통화도 가능합니다... 정말 죽겠습니다...

도와주실분 메일 주세요...
hazia@naver.com


2011-12-26 14:29:53 - ? [393] Waiting for SQL Server to recover databases...
2011-12-26 14:29:58 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 3084
2011-12-26 14:29:58 - ? [101] SQL Server JAHNAP01 version 8.00.194 (0 connection limit)
2011-12-26 14:29:58 - ? [102] SQL Server ODBC driver version 3.86.3959
2011-12-26 14:29:58 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local)
2011-12-26 14:29:58 - ? [310] 4 processor(s) and 2048 MB RAM detected
2011-12-26 14:29:58 - ? [339] Local computer is JAHNAP01 running Windows NT 5.2 (3790) Service Pack 2
2011-12-26 14:29:58 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2011-12-26 14:29:58 - + [260] Unable to start mail session (reason: No mail profile defined)
2011-12-26 14:29:58 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2011-12-28 10:25:43 - ? [130] SQLSERVERAGENT stopping because of Windows shutdown...
2011-12-28 10:25:44 - ! [298] SQLServer Error: 1115, Cannot generate SSPI context [SQLSTATE HY000]
2011-12-28 10:25:44 - ! [382] Logon to server '(local)' failed (SaveAllSchedules)
2011-12-28 10:25:46 - ? [098] SQLServerAgent terminated (normally)


2011-12-28 10:27:38 - ? [393] Waiting for SQL Server to recover databases...
2011-12-28 10:27:44 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 3396
2011-12-28 10:27:44 - ? [101] SQL Server JAHNAP01 version 8.00.194 (0 connection limit)
2011-12-28 10:27:44 - ? [102] SQL Server ODBC driver version 3.86.3959
2011-12-28 10:27:44 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local)
2011-12-28 10:27:44 - ? [310] 4 processor(s) and 2048 MB RAM detected
2011-12-28 10:27:44 - ? [339] Local computer is JAHNAP01 running Windows NT 5.2 (3790) Service Pack 2
2011-12-28 10:27:44 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2011-12-28 10:27:44 - + [260] Unable to start mail session (reason: No mail profile defined)
2011-12-28 10:27:44 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect


2011-12-28 10:27:34.45 server    Microsoft SQL Server  2000 - 8.00.194 (Intel X86)
    Aug  6 2000 00:57:48
    Copyright (c) 1988-2000 Microsoft Corporation
    Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2011-12-28 10:27:34.45 server    Copyright (C) 1988-2000 Microsoft Corporation.
2011-12-28 10:27:34.45 server    All rights reserved.
2011-12-28 10:27:34.45 server    Server Process ID is 1984.
2011-12-28 10:27:34.45 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2011-12-28 10:27:34.46 server    SQL Server is starting at priority class 'normal'(4 CPUs detected).
2011-12-28 10:27:34.65 server    SQL Server configured for thread mode processing.
2011-12-28 10:27:34.65 server    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2011-12-28 10:27:34.73 server    Attempting to initialize Distributed Transaction Coordinator.
2011-12-28 10:27:35.98 spid4     Starting up database 'master'.
2011-12-28 10:27:36.79 spid4     Server name is 'JAHNAP01'.
2011-12-28 10:27:36.79 spid5     Starting up database 'msdb'.
2011-12-28 10:27:36.81 spid6     Starting up database 'pubs'.
2011-12-28 10:27:36.81 spid7     Starting up database 'Northwind'.
2011-12-28 10:27:36.84 spid8     Starting up database 'labelprintdb'.
2011-12-28 10:27:36.84 server    Using 'SSNETLIB.DLL' version '8.0.311'.
2011-12-28 10:27:36.84 spid9     Starting up database 'model'.
2011-12-28 10:27:36.84 spid10    Starting up database 'AT_SAP'.
2011-12-28 10:27:36.90 server    SQL server listening on 10.162.227.214: 1433.
2011-12-28 10:27:36.90 server    SQL server listening on 127.0.0.1: 1433.
2011-12-28 10:27:37.03 server    SQL server listening on TCP, Shared Memory, Named Pipes.
2011-12-28 10:27:37.11 spid9     Clearing tempdb database.
2011-12-28 10:27:38.32 server    SQL Server is ready for client connections
2011-12-28 10:27:39.67 spid9     Starting up database 'tempdb'.
2011-12-28 10:27:43.64 spid10    Analysis of database 'AT_SAP' (8) is 100% complete (approximately 0 more seconds)
2011-12-28 10:27:43.74 spid4     Recovery complete.
2011-12-28 10:27:44.57 spid51    Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
2011-12-28 10:27:44.70 spid52    Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'xp_sqlagent_monitor'.

2011-12-26 14:29:48.25 server    Microsoft SQL Server  2000 - 8.00.194 (Intel X86)
    Aug  6 2000 00:57:48
    Copyright (c) 1988-2000 Microsoft Corporation
    Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2011-12-26 14:29:48.25 server    Copyright (C) 1988-2000 Microsoft Corporation.
2011-12-26 14:29:48.25 server    All rights reserved.
2011-12-26 14:29:48.25 server    Server Process ID is 1960.
2011-12-26 14:29:48.25 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2011-12-26 14:29:48.29 server    SQL Server is starting at priority class 'normal'(4 CPUs detected).
2011-12-26 14:29:48.48 server    SQL Server configured for thread mode processing.
2011-12-26 14:29:48.48 server    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2011-12-26 14:29:48.54 server    Attempting to initialize Distributed Transaction Coordinator.
2011-12-26 14:29:49.73 spid4     Starting up database 'master'.
2011-12-26 14:29:50.23 spid5     Starting up database 'model'.
2011-12-26 14:29:50.23 server    Using 'SSNETLIB.DLL' version '8.0.311'.
2011-12-26 14:29:50.23 spid4     Server name is 'JAHNAP01'.
2011-12-26 14:29:50.23 spid8     Starting up database 'msdb'.
2011-12-26 14:29:50.23 spid9     Starting up database 'pubs'.
2011-12-26 14:29:50.24 spid11    Starting up database 'labelprintdb'.
2011-12-26 14:29:50.24 spid10    Starting up database 'Northwind'.
2011-12-26 14:29:50.24 spid12    Starting up database 'AT_SAP'.
2011-12-26 14:29:50.24 server    SQL server listening on 10.162.227.214: 1433.
2011-12-26 14:29:50.24 server    SQL server listening on 127.0.0.1: 1433.
2011-12-26 14:29:50.31 server    SQL server listening on TCP, Shared Memory, Named Pipes.
2011-12-26 14:29:50.46 spid5     Clearing tempdb database.
2011-12-26 14:29:51.70 server    SQL Server is ready for client connections
2011-12-26 14:29:52.49 spid5     Starting up database 'tempdb'.
2011-12-26 14:29:57.67 spid12    Analysis of database 'AT_SAP' (8) is 100% complete (approximately 0 more seconds)
2011-12-26 14:29:57.85 spid4     Recovery complete.
2011-12-26 14:29:58.49 spid51    Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
2011-12-26 14:29:58.84 spid51    Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'xp_sqlagent_monitor'.
2011-12-27 16:15:16.35 spid54    Error: 15457, Severity: 0, State: 1
2011-12-27 16:15:16.35 spid54    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2011-12-27 16:15:16.44 spid54    Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.
2011-12-28 10:25:43.05 server    SQL Server terminating because of system shutdown.
2011-12-28 10:25:43.05 server    LogEvent: Failed to report the current event. Operating system error = 31(error not found).
2011-12-28 10:25:49.28 spid4     SQL Server is terminating due to 'stop' request from Service Control Manager.