求助，数据库宕机（已解决）

小无赖

01:00000:00001:2006/04/26 09:02:45.18 kernel  Reenlistment of DTC Transactions Complete
01:00000:00001:2006/04/26 09:02:45.18 server  SQL Server's default unicode sort order is 'binary'.
01:00000:00001:2006/04/26 09:02:45.18 server  SQL Server's default sort order is:
01:00000:00001:2006/04/26 09:02:45.18 server          'bin_iso_1' (ID = 50)
01:00000:00001:2006/04/26 09:02:45.18 server  on top of default character set:
01:00000:00001:2006/04/26 09:02:45.18 server          'iso_1' (ID = 1).
01:00000:00001:2006/04/26 09:02:45.18 server  Master device size: 60 megabytes, or 30720 virtual pages. (A virtual page is 2048 bytes.)
01:00000:00065:2006/04/26 10:00:55.62 kernel  Cannot send, host process disconnected: DF8029FC9290421 996 spid: 65
01:00000:00009:2006/04/26 10:04:04.70 server  Exceeded license usage limit. Contact Sybase Sales for additional licenses.
00:00000:00004:2006/04/26 10:15:20.45 kernel  shutdownproc: shutting down SQL Server!
00:00000:00004:2006/04/26 10:15:20.73 kernel  XP Server is not running.
00:00000:00004:2006/04/26 10:15:21.07 server  SQL Server shutdown by request.
00:00000:00004:2006/04/26 10:15:21.07 kernel  ueshutdown: exiting

数据库宕机时新的连接进不去，但已连接的程序还可以继续使用。用sybase也ping不通服务器。

sybase12.5.4 11665 for windows2000 adv server

[ 本帖最后由 小无赖 于 2006-5-29 09:04 编辑 ]

echoaix

从log看这应该是人为的shutdown啊

pandu

再多点日志

小无赖

发现宕机后我才重启服务的。

00:00000:00004:2006/04/26 10:15:21.07 server  SQL Server shutdown by request.
00:00000:00004:2006/04/26 10:15:21.07 kernel  ueshutdown: exiting
00:00000:00004:2006/04/26 10:15:21.07 kernel  shutdown waiting for engine pid 808 to exit...
00:00000:00004:2006/04/26 10:15:21.18 kernel  engine pid 808 exit completed
00:00000:00000:2006/04/26 10:15:21.79 kernel  Use license file C:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/04/26 10:15:21.79 kernel  Checked out license ASE_SERVER
00:00000:00000:2006/04/26 10:15:21.79 kernel  Adaptive Server Enterprise Edition
00:00000:00000:2006/04/26 10:15:21.81 kernel  Using config area from primary master device.
00:00000:00000:2006/04/26 10:15:21.81 kernel  Warning: Using default file 'C:\sybase\BSCSZDSVR.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/04/26 10:15:23.98 kernel  Using 100000 file descriptors.
00:00000:00000:2006/04/26 10:15:23.98 kernel  Adaptive Server Enterprise/12.5.1/EBF 11665 ESD#2/P/NT (IX86)/OS 4.0/ase1251/1838/32-bit/OPT/Fri Feb 20 04:11:31 2004
00:00000:00000:2006/04/26 10:15:23.98 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/04/26 10:15:23.98 kernel  Copyright 1987, 2004
00:00000:00000:2006/04/26 10:15:23.98 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/04/26 10:15:23.98 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/04/26 10:15:23.98 kernel  
00:00000:00000:2006/04/26 10:15:23.98 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/04/26 10:15:23.98 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/04/26 10:15:23.98 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/04/26 10:15:23.98 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/04/26 10:15:23.98 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/04/26 10:15:23.98 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/04/26 10:15:23.98 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2006/04/26 10:15:23.98 kernel  ASE booted on Windows 2000 build 2195 Service Pack 4.
00:00000:00000:2006/04/26 10:15:23.98 kernel  Using 'C:\sybase\BSCSZDSVR.cfg' for configuration information.
00:00000:00000:2006/04/26 10:15:23.98 kernel  Logging ASE messages in file 'C:\sybase\ASE-12_5\install\BSCSZDSVR.txt'.
00:00000:00000:2006/04/26 10:15:24.00 kernel  Initializing MSDTC Connection
00:00000:00000:2006/04/26 10:15:25.62 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/04/26 10:15:25.62 kernel  SQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2006/04/26 10:15:25.62 kernel  SQL Server NT process id is 0x34c.
00:00000:00000:2006/04/26 10:15:25.62 kernel  SQL Server was started as a Service.
00:00000:00000:2006/04/26 10:15:25.62 kernel  SSL Plus v3.1.5 security modules loaded successfully.
00:00000:00000:2006/04/26 10:15:25.62 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/04/26 10:15:26.03 server  Number of blocks left for proc headers: 102352.
00:00000:00000:2006/04/26 10:15:26.06 server  Proc header memory allocated 25588 pages for each per engine cache
00:00000:00000:2006/04/26 10:15:27.10 server  Size of the 4K memory pool: 8 Kb
00:00000:00000:2006/04/26 10:15:27.10 server  Memory allocated for the default data cache cachelet 1: 1048568 Kb
00:00000:00000:2006/04/26 10:15:27.10 kernel  Initializing virtual device 0, 'C:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2006/04/26 10:15:27.10 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/04/26 10:15:27.10 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2006/04/26 10:15:27.12 kernel  engine 0, os pid 256  online
00:00000:00000:2006/04/26 10:15:27.12 server  No active traceflags
00:00000:00001:2006/04/26 10:15:27.12 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.1/EBF 11665 ESD#2/P/NT (IX86)/OS 4.0/ase1251/1838/32-bit/OPT/Fri Feb 20 04:11:31 2004'.
00:00000:00001:2006/04/26 10:15:27.12 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1 ASE Edition/P-EBF11378/PC Intel/BUILD1251-004/OPT/Thu Aug 14 11:57:18 2003'
00:00000:00001:2006/04/26 10:15:27.12 server  Opening Master Database ...
00:00000:00001:2006/04/26 10:15:27.25 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/04/26 10:15:27.28 server  Loaded default Unilib conversion handle.
00:00000:00001:2006/04/26 10:15:27.29 server  Recovering database 'master'.
00:00000:00001:2006/04/26 10:15:27.31 server  Started estimating recovery log boundaries for database 'master'.
00:00000:00001:2006/04/26 10:15:27.31 server  Completed estimating recovery log boundaries for database 'master'.
00:00000:00001:2006/04/26 10:15:27.31 server  Started ANALYSIS pass for database 'master'.
00:00000:00001:2006/04/26 10:15:27.31 server  Completed ANALYSIS pass for database 'master'.
00:00000:00001:2006/04/26 10:15:27.31 server  Started REDO pass for database 'master'. The total number of log records to process is 1.
00:00000:00001:2006/04/26 10:15:27.31 server  Completed REDO pass for database 'master'.
00:00000:00001:2006/04/26 10:15:27.31 server  Recovery of database 'master' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:15:27.31 server  Started recovery checkpoint for database 'master'.
00:00000:00001:2006/04/26 10:15:27.32 server  Completed recovery checkpoint for database 'master'.
00:00000:00001:2006/04/26 10:15:27.34 server  Started filling free space info for database 'master'.
00:00000:00001:2006/04/26 10:15:27.35 server  Completed filling free space info for database 'master'.
00:00000:00001:2006/04/26 10:15:27.37 server  Started cleaning up the default data cache for database 'master'.
00:00000:00001:2006/04/26 10:15:27.37 server  Completed cleaning up the default data cache for database 'master'.
00:00000:00001:2006/04/26 10:15:27.40 server  Checking external objects.
00:00000:00001:2006/04/26 10:15:27.43 server  Database 'master' is now online.
00:00000:00001:2006/04/26 10:15:27.45 server  The transaction log in the database 'master' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:15:27.45 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2006/04/26 10:15:27.46 server  server is unnamed
00:00000:00001:2006/04/26 10:15:27.48 server  Activating disk 'BSHQS_datadev01' of size 2048000 KB.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Initializing virtual device 4, 'd:\database\BSHQS_datadev01.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:27.48 server  Activating disk 'BSHQS_datadev02' of size 2048000 KB.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Initializing virtual device 8, 'D:\Database\BSHQS_datadev02.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Virtual device 8 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:27.48 server  Activating disk 'BSHQS_logdev' of size 1024000 KB.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Initializing virtual device 5, 'd:\database\BSHQS_logdev.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:27.48 server  Activating disk 'BSSCS_datadev01' of size 2048000 KB.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Initializing virtual device 6, 'd:\database\BSSCS_datadev01.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Virtual device 6 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:27.48 server  Activating disk 'BSSCS_logdev' of size 1024000 KB.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Initializing virtual device 7, 'd:\database\BSSCS_logdev.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Virtual device 7 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:27.48 server  Activating disk 'sysprocsdev' of size 122880 KB.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Initializing virtual device 1, 'C:\sybase\data\sysprocs.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:27.48 server  Activating disk 'tempdb_datadev' of size 1024000 KB.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Initializing virtual device 2, 'D:\database\tempdb_datadev.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:27.48 server  Activating disk 'tempdb_logdev' of size 512000 KB.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Initializing virtual device 3, 'd:\database\tempdb_logdev.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:27.48 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:27.62 server  Recovering database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.62 server  Started estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.62 server  Completed estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.62 server  Started ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.62 server  Completed ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.62 server  Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1.
00:00000:00001:2006/04/26 10:15:27.64 server  Completed REDO pass for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.64 server  Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:15:27.64 server  Started recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.65 server  Completed recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.67 server  Started filling free space info for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.68 server  Completed filling free space info for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.68 server  Started cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.70 server  Completed cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:27.70 server  Boot Count: 104
00:00000:00001:2006/04/26 10:15:27.73 server  Checking external objects.
00:00000:00001:2006/04/26 10:15:27.75 server  The transaction log in the database 'sybsystemdb' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:15:27.79 server  Database 'sybsystemdb' is now online.
00:00000:00001:2006/04/26 10:15:27.85 server  Recovering database 'model'.
00:00000:00001:2006/04/26 10:15:27.85 server  Started estimating recovery log boundaries for database 'model'.
00:00000:00001:2006/04/26 10:15:27.87 server  Completed estimating recovery log boundaries for database 'model'.
00:00000:00001:2006/04/26 10:15:27.87 server  Started ANALYSIS pass for database 'model'.
00:00000:00001:2006/04/26 10:15:27.87 server  Completed ANALYSIS pass for database 'model'.
00:00000:00001:2006/04/26 10:15:27.87 server  Started REDO pass for database 'model'. The total number of log records to process is 1.
00:00000:00001:2006/04/26 10:15:27.87 server  Completed REDO pass for database 'model'.
00:00000:00001:2006/04/26 10:15:27.87 server  Recovery of database 'model' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:15:27.87 server  Started recovery checkpoint for database 'model'.
00:00000:00001:2006/04/26 10:15:27.89 server  Completed recovery checkpoint for database 'model'.
00:00000:00001:2006/04/26 10:15:27.89 server  Started filling free space info for database 'model'.
00:00000:00001:2006/04/26 10:15:27.90 server  Completed filling free space info for database 'model'.
00:00000:00001:2006/04/26 10:15:27.92 server  Started cleaning up the default data cache for database 'model'.
00:00000:00001:2006/04/26 10:15:27.92 server  Completed cleaning up the default data cache for database 'model'.
00:00000:00001:2006/04/26 10:15:27.93 server  Checking external objects.
00:00000:00001:2006/04/26 10:15:27.95 server  The transaction log in the database 'model' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:15:28.01 server  Database 'model' is now online.
00:00000:00001:2006/04/26 10:15:28.01 server  The logical pagesize of the server is 4 Kb.
00:00000:00001:2006/04/26 10:15:28.01 server  0 dump conditions detected at boot time
00:00000:00001:2006/04/26 10:15:28.01 server  Resident Node id: d596b3f3bb4c
00:00000:00001:2006/04/26 10:15:28.01 server  Transaction coordinator initialized.
00:00000:00001:2006/04/26 10:15:28.01 server  Clearing temp db
00:00000:00001:2006/04/26 10:15:36.67 server  The transaction log in the database 'tempdb' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:15:36.70 server  Database 'tempdb' is now online.
00:00000:00001:2006/04/26 10:15:36.76 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.76 server  Started estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.76 server  Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.76 server  Started ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.76 server  Completed ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.76 server  Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:00000:00001:2006/04/26 10:15:36.76 server  Completed REDO pass for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.76 server  Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:15:36.76 server  Started recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.79 server  Completed recovery checkpoint for database 'sybsystemprocs'.

小无赖

00:00000:00001:2006/04/26 10:15:36.79 server  Started filling free space info for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.82 server  Completed filling free space info for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.82 server  Started cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.84 server  Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:15:36.85 server  Checking external objects.
00:00000:00001:2006/04/26 10:15:36.87 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:15:36.93 server  Database 'sybsystemprocs' is now online.
00:00000:00011:2006/04/26 10:15:36.93 kernel  network name bscszdsvr, type nlwnsck, port 6000, filter NONE
00:00000:00011:2006/04/26 10:15:36.95 kernel  network name 192.168.202.205, type tcp, port 6000, filter NONE
01:00000:00000:2006/04/26 10:15:36.95 kernel  Network and device connection limit is 99992.
01:00000:00000:2006/04/26 10:15:36.95 kernel  engine 1, os pid 808  online
00:00000:00001:2006/04/26 10:15:37.21 server  The wash size of the 4K buffer pool in cache default data cache has been changed from 61440 Kb to 61440 Kb due to a change in the size of the pool.
00:00000:00001:2006/04/26 10:15:37.23 server  Recovery has tuned the size of '32K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00000:00001:2006/04/26 10:15:37.23 server  Recovery has tuned the size of '4K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00000:00001:2006/04/26 10:15:37.23 server  Recovery has tuned the '32K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.
00:00000:00001:2006/04/26 10:15:37.23 server  Recovery has tuned the '4K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.
00:00000:00001:2006/04/26 10:15:37.23 server  The server will recover databases serially.
00:00000:00001:2006/04/26 10:15:37.29 server  Recovering database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.29 server  Started estimating recovery log boundaries for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.29 server  Completed estimating recovery log boundaries for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.29 server  Started ANALYSIS pass for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.29 server  Completed ANALYSIS pass for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.29 server  Started REDO pass for database 'BSHQS'. The total number of log records to process is 3.
00:00000:00001:2006/04/26 10:15:37.31 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2006/04/26 10:15:37.31 server  Completed REDO pass for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.31 server  Recovery of database 'BSHQS' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:15:37.31 server  Started recovery checkpoint for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.32 server  Completed recovery checkpoint for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.34 server  Started filling free space info for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.37 server  Completed filling free space info for database 'BSHQS'.
00:00000:00001:2006/04/26 10:15:37.39 server  Started cleaning up the default data cache for database 'BSHQS'.
01:00000:00001:2006/04/26 10:15:37.42 server  Completed cleaning up the default data cache for database 'BSHQS'.
01:00000:00001:2006/04/26 10:15:37.43 server  Checking external objects.
01:00000:00001:2006/04/26 10:15:37.45 server  The transaction log in the database 'BSHQS' will use I/O size of 4 Kb.
01:00000:00001:2006/04/26 10:15:37.56 server  Database 'BSHQS' is now online.
01:00000:00001:2006/04/26 10:15:37.64 server  Recovering database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.64 server  Started estimating recovery log boundaries for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.64 server  Completed estimating recovery log boundaries for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.64 server  Started ANALYSIS pass for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.64 server  Completed ANALYSIS pass for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.64 server  Started REDO pass for database 'BSSCS'. The total number of log records to process is 1.
01:00000:00001:2006/04/26 10:15:37.64 server  Completed REDO pass for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.64 server  Recovery of database 'BSSCS' will undo incomplete nested top actions.
01:00000:00001:2006/04/26 10:15:37.64 server  Started recovery checkpoint for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.67 server  Completed recovery checkpoint for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.68 server  Started filling free space info for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.70 server  Completed filling free space info for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.70 server  Started cleaning up the default data cache for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.75 server  Completed cleaning up the default data cache for database 'BSSCS'.
01:00000:00001:2006/04/26 10:15:37.76 server  Checking external objects.
01:00000:00001:2006/04/26 10:15:37.78 server  The transaction log in the database 'BSSCS' will use I/O size of 4 Kb.
01:00000:00001:2006/04/26 10:15:37.85 server  Database 'BSSCS' is now online.
01:00000:00001:2006/04/26 10:15:37.85 server  Recovery has restored the value of 'local async prefetch limit' for '32K' pool in 'default data cache' from '80' to 'DEFAULT'.
01:00000:00001:2006/04/26 10:15:37.85 server  Recovery has restored the value of 'local async prefetch limit' for '4K' pool in 'default data cache' from '80' to 'DEFAULT'.
01:00000:00001:2006/04/26 10:15:37.90 server  Recovery has restored the original size for '32K' pool and '4K' pool in 'default data cache'.
01:00000:00001:2006/04/26 10:15:37.92 server  Recovery complete.
01:00000:00001:2006/04/26 10:15:37.92 kernel  Reenlistment of DTC Transactions Complete
01:00000:00001:2006/04/26 10:15:37.92 server  SQL Server's default unicode sort order is 'binary'.
01:00000:00001:2006/04/26 10:15:37.93 server  SQL Server's default sort order is:
01:00000:00001:2006/04/26 10:15:37.93 server          'bin_iso_1' (ID = 50)
01:00000:00001:2006/04/26 10:15:37.93 server  on top of default character set:
01:00000:00001:2006/04/26 10:15:37.93 server          'iso_1' (ID = 1).
01:00000:00001:2006/04/26 10:15:37.93 server  Master device size: 60 megabytes, or 30720 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00004:2006/04/26 10:15:48.75 kernel  shutdownproc: shutting down SQL Server!
00:00000:00004:2006/04/26 10:15:48.98 kernel  XP Server is not running.
00:00000:00004:2006/04/26 10:15:49.18 server  SQL Server shutdown by request.
00:00000:00004:2006/04/26 10:15:49.20 kernel  ueshutdown: exiting
00:00000:00004:2006/04/26 10:15:49.20 kernel  shutdown waiting for engine pid 808 to exit...
00:00000:00004:2006/04/26 10:15:49.20 kernel  engine pid 808 exit completed
00:00000:00000:2006/04/26 10:15:51.73 kernel  Use license file C:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/04/26 10:15:51.73 kernel  Checked out license ASE_SERVER
00:00000:00000:2006/04/26 10:15:51.73 kernel  Adaptive Server Enterprise Edition
00:00000:00000:2006/04/26 10:15:51.75 kernel  Using config area from primary master device.
00:00000:00000:2006/04/26 10:15:51.76 kernel  Warning: Using default file 'C:\sybase\BSCSZDSVR.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/04/26 10:15:53.28 kernel  Using 100000 file descriptors.
00:00000:00000:2006/04/26 10:15:53.29 kernel  Adaptive Server Enterprise/12.5.1/EBF 11665 ESD#2/P/NT (IX86)/OS 4.0/ase1251/1838/32-bit/OPT/Fri Feb 20 04:11:31 2004
00:00000:00000:2006/04/26 10:15:53.29 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/04/26 10:15:53.29 kernel  Copyright 1987, 2004
00:00000:00000:2006/04/26 10:15:53.29 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/04/26 10:15:53.29 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/04/26 10:15:53.29 kernel  
00:00000:00000:2006/04/26 10:15:53.29 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/04/26 10:15:53.29 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/04/26 10:15:53.29 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/04/26 10:15:53.29 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/04/26 10:15:53.29 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/04/26 10:15:53.29 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/04/26 10:15:53.29 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2006/04/26 10:15:53.29 kernel  ASE booted on Windows 2000 build 2195 Service Pack 4.
00:00000:00000:2006/04/26 10:15:53.29 kernel  Using 'C:\sybase\BSCSZDSVR.cfg' for configuration information.
00:00000:00000:2006/04/26 10:15:53.29 kernel  Logging ASE messages in file 'C:\sybase\ASE-12_5\install\BSCSZDSVR.txt'.
00:00000:00000:2006/04/26 10:15:53.31 kernel  Initializing MSDTC Connection
00:00000:00000:2006/04/26 10:15:54.32 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/04/26 10:15:54.32 kernel  SQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2006/04/26 10:15:54.32 kernel  SQL Server NT process id is 0x4f4.
00:00000:00000:2006/04/26 10:15:54.32 kernel  SQL Server was started as a Service.
00:00000:00000:2006/04/26 10:15:54.32 kernel  SSL Plus v3.1.5 security modules loaded successfully.
00:00000:00000:2006/04/26 10:15:54.32 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/04/26 10:15:54.73 server  Number of blocks left for proc headers: 102352.
00:00000:00000:2006/04/26 10:15:54.76 server  Proc header memory allocated 25588 pages for each per engine cache
00:00000:00000:2006/04/26 10:15:55.81 server  Size of the 4K memory pool: 8 Kb
00:00000:00000:2006/04/26 10:15:55.81 server  Memory allocated for the default data cache cachelet 1: 1048568 Kb
00:00000:00000:2006/04/26 10:15:55.81 kernel  Initializing virtual device 0, 'C:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2006/04/26 10:15:55.81 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/04/26 10:15:55.81 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2006/04/26 10:15:55.82 kernel  engine 0, os pid 256  online
00:00000:00000:2006/04/26 10:15:55.82 server  No active traceflags
00:00000:00001:2006/04/26 10:15:55.82 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.1/EBF 11665 ESD#2/P/NT (IX86)/OS 4.0/ase1251/1838/32-bit/OPT/Fri Feb 20 04:11:31 2004'.
00:00000:00001:2006/04/26 10:15:55.82 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1 ASE Edition/P-EBF11378/PC Intel/BUILD1251-004/OPT/Thu Aug 14 11:57:18 2003'
00:00000:00001:2006/04/26 10:15:55.82 server  Opening Master Database ...
00:00000:00001:2006/04/26 10:15:55.93 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/04/26 10:15:55.95 server  Loaded default Unilib conversion handle.
00:00000:00001:2006/04/26 10:15:55.95 server  Recovering database 'master'.

小无赖

00:00000:00001:2006/04/26 10:15:55.96 server  Started estimating recovery log boundaries for database 'master'.
00:00000:00001:2006/04/26 10:15:55.96 server  Completed estimating recovery log boundaries for database 'master'.
00:00000:00001:2006/04/26 10:15:55.96 server  Started ANALYSIS pass for database 'master'.
00:00000:00001:2006/04/26 10:15:55.96 server  Completed ANALYSIS pass for database 'master'.
00:00000:00001:2006/04/26 10:15:55.96 server  Started REDO pass for database 'master'. The total number of log records to process is 1.
00:00000:00001:2006/04/26 10:15:55.96 server  Completed REDO pass for database 'master'.
00:00000:00001:2006/04/26 10:15:55.96 server  Recovery of database 'master' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:15:55.96 server  Started recovery checkpoint for database 'master'.
00:00000:00001:2006/04/26 10:15:55.98 server  Completed recovery checkpoint for database 'master'.
00:00000:00001:2006/04/26 10:15:56.00 server  Started filling free space info for database 'master'.
00:00000:00001:2006/04/26 10:15:56.01 server  Completed filling free space info for database 'master'.
00:00000:00001:2006/04/26 10:15:56.03 server  Started cleaning up the default data cache for database 'master'.
00:00000:00001:2006/04/26 10:15:56.04 server  Completed cleaning up the default data cache for database 'master'.
00:00000:00001:2006/04/26 10:15:56.06 server  Checking external objects.
00:00000:00001:2006/04/26 10:15:56.10 server  Database 'master' is now online.
00:00000:00001:2006/04/26 10:15:56.10 server  The transaction log in the database 'master' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:15:56.12 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2006/04/26 10:15:56.14 server  server is unnamed
00:00000:00001:2006/04/26 10:15:56.14 server  Activating disk 'BSHQS_datadev01' of size 2048000 KB.
00:00000:00001:2006/04/26 10:15:56.14 kernel  Initializing virtual device 4, 'd:\database\BSHQS_datadev01.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:56.15 server  Activating disk 'BSHQS_datadev02' of size 2048000 KB.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Initializing virtual device 8, 'D:\Database\BSHQS_datadev02.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Virtual device 8 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:56.15 server  Activating disk 'BSHQS_logdev' of size 1024000 KB.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Initializing virtual device 5, 'd:\database\BSHQS_logdev.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:56.15 server  Activating disk 'BSSCS_datadev01' of size 2048000 KB.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Initializing virtual device 6, 'd:\database\BSSCS_datadev01.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Virtual device 6 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:56.15 server  Activating disk 'BSSCS_logdev' of size 1024000 KB.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Initializing virtual device 7, 'd:\database\BSSCS_logdev.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Virtual device 7 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:56.15 server  Activating disk 'sysprocsdev' of size 122880 KB.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Initializing virtual device 1, 'C:\sybase\data\sysprocs.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:56.15 server  Activating disk 'tempdb_datadev' of size 1024000 KB.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Initializing virtual device 2, 'D:\database\tempdb_datadev.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:56.15 server  Activating disk 'tempdb_logdev' of size 512000 KB.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Initializing virtual device 3, 'd:\database\tempdb_logdev.dat' with dsync 'on'.
00:00000:00001:2006/04/26 10:15:56.15 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2006/04/26 10:15:56.28 server  Recovering database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.28 server  Started estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.29 server  Completed estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.29 server  Started ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.29 server  Completed ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.29 server  Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1.
00:00000:00001:2006/04/26 10:15:56.29 server  Completed REDO pass for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.29 server  Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:15:56.29 server  Started recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.31 server  Completed recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.32 server  Started filling free space info for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.34 server  Completed filling free space info for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.34 server  Started cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.35 server  Completed cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2006/04/26 10:15:56.35 server  Boot Count: 105
00:00000:00001:2006/04/26 10:15:56.39 server  Checking external objects.
00:00000:00001:2006/04/26 10:15:56.40 server  The transaction log in the database 'sybsystemdb' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:15:56.46 server  Database 'sybsystemdb' is now online.
00:00000:00001:2006/04/26 10:15:56.51 server  Recovering database 'model'.
00:00000:00001:2006/04/26 10:15:56.53 server  Started estimating recovery log boundaries for database 'model'.
00:00000:00001:2006/04/26 10:15:56.53 server  Completed estimating recovery log boundaries for database 'model'.
00:00000:00001:2006/04/26 10:15:56.53 server  Started ANALYSIS pass for database 'model'.
00:00000:00001:2006/04/26 10:15:56.53 server  Completed ANALYSIS pass for database 'model'.
00:00000:00001:2006/04/26 10:15:56.53 server  Started REDO pass for database 'model'. The total number of log records to process is 1.
00:00000:00001:2006/04/26 10:15:56.53 server  Completed REDO pass for database 'model'.
00:00000:00001:2006/04/26 10:15:56.53 server  Recovery of database 'model' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:15:56.53 server  Started recovery checkpoint for database 'model'.
00:00000:00001:2006/04/26 10:15:56.54 server  Completed recovery checkpoint for database 'model'.
00:00000:00001:2006/04/26 10:15:56.56 server  Started filling free space info for database 'model'.
00:00000:00001:2006/04/26 10:15:56.57 server  Completed filling free space info for database 'model'.
00:00000:00001:2006/04/26 10:15:56.59 server  Started cleaning up the default data cache for database 'model'.
00:00000:00001:2006/04/26 10:15:56.59 server  Completed cleaning up the default data cache for database 'model'.
00:00000:00001:2006/04/26 10:15:56.60 server  Checking external objects.
00:00000:00001:2006/04/26 10:15:56.62 server  The transaction log in the database 'model' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:15:56.67 server  Database 'model' is now online.
00:00000:00001:2006/04/26 10:15:56.67 server  The logical pagesize of the server is 4 Kb.
00:00000:00001:2006/04/26 10:15:56.67 server  0 dump conditions detected at boot time
00:00000:00001:2006/04/26 10:15:56.67 server  Resident Node id: d596b3f3bb4c
00:00000:00001:2006/04/26 10:15:56.67 server  Transaction coordinator initialized.
00:00000:00001:2006/04/26 10:15:56.67 server  Clearing temp db
00:00000:00001:2006/04/26 10:16:05.85 server  The transaction log in the database 'tempdb' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:16:05.87 server  Database 'tempdb' is now online.
00:00000:00001:2006/04/26 10:16:05.93 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:05.93 server  Started estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:05.93 server  Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:05.95 server  Started ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:05.95 server  Completed ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:05.95 server  Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:00000:00001:2006/04/26 10:16:05.95 server  Completed REDO pass for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:05.95 server  Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:16:05.95 server  Started recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:05.96 server  Completed recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:05.98 server  Started filling free space info for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:06.00 server  Completed filling free space info for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:06.00 server  Started cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:06.01 server  Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2006/04/26 10:16:06.01 server  Checking external objects.
00:00000:00001:2006/04/26 10:16:06.04 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 4 Kb.
00:00000:00001:2006/04/26 10:16:06.09 server  Database 'sybsystemprocs' is now online.
00:00000:00011:2006/04/26 10:16:06.10 kernel  network name bscszdsvr, type nlwnsck, port 6000, filter NONE
00:00000:00011:2006/04/26 10:16:06.10 kernel  network name 192.168.202.205, type tcp, port 6000, filter NONE
01:00000:00000:2006/04/26 10:16:06.12 kernel  Network and device connection limit is 99992.
01:00000:00000:2006/04/26 10:16:06.12 kernel  engine 1, os pid 808  online
00:00000:00001:2006/04/26 10:16:06.60 server  The wash size of the 4K buffer pool in cache default data cache has been changed from 61440 Kb to 61440 Kb due to a change in the size of the pool.
00:00000:00001:2006/04/26 10:16:06.60 server  Recovery has tuned the size of '32K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00000:00001:2006/04/26 10:16:06.60 server  Recovery has tuned the size of '4K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00000:00001:2006/04/26 10:16:06.60 server  Recovery has tuned the '32K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.
00:00000:00001:2006/04/26 10:16:06.60 server  Recovery has tuned the '4K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.
00:00000:00001:2006/04/26 10:16:06.60 server  The server will recover databases serially.
00:00000:00001:2006/04/26 10:16:06.60 server  Recovering database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.62 server  Started estimating recovery log boundaries for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.62 server  Completed estimating recovery log boundaries for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.62 server  Started ANALYSIS pass for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.62 server  Completed ANALYSIS pass for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.62 server  Started REDO pass for database 'BSHQS'. The total number of log records to process is 3.
00:00000:00001:2006/04/26 10:16:06.62 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2006/04/26 10:16:06.62 server  Completed REDO pass for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.62 server  Recovery of database 'BSHQS' will undo incomplete nested top actions.
00:00000:00001:2006/04/26 10:16:06.62 server  Started recovery checkpoint for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.65 server  Completed recovery checkpoint for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.67 server  Started filling free space info for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.68 server  Completed filling free space info for database 'BSHQS'.
00:00000:00001:2006/04/26 10:16:06.70 server  Started cleaning up the default data cache for database 'BSHQS'.
01:00000:00001:2006/04/26 10:16:06.71 server  Completed cleaning up the default data cache for database 'BSHQS'.
01:00000:00001:2006/04/26 10:16:06.73 server  Checking external objects.
01:00000:00001:2006/04/26 10:16:06.75 server  The transaction log in the database 'BSHQS' will use I/O size of 4 Kb.
01:00000:00001:2006/04/26 10:16:06.82 server  Database 'BSHQS' is now online.
01:00000:00001:2006/04/26 10:16:06.89 server  Recovering database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.89 server  Started estimating recovery log boundaries for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.90 server  Completed estimating recovery log boundaries for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.90 server  Started ANALYSIS pass for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.90 server  Completed ANALYSIS pass for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.90 server  Started REDO pass for database 'BSSCS'. The total number of log records to process is 1.
01:00000:00001:2006/04/26 10:16:06.90 server  Completed REDO pass for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.90 server  Recovery of database 'BSSCS' will undo incomplete nested top actions.
01:00000:00001:2006/04/26 10:16:06.90 server  Started recovery checkpoint for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.92 server  Completed recovery checkpoint for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.93 server  Started filling free space info for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.96 server  Completed filling free space info for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:06.96 server  Started cleaning up the default data cache for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:07.00 server  Completed cleaning up the default data cache for database 'BSSCS'.
01:00000:00001:2006/04/26 10:16:07.01 server  Checking external objects.
01:00000:00001:2006/04/26 10:16:07.03 server  The transaction log in the database 'BSSCS' will use I/O size of 4 Kb.
01:00000:00001:2006/04/26 10:16:07.10 server  Database 'BSSCS' is now online.
01:00000:00001:2006/04/26 10:16:07.10 server  Recovery has restored the value of 'local async prefetch limit' for '32K' pool in 'default data cache' from '80' to 'DEFAULT'.
01:00000:00001:2006/04/26 10:16:07.10 server  Recovery has restored the value of 'local async prefetch limit' for '4K' pool in 'default data cache' from '80' to 'DEFAULT'.
01:00000:00001:2006/04/26 10:16:07.15 server  Recovery has restored the original size for '32K' pool and '4K' pool in 'default data cache'.
01:00000:00001:2006/04/26 10:16:07.17 server  Recovery complete.
01:00000:00001:2006/04/26 10:16:07.17 kernel  Reenlistment of DTC Transactions Complete
01:00000:00001:2006/04/26 10:16:07.17 server  SQL Server's default unicode sort order is 'binary'.
01:00000:00001:2006/04/26 10:16:07.17 server  SQL Server's default sort order is:
01:00000:00001:2006/04/26 10:16:07.17 server          'bin_iso_1' (ID = 50)
01:00000:00001:2006/04/26 10:16:07.17 server  on top of default character set:
01:00000:00001:2006/04/26 10:16:07.17 server          'iso_1' (ID = 1).
01:00000:00001:2006/04/26 10:16:07.17 server  Master device size: 60 megabytes, or 30720 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00019:2006/04/26 10:18:27.01 kernel  Cannot send, host process disconnected: 百货理手 276 spid: 19
00:00000:00019:2006/04/26 10:18:27.03 server  Error: 1608, Severity: 18, State: 4
00:00000:00019:2006/04/26 10:18:27.03 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

echoaix

没有看出什么啊，感觉就是有人把ase shutdown了

小无赖

01:00000:00009:2006/04/26 10:04:04.70 server  Exceeded license usage limit. Contact Sybase Sales for additional licenses.
00:00000:00004:2006/04/26 10:15:20.45 kernel  shutdownproc: shutting down SQL Server!

我在10:15分前发现应用程序不能连接到数据库,这时我在服务器上用sybase的dsedit都ping不通服务.但已连接在数据库上的应用程序可以继续使用,但也ping不通服务(居然会有这种事).这时看errorlog最后一行就是
01:00000:00009:2006/04/26 10:04:04.70 server  Exceeded license usage limit. Contact Sybase Sales for additional licenses.
此时没有办法我就重启了服务.
上面说超出了license使用限制是什么意思,会不会与它有关系?奇怪的是相同版本的安装在另一台服务器上的没有这个提示.

现在又出现这个故障了,errorlog中任何信息都没有,只有重启服务.

[ 本帖最后由 小无赖 于 2006-4-26 12:01 编辑 ]

echoaix

你的license不够，是不是连接数有限制？

小无赖

原帖由 echoaix 于 2006-4-26 12:04 发表
你的license不够，是不是连接数有限制？

什么意思?该怎么办?
我对license不熟.