sybase数据丢失的问题，很奇怪，帮忙看看是什么问题？

wyckwemail

大概情况是这样：
我公司采用SYBASE12。5(windows2k)的数据库，昨天下午1:00左右发现数据库有问题，然后就重启服务器，发现从上午10：30后到下午1：00数据丢失了，包括好几个表（如应用程序登陆日志表，销售表），但是听其他人反映，在上午11点多还有很多销售数据，数据也正常的被前台提取，但后来一查差了2万多，在数据库中我们设置了，truncate log on check point ，按道理说事务提交后数据应该传到后台数据库了，怎么就刚好丢了这段时间的数据！
数据库也很正常！
各位大哥门有没有遇到这问题！
谢谢！

jtyhyl

errorlog贴出看看

hobbylu

你怎么重起的

常笑

因重起丢失数据也有可能！
数据还在内存中，还没写入硬盘！
但丢失的太多，就感觉奇怪了！除非该表绑定在内存，是否是该情况?
还有可能大的事务导致回滚，楼主认为丢失了数据，看一下启动日志，是否大量回滚？

wyckwemail

00:00000:00000:2006/02/23 06:28:45.89 kernel  Use license file c:\sybase\\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/02/23 06:28:46.01 kernel  Checked out license ASE_SERVER
00:00000:00000:2006/02/23 06:28:47.39 kernel  Using config area from primary master device.
00:00000:00000:2006/02/23 06:28:47.70 kernel  Warning: Using default file 'c:\sybase\dbbra_yz.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/02/23 06:28:50.59 kernel  Using 100000 file descriptors.
00:00000:00000:2006/02/23 06:28:50.89 kernel  Adaptive Server Enterprise/12.5/SWR 9795 ESD 2/P/NT (IX86)/OS 4.0/rel125/1687/32-bit/OPT/Sat Sep 22 22:37:20 2001
00:00000:00000:2006/02/23 06:28:50.89 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/02/23 06:28:50.89 kernel  Copyright 1987, 2001
00:00000:00000:2006/02/23 06:28:50.89 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/02/23 06:28:50.89 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/02/23 06:28:50.89 kernel  
00:00000:00000:2006/02/23 06:28:50.89 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/02/23 06:28:50.89 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/02/23 06:28:50.89 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/02/23 06:28:50.89 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/02/23 06:28:50.89 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/02/23 06:28:50.89 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/02/23 06:28:50.89 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/02/23 06:28:50.89 kernel  Using 'c:\sybase\dbbra_yz.cfg' for configuration information.
00:00000:00000:2006/02/23 06:28:50.89 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2006/02/23 06:28:51.00 kernel  Initializing MSDTC Connection
00:00000:00000:2006/02/23 06:28:53.21 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/02/23 06:28:53.29 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2006/02/23 06:28:53.31 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/02/23 06:28:53.31 kernel  *** WARNING ******************
00:00000:00000:2006/02/23 06:28:53.31 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2006/02/23 06:28:53.31 kernel  SQL Server NT process id is 0x56c.
00:00000:00000:2006/02/23 06:28:53.31 kernel  SQL Server was started as a Service.
00:00000:00000:2006/02/23 06:28:53.34 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2006/02/23 06:28:53.35 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/02/23 06:28:53.64 server  Number of blocks left for proc headers: 9960.
00:00000:00000:2006/02/23 06:28:53.67 server  Proc header memory allocated 4980 pages for each per engine cache
00:00000:00000:2006/02/23 06:28:55.53 server  Memory allocated for the default data cache cachelet 1: 614400 Kb
00:00000:00000:2006/02/23 06:28:55.62 server  Size of the 16K memory pool: 307200 Kb
00:00000:00000:2006/02/23 06:28:55.71 server  Size of the 2K memory pool: 307200 Kb
00:00000:00000:2006/02/23 06:28:55.73 kernel  Initializing virtual device 0, 'D:\data\master.dat' with dsync 'on'.
00:00000:00000:2006/02/23 06:28:55.73 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/02/23 06:28:55.73 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/02/23 06:28:55.73 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/02/23 06:28:55.73 kernel  engine 0, os pid 412  online
00:00000:00000:2006/02/23 06:28:55.75 server  No active traceflags
00:00000:00001:2006/02/23 06:28:55.84 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9795 ESD 2/P/NT (IX86)/OS 4.0/rel125/1687/32-bit/OPT/Sat Sep 22 22:37:20 2001'.
00:00000:00001:2006/02/23 06:28:55.84 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/PC Intel/BUILD125-005/OPT/Sat May 19 14:48:00 2001'
00:00000:00001:2006/02/23 06:28:55.84 server  Opening Master Database ...
00:00000:00001:2006/02/23 06:28:56.40 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/02/23 06:28:56.48 server  Loaded default Unilib conversion handle.
00:00000:00001:2006/02/23 06:28:56.68 server  Recovering database 'master'.
00:00000:00001:2006/02/23 06:28:57.01 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2006/02/23 06:29:01.70 server  Checking external objects.
00:00000:00001:2006/02/23 06:29:01.81 server  Database 'master' is now online.
00:00000:00001:2006/02/23 06:29:01.81 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 06:29:01.87 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2006/02/23 06:29:01.90 server  server is unnamed
00:00000:00001:2006/02/23 06:29:01.90 server  Activating disk 'bra60'.
00:00000:00001:2006/02/23 06:29:01.90 kernel  Initializing virtual device 2, 'D:\data\bra60.dat' with dsync 'off'.
00:00000:00001:2006/02/23 06:29:01.93 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2006/02/23 06:29:01.93 server  Activating disk 'bra60_dev1'.
00:00000:00001:2006/02/23 06:29:01.93 kernel  Initializing virtual device 4, 'E:\data\bra60_dev1.dat' with dsync 'off'.
00:00000:00001:2006/02/23 06:29:01.95 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2006/02/23 06:29:01.95 server  Activating disk 'bra60_log'.
00:00000:00001:2006/02/23 06:29:01.95 kernel  Initializing virtual device 3, 'D:\data\bra60_log.dat' with dsync 'off'.
00:00000:00001:2006/02/23 06:29:02.00 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2006/02/23 06:29:02.00 server  Activating disk 'sysprocsdev'.
00:00000:00001:2006/02/23 06:29:02.00 kernel  Initializing virtual device 1, 'D:\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2006/02/23 06:29:02.01 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2006/02/23 06:29:02.17 server  Recovering database 'sybsystemdb'.
00:00000:00001:2006/02/23 06:29:02.18 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2006/02/23 06:29:06.76 server  Boot Count: 1130
00:00000:00001:2006/02/23 06:29:06.82 server  Checking external objects.
00:00000:00001:2006/02/23 06:29:06.82 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 06:29:06.90 server  Database 'sybsystemdb' is now online.
00:00000:00001:2006/02/23 06:29:06.95 server  Recovering database 'model'.
00:00000:00001:2006/02/23 06:29:08.10 server  Checking external objects.
00:00000:00001:2006/02/23 06:29:08.17 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 06:29:08.48 server  Database 'model' is now online.
00:00000:00001:2006/02/23 06:29:08.48 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2006/02/23 06:29:08.48 server  0 dump conditions detected at boot time
00:00000:00001:2006/02/23 06:29:08.48 server  Resident Node id: ac35bb3ce026
00:00000:00001:2006/02/23 06:29:08.48 server  Transaction coordinator initialized.
00:00000:00001:2006/02/23 06:29:08.51 server  Clearing temp db
00:00000:00001:2006/02/23 06:29:20.73 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 06:29:20.81 server  Database 'tempdb' is now online.
00:00000:00001:2006/02/23 06:29:20.95 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/02/23 06:29:28.42 server  Checking external objects.
00:00000:00001:2006/02/23 06:29:28.43 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 06:29:28.51 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2006/02/23 06:29:28.51 kernel  network name 192.168.119.1, type ether, port 5000, filter NONE
00:00000:00001:2006/02/23 06:29:28.68 server  Recovering database 'bra60'.
00:00000:00001:2006/02/23 06:29:28.71 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2006/02/23 06:29:41.39 server  Checking external objects.
00:00000:00001:2006/02/23 06:29:41.40 server  The transaction log in the database 'bra60' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 06:29:41.50 server  Database 'bra60' is now online.
00:00000:00001:2006/02/23 06:29:41.51 server  Recovery complete.
00:00000:00001:2006/02/23 06:29:41.51 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2006/02/23 06:29:41.51 server  SQL Server's default sort order is:
00:00000:00001:2006/02/23 06:29:41.51 server          'altnoacc_cp850' (ID = 39)
00:00000:00001:2006/02/23 06:29:41.51 server  on top of default character set:
00:00000:00001:2006/02/23 06:29:41.51 server          'cp850' (ID = 2).
00:00000:00001:2006/02/23 06:29:41.51 server  Master device size: 800 megabytes, or 409600 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00014:2006/02/23 06:29:41.89 server  Error: 7214, Severity: 11, State: 1
00:00000:00014:2006/02/23 06:29:41.89 server  No site name received in server login packet.  Server login rejected.
00:00000:00013:2006/02/23 06:29:41.89 server  Error: 7221, Severity: 14, State: 1
00:00000:00013:2006/02/23 06:29:41.89 server  Login to site 'dbbra_yz_XP' failed.

wyckwemail

00:00000:00000:2006/02/23 06:47:57.57 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/02/23 06:47:57.78 kernel  Checked out license ASE_SERVER
00:00000:00000:2006/02/23 06:48:00.07 kernel  Using config area from primary master device.
00:00000:00000:2006/02/23 06:48:01.46 kernel  Warning: Using default file 'c:\sybase\dbbra_yz.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/02/23 06:48:01.62 kernel  os_get_shmid: Could not open file c:\sybase\ASE-12_5\dbbra_yz.krg, File exists
00:00000:00000:2006/02/23 06:48:01.62 kernel  os_create_keyfile: Shared memory segment dbbra_yz.krg is in use. Check if SQL Server is already running. If NOT remove old .srg/.krg files & restart.
00:00000:00000:2006/02/23 06:48:01.62 kernel  kbcreate: couldn't get shmid for kernel region.
00:00000:00000:2006/02/23 06:48:01.62 kernel  kistartup: could not create shared memory
00:00000:00000:2006/02/23 07:34:56.29 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/02/23 07:34:56.29 kernel  Checked out license ASE_SERVER
00:00000:00000:2006/02/23 07:34:56.56 kernel  Using config area from primary master device.
00:00000:00000:2006/02/23 07:34:56.62 kernel  Warning: Using default file 'c:\sybase\dbbra_yz.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/02/23 07:34:56.65 kernel  os_get_shmid: Could not open file c:\sybase\ASE-12_5\dbbra_yz.krg, File exists
00:00000:00000:2006/02/23 07:34:56.65 kernel  os_create_keyfile: Shared memory segment dbbra_yz.krg is in use. Check if SQL Server is already running. If NOT remove old .srg/.krg files & restart.
00:00000:00000:2006/02/23 07:34:56.65 kernel  kbcreate: couldn't get shmid for kernel region.
00:00000:00000:2006/02/23 07:34:56.65 kernel  kistartup: could not create shared memory
00:00000:00000:2006/02/23 07:35:18.45 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/02/23 07:35:18.45 kernel  Checked out license ASE_SERVER
00:00000:00000:2006/02/23 07:35:18.46 kernel  Using config area from primary master device.
00:00000:00000:2006/02/23 07:35:18.46 kernel  Warning: Using default file 'c:\sybase\dbbra_yz.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/02/23 07:35:18.48 kernel  os_get_shmid: Could not open file c:\sybase\ASE-12_5\dbbra_yz.krg, File exists
00:00000:00000:2006/02/23 07:35:18.48 kernel  os_create_keyfile: Shared memory segment dbbra_yz.krg is in use. Check if SQL Server is already running. If NOT remove old .srg/.krg files & restart.
00:00000:00000:2006/02/23 07:35:18.48 kernel  kbcreate: couldn't get shmid for kernel region.
00:00000:00000:2006/02/23 07:35:18.48 kernel  kistartup: could not create shared memory
00:00000:00000:2006/02/23 07:39:51.07 kernel  Use license file c:\sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2006/02/23 07:39:51.18 kernel  Checked out license ASE_SERVER
00:00000:00000:2006/02/23 07:39:52.89 kernel  Using config area from primary master device.
00:00000:00000:2006/02/23 07:39:53.14 kernel  Warning: Using default file 'c:\sybase\dbbra_yz.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/02/23 07:39:56.93 kernel  Using 100000 file descriptors.
00:00000:00000:2006/02/23 07:39:57.18 kernel  Adaptive Server Enterprise/12.5/SWR 9795 ESD 2/P/NT (IX86)/OS 4.0/rel125/1687/32-bit/OPT/Sat Sep 22 22:37:20 2001
00:00000:00000:2006/02/23 07:39:57.18 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/02/23 07:39:57.18 kernel  Copyright 1987, 2001
00:00000:00000:2006/02/23 07:39:57.18 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/02/23 07:39:57.18 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/02/23 07:39:57.18 kernel  
00:00000:00000:2006/02/23 07:39:57.18 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/02/23 07:39:57.18 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/02/23 07:39:57.18 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/02/23 07:39:57.18 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/02/23 07:39:57.18 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/02/23 07:39:57.18 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/02/23 07:39:57.18 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/02/23 07:39:57.18 kernel  Using 'c:\sybase\dbbra_yz.cfg' for configuration information.
00:00000:00000:2006/02/23 07:39:57.18 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2006/02/23 07:39:57.28 kernel  Initializing MSDTC Connection
00:00000:00000:2006/02/23 07:39:59.45 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/02/23 07:39:59.45 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2006/02/23 07:39:59.45 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/02/23 07:39:59.45 kernel  *** WARNING ******************
00:00000:00000:2006/02/23 07:39:59.45 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2006/02/23 07:39:59.45 kernel  SQL Server NT process id is 0x53c.
00:00000:00000:2006/02/23 07:39:59.45 kernel  SQL Server was started as a Service.
00:00000:00000:2006/02/23 07:39:59.46 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2006/02/23 07:39:59.46 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/02/23 07:39:59.79 server  Number of blocks left for proc headers: 9960.
00:00000:00000:2006/02/23 07:39:59.84 server  Proc header memory allocated 4980 pages for each per engine cache
00:00000:00000:2006/02/23 07:40:01.71 server  Memory allocated for the default data cache cachelet 1: 614400 Kb
00:00000:00000:2006/02/23 07:40:01.81 server  Size of the 16K memory pool: 307200 Kb
00:00000:00000:2006/02/23 07:40:01.90 server  Size of the 2K memory pool: 307200 Kb
00:00000:00000:2006/02/23 07:40:01.92 kernel  Initializing virtual device 0, 'D:\data\master.dat' with dsync 'on'.
00:00000:00000:2006/02/23 07:40:01.92 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/02/23 07:40:01.92 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/02/23 07:40:01.92 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/02/23 07:40:01.93 kernel  engine 0, os pid 416  online
00:00000:00000:2006/02/23 07:40:02.00 server  No active traceflags
00:00000:00001:2006/02/23 07:40:02.32 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9795 ESD 2/P/NT (IX86)/OS 4.0/rel125/1687/32-bit/OPT/Sat Sep 22 22:37:20 2001'.
00:00000:00001:2006/02/23 07:40:02.32 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/PC Intel/BUILD125-005/OPT/Sat May 19 14:48:00 2001'
00:00000:00001:2006/02/23 07:40:02.32 server  Opening Master Database ...
00:00000:00001:2006/02/23 07:40:03.12 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/02/23 07:40:03.26 server  Loaded default Unilib conversion handle.
00:00000:00001:2006/02/23 07:40:03.39 server  Recovering database 'master'.
00:00000:00001:2006/02/23 07:40:03.53 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2006/02/23 07:40:06.92 server  Checking external objects.
00:00000:00001:2006/02/23 07:40:07.15 server  Database 'master' is now online.
00:00000:00001:2006/02/23 07:40:07.15 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 07:40:07.21 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2006/02/23 07:40:07.31 server  server is unnamed
00:00000:00001:2006/02/23 07:40:07.39 server  Activating disk 'bra60'.
00:00000:00001:2006/02/23 07:40:07.39 kernel  Initializing virtual device 2, 'D:\data\bra60.dat' with dsync 'off'.
00:00000:00001:2006/02/23 07:40:07.45 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2006/02/23 07:40:07.45 server  Activating disk 'bra60_dev1'.
00:00000:00001:2006/02/23 07:40:07.45 kernel  Initializing virtual device 4, 'E:\data\bra60_dev1.dat' with dsync 'off'.
00:00000:00001:2006/02/23 07:40:07.48 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2006/02/23 07:40:07.48 server  Activating disk 'bra60_log'.
00:00000:00001:2006/02/23 07:40:07.48 kernel  Initializing virtual device 3, 'D:\data\bra60_log.dat' with dsync 'off'.
00:00000:00001:2006/02/23 07:40:07.62 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2006/02/23 07:40:07.62 server  Activating disk 'sysprocsdev'.
00:00000:00001:2006/02/23 07:40:07.62 kernel  Initializing virtual device 1, 'D:\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2006/02/23 07:40:07.67 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2006/02/23 07:40:08.17 server  Recovering database 'sybsystemdb'.
00:00000:00001:2006/02/23 07:40:08.17 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2006/02/23 07:40:12.84 server  Boot Count: 1131
00:00000:00001:2006/02/23 07:40:12.98 server  Checking external objects.
00:00000:00001:2006/02/23 07:40:13.06 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 07:40:13.25 server  Database 'sybsystemdb' is now online.
00:00000:00001:2006/02/23 07:40:13.48 server  Recovering database 'model'.
00:00000:00001:2006/02/23 07:40:14.73 server  Checking external objects.
00:00000:00001:2006/02/23 07:40:14.75 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 07:40:14.81 server  Database 'model' is now online.
00:00000:00001:2006/02/23 07:40:14.81 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2006/02/23 07:40:14.81 server  0 dump conditions detected at boot time
00:00000:00001:2006/02/23 07:40:14.81 server  Resident Node id: ac35bb3ce026
00:00000:00001:2006/02/23 07:40:14.81 server  Transaction coordinator initialized.
00:00000:00001:2006/02/23 07:40:14.81 server  Clearing temp db
00:00000:00001:2006/02/23 07:40:28.07 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.

wyckwemail

00:00000:00001:2006/02/23 07:40:28.15 server  Database 'tempdb' is now online.
00:00000:00001:2006/02/23 07:40:28.29 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/02/23 07:40:39.46 server  Checking external objects.
00:00000:00001:2006/02/23 07:40:39.51 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 07:40:39.64 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2006/02/23 07:40:39.64 kernel  network name 192.168.119.1, type ether, port 5000, filter NONE
00:00000:00001:2006/02/23 07:40:39.90 server  Recovering database 'bra60'.
00:00000:00001:2006/02/23 07:40:57.75 server  Checking external objects.
00:00000:00001:2006/02/23 07:40:57.75 server  The transaction log in the database 'bra60' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 07:40:57.85 server  Database 'bra60' is now online.
00:00000:00001:2006/02/23 07:40:57.87 server  Recovery complete.
00:00000:00001:2006/02/23 07:40:57.87 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2006/02/23 07:40:57.87 server  SQL Server's default sort order is:
00:00000:00001:2006/02/23 07:40:57.87 server          'altnoacc_cp850' (ID = 39)
00:00000:00001:2006/02/23 07:40:57.87 server  on top of default character set:
00:00000:00001:2006/02/23 07:40:57.87 server          'cp850' (ID = 2).
00:00000:00001:2006/02/23 07:40:57.89 server  Master device size: 800 megabytes, or 409600 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00014:2006/02/23 07:40:58.34 server  Error: 7214, Severity: 11, State: 1
00:00000:00014:2006/02/23 07:40:58.34 server  No site name received in server login packet.  Server login rejected.
00:00000:00013:2006/02/23 07:40:58.42 server  Error: 7221, Severity: 14, State: 1
00:00000:00013:2006/02/23 07:40:58.42 server  Login to site 'dbbra_yz_XP' failed.
00:00000:00000:2006/02/23 13:25:14.42 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2006/02/23 13:25:16.81 kernel  Using config area from primary master device.
00:00000:00000:2006/02/23 13:25:16.98 kernel  Warning: Using default file 'c:\sybase\dbbra_yz.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/02/23 13:25:19.89 kernel  Using 100000 file descriptors.
00:00000:00000:2006/02/23 13:25:20.28 kernel  Adaptive Server Enterprise/12.5/SWR 9795 ESD 2/P/NT (IX86)/OS 4.0/rel125/1687/32-bit/OPT/Sat Sep 22 22:37:20 2001
00:00000:00000:2006/02/23 13:25:20.28 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/02/23 13:25:20.28 kernel  Copyright 1987, 2001
00:00000:00000:2006/02/23 13:25:20.28 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/02/23 13:25:20.28 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/02/23 13:25:20.28 kernel  
00:00000:00000:2006/02/23 13:25:20.28 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/02/23 13:25:20.28 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/02/23 13:25:20.28 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/02/23 13:25:20.28 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/02/23 13:25:20.28 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/02/23 13:25:20.28 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/02/23 13:25:20.28 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/02/23 13:25:20.28 kernel  Using 'c:\sybase\dbbra_yz.cfg' for configuration information.
00:00000:00000:2006/02/23 13:25:20.28 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2006/02/23 13:25:20.40 kernel  Initializing MSDTC Connection
00:00000:00000:2006/02/23 13:25:22.53 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/02/23 13:25:22.90 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2006/02/23 13:25:22.92 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/02/23 13:25:22.92 kernel  *** WARNING ******************
00:00000:00000:2006/02/23 13:25:22.92 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2006/02/23 13:25:22.92 kernel  SQL Server NT process id is 0x550.
00:00000:00000:2006/02/23 13:25:22.92 kernel  SQL Server was started as a Service.
00:00000:00000:2006/02/23 13:25:22.95 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2006/02/23 13:25:22.96 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/02/23 13:25:23.25 server  Number of blocks left for proc headers: 9960.
00:00000:00000:2006/02/23 13:25:23.29 server  Proc header memory allocated 4980 pages for each per engine cache
00:00000:00000:2006/02/23 13:25:25.15 server  Memory allocated for the default data cache cachelet 1: 614400 Kb
00:00000:00000:2006/02/23 13:25:25.25 server  Size of the 16K memory pool: 307200 Kb
00:00000:00000:2006/02/23 13:25:25.32 server  Size of the 2K memory pool: 307200 Kb
00:00000:00000:2006/02/23 13:25:25.34 kernel  Initializing virtual device 0, 'D:\data\master.dat' with dsync 'on'.
00:00000:00000:2006/02/23 13:25:25.34 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/02/23 13:25:25.34 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/02/23 13:25:25.34 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/02/23 13:25:25.35 kernel  engine 0, os pid 388  online
00:00000:00000:2006/02/23 13:25:25.37 server  No active traceflags
00:00000:00001:2006/02/23 13:25:25.48 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9795 ESD 2/P/NT (IX86)/OS 4.0/rel125/1687/32-bit/OPT/Sat Sep 22 22:37:20 2001'.
00:00000:00001:2006/02/23 13:25:25.48 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/PC Intel/BUILD125-005/OPT/Sat May 19 14:48:00 2001'
00:00000:00001:2006/02/23 13:25:25.48 server  Opening Master Database ...
00:00000:00001:2006/02/23 13:25:25.71 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/02/23 13:25:25.76 server  Loaded default Unilib conversion handle.
00:00000:00001:2006/02/23 13:25:25.84 server  Recovering database 'master'.
00:00000:00001:2006/02/23 13:25:25.98 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2006/02/23 13:25:31.23 server  Checking external objects.
00:00000:00001:2006/02/23 13:25:31.32 server  Database 'master' is now online.
00:00000:00001:2006/02/23 13:25:31.32 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 13:25:31.39 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2006/02/23 13:25:31.42 server  server is unnamed
00:00000:00001:2006/02/23 13:25:31.42 server  Activating disk 'bra60'.
00:00000:00001:2006/02/23 13:25:31.42 kernel  Initializing virtual device 2, 'D:\data\bra60.dat' with dsync 'off'.
00:00000:00001:2006/02/23 13:25:31.45 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2006/02/23 13:25:31.45 server  Activating disk 'bra60_dev1'.
00:00000:00001:2006/02/23 13:25:31.45 kernel  Initializing virtual device 4, 'E:\data\bra60_dev1.dat' with dsync 'off'.
00:00000:00001:2006/02/23 13:25:31.48 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2006/02/23 13:25:31.48 server  Activating disk 'bra60_log'.
00:00000:00001:2006/02/23 13:25:31.48 kernel  Initializing virtual device 3, 'D:\data\bra60_log.dat' with dsync 'off'.
00:00000:00001:2006/02/23 13:25:31.51 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2006/02/23 13:25:31.51 server  Activating disk 'sysprocsdev'.
00:00000:00001:2006/02/23 13:25:31.51 kernel  Initializing virtual device 1, 'D:\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2006/02/23 13:25:31.53 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2006/02/23 13:25:31.70 server  Recovering database 'sybsystemdb'.
00:00000:00001:2006/02/23 13:25:31.71 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2006/02/23 13:25:38.00 server  Boot Count: 1132
00:00000:00001:2006/02/23 13:25:38.07 server  Checking external objects.
00:00000:00001:2006/02/23 13:25:38.09 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 13:25:38.20 server  Database 'sybsystemdb' is now online.
00:00000:00001:2006/02/23 13:25:38.45 server  Recovering database 'model'.
00:00000:00001:2006/02/23 13:25:39.98 server  Checking external objects.
00:00000:00001:2006/02/23 13:25:40.00 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 13:25:40.09 server  Database 'model' is now online.
00:00000:00001:2006/02/23 13:25:40.09 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2006/02/23 13:25:40.09 server  0 dump conditions detected at boot time
00:00000:00001:2006/02/23 13:25:40.09 server  Resident Node id: ac35bb3ce026
00:00000:00001:2006/02/23 13:25:40.09 server  Transaction coordinator initialized.
00:00000:00001:2006/02/23 13:25:40.09 server  Clearing temp db
00:00000:00001:2006/02/23 13:25:57.85 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 13:25:57.92 server  Database 'tempdb' is now online.
00:00000:00001:2006/02/23 13:25:58.09 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/02/23 13:26:06.09 server  Checking external objects.
00:00000:00001:2006/02/23 13:26:06.12 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 13:26:06.26 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2006/02/23 13:26:06.26 kernel  network name 192.168.119.1, type ether, port 5000, filter NONE
00:00000:00001:2006/02/23 13:26:06.85 server  Recovering database 'bra60'.
00:00000:00001:2006/02/23 13:26:07.89 server  Redo pass of recovery has processed 23 committed and 0 aborted transactions.
00:00000:00001:2006/02/23 13:26:27.54 server  Checking external objects.
00:00000:00001:2006/02/23 13:26:27.54 server  The transaction log in the database 'bra60' will use I/O size of 2 Kb.
00:00000:00001:2006/02/23 13:26:27.64 server  Database 'bra60' is now online.
00:00000:00001:2006/02/23 13:26:27.68 server  Recovery complete.
00:00000:00001:2006/02/23 13:26:27.68 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2006/02/23 13:26:27.68 server  SQL Server's default sort order is:
00:00000:00001:2006/02/23 13:26:27.68 server          'altnoacc_cp850' (ID = 39)
00:00000:00001:2006/02/23 13:26:27.68 server  on top of default character set:
00:00000:00001:2006/02/23 13:26:27.68 server          'cp850' (ID = 2).
00:00000:00001:2006/02/23 13:26:27.68 server  Master device size: 800 megabytes, or 409600 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00022:2006/02/23 13:26:27.79 server  Error: 7214, Severity: 11, State: 1
00:00000:00022:2006/02/23 13:26:27.79 server  No site name received in server login packet.  Server login rejected.
00:00000:00021:2006/02/23 13:26:27.79 server  Error: 7221, Severity: 14, State: 1
00:00000:00021:2006/02/23 13:26:27.79 server  Login to site 'dbbra_yz_XP' failed.
00:00000:00049:2006/02/23 13:32:54.64 kernel  Cannot send, host process disconnected:  12003 spid: 49
00:00000:00023:2006/02/23 22:20:51.42 kernel  Cannot send, host process disconnected:  8675 spid: 23
00:00000:00022:2006/02/23 22:26:51.21 kernel  Cannot send, host process disconnected:  12003 spid: 22
00:00000:00051:2006/02/23 22:43:50.96 kernel  Cannot send, host process disconnected:  12003 spid: 51
00:00000:00035:2006/02/23 22:45:52.84 kernel  Cannot send, host process disconnected:  13540 spid: 35
00:00000:00045:2006/02/23 22:53:13.79 kernel  Cannot send, host process disconnected:  8931 spid: 45
00:00000:00026:2006/02/23 23:37:38.84 kernel  Cannot send, host process disconnected:  13540 spid: 26
00:00000:00030:2006/02/23 23:37:58.65 kernel  Cannot send, host process disconnected:  8675 spid: 30

wyckwemail

不是我重启动服务器，是分店电脑人员！可以看出其中早上06:28启动服务器，而06:47:57就出现异常，07:34又重启动了服务器，非正常的启动数据库，13:25又开始服务器的启动，而这前却没有正常关数据库！
但是10:30以后的数据到下午1:30的数据却没有了！我们设置了truncate log on check point! 不可能有大量日志的，也不可能回滚到10:30时的数据吧？靠近3个小时，而在这段时间里，门店正常作销售的，有打印发票为证！
谢谢大家帮忙分析一下可能情况！

小无赖

这似乎跟数据库没有关系,看看会不会是有人更改了服务器的时间,把没有做日处理的销售数据汇总到一起匝一下.看看有没有断网数据.

wyckwemail

在10:30到13:30没有断网数据，13:30后做了部分断网销售！不可能有人改时间，那样我们会看到时间不一样，而且，应用程序会判断时间不同而连不到数据库的!