win2K+sybase11.9.2,不能备份！！

zy8215356

各位大侠：
　　　　我的sybase作备份，好长时间都没有任何反应，查看进程已为死锁，日志如下，请各位看看怎么回事，小弟先谢了！！00:00000:00001:2004/11/14 18:22:56.59 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/14 18:22:56.60 server  Database 'tempdb' is now online.
00:00000:00001:2004/11/14 18:22:56.60 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/14 18:22:56.64 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2004/11/14 18:22:57.39 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/11/14 18:22:57.39 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2004/11/14 18:22:57.39 server  Recovery complete.
00:00000:00001:2004/11/14 18:22:57.39 server  SQL Server's default sort order is:
00:00000:00001:2004/11/14 18:22:57.39 server          'bin_cp850' (ID = 50)
00:00000:00001:2004/11/14 18:22:57.39 server  on top of default character set:
00:00000:00001:2004/11/14 18:22:57.39 server          'cp850' (ID = 2).
00:00000:00001:2004/11/14 18:22:57.39 server  Loaded default Unilib conversion handle.
00:00000:00000:2004/11/14 18:30:13.73 kernel  kisignal: SQL Server terminated by system shutdown.
00:00000:00000:2004/11/14 18:30:13.73 kernel  ueshutdown: exiting
00:00000:00000:2004/11/14 18:30:13.73 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2004/11/15 10:55:03.48 kernel  Using config area from primary master device.
00:00000:00000:2004/11/15 10:55:03.54 kernel  Warning: Using default file 'd:\Sybase\XLCSZX.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/11/15 10:55:03.76 kernel  Kernel memory at 0x20000000, 200704 bytes
00:00000:00000:2004/11/15 10:55:03.76 kernel  Server part of first shared memory region at 0x20031000, 28119220 bytes
00:00000:00000:2004/11/15 10:55:03.76 kernel  Highest valid address is 0x20031000
00:00000:00000:2004/11/15 10:55:03.76 kernel  Using 100000 file descriptors.
00:00000:00000:2004/11/15 10:55:03.82 kernel  Adaptive Server Enterprise/11.9.2/1031/P/NT (IX86)/OS 3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
00:00000:00000:2004/11/15 10:55:03.82 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2004/11/15 10:55:03.82 kernel  Copyright 1987, 1998
00:00000:00000:2004/11/15 10:55:03.82 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2004/11/15 10:55:03.82 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/11/15 10:55:03.82 kernel  
00:00000:00000:2004/11/15 10:55:03.82 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/11/15 10:55:03.82 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2004/11/15 10:55:03.82 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2004/11/15 10:55:03.82 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2004/11/15 10:55:03.82 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2004/11/15 10:55:03.82 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/11/15 10:55:03.82 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/11/15 10:55:03.82 kernel  Using 'd:\Sybase\XLCSZX.cfg' for configuration information.
00:00000:00000:2004/11/15 10:55:03.82 kernel  Logging SQL Server messages in file 'd:\Sybase\install\errorlog'.
00:00000:00000:2004/11/15 10:55:03.87 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/11/15 10:55:03.89 kernel  SQL Server NT process id is 0x224.
00:00000:00000:2004/11/15 10:55:03.90 kernel  SQL Server was started as a Service.
00:00000:00000:2004/11/15 10:55:03.92 kernel  Network and device connection limit is 99992.
00:00000:00000:2004/11/15 10:55:03.95 server  Number of proc buffers allocated: 1945.
00:00000:00000:2004/11/15 10:55:04.00 server  Proc header memory allocated 972 pages for each per engine cache
00:00000:00000:2004/11/15 10:55:04.00 server  Number of blocks left for proc headers: 1991.
00:00000:00000:2004/11/15 10:55:04.00 server  Memory allocated for the default data cache cache: 14660 Kb
00:00000:00000:2004/11/15 10:55:04.00 server  Size of the 2K memory pool: 14660 Kb
00:00000:00000:2004/11/15 10:55:04.01 kernel  Initializing virtual device 0, 'd:\Sybase\DATA\MASTER.DAT'
00:00000:00000:2004/11/15 10:55:04.01 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/11/15 10:55:04.01 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/11/15 10:55:04.01 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:2004/11/15 10:55:04.07 kernel  engine 0, os pid 188  online
00:00000:00000:2004/11/15 10:55:04.09 server  No active traceflags
00:00000:00001:2004/11/15 10:55:04.23 server  Opening Master Database ...
00:00000:00001:2004/11/15 10:55:04.50 server  Loading SQL Server's default sort order and character set
00:00000:00003:2004/11/15 10:55:04.57 kernel  network name xlcszx, type ether, port 5000
00:00000:00001:2004/11/15 10:55:04.62 server  Recovering database 'master'
00:00000:00001:2004/11/15 10:55:04.73 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2004/11/15 10:55:05.07 server  Database 'master' is now online.
00:00000:00001:2004/11/15 10:55:05.10 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/11/15 10:55:05.12 server  0 dump conditions detected at boot time
00:00000:00001:2004/11/15 10:55:05.12 server  server is unnamed
00:00000:00001:2004/11/15 10:55:05.14 server  Activating disk 'sysprocsdev'.
00:00000:00001:2004/11/15 10:55:05.14 kernel  Initializing virtual device 1, 'd:\Sybase\DATA\SYBPROCS.DAT'
00:00000:00001:2004/11/15 10:55:05.14 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2004/11/15 10:55:05.29 server  Recovering database 'model'.
00:00000:00001:2004/11/15 10:55:05.37 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/11/15 10:55:05.39 server  Database 'model' is now online.
00:00000:00001:2004/11/15 10:55:05.39 server  Clearing temp db
00:00000:00001:2004/11/15 10:55:05.59 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/15 10:55:05.65 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/15 10:55:05.67 server  Database 'tempdb' is now online.
00:00000:00001:2004/11/15 10:55:05.67 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/11/15 10:55:05.70 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2004/11/15 10:55:06.75 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/11/15 10:55:06.75 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2004/11/15 10:55:06.78 server  Recovery complete.
00:00000:00001:2004/11/15 10:55:06.78 server  SQL Server's default sort order is:
00:00000:00001:2004/11/15 10:55:06.78 server          'bin_cp850' (ID = 50)
00:00000:00001:2004/11/15 10:55:06.78 server  on top of default character set:
00:00000:00001:2004/11/15 10:55:06.78 server          'cp850' (ID = 2).
00:00000:00001:2004/11/15 10:55:06.78 server  Loaded default Unilib conversion handle.
00:00000:00000:2004/11/15 11:04:25.37 kernel  kisignal: SQL Server terminated by system shutdown.
00:00000:00000:2004/11/15 11:04:25.37 kernel  ueshutdown: exiting
00:00000:00000:2004/11/15 11:04:25.37 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
备份日志如下：Nov 14 18:23:10 2004: Backup Server/11.9.2/1032/P/NT (IX86)/OS 4.0/OPT/Thu Aug 13 22:03:25 1998
Nov 14 18:23:10 2004: Confidential property of Sybase, Inc.
Copyright 1987, 1998
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
Logging Backup Server messages in file 'd:\Sybase\install\backup.log'

Nov 14 18:30:13 2004: Backup Server: 1.52.1.1: Backup Server terminating because of system shutdown
Nov 14 18:30:13 2004: Backup Server: 3.48.1.1: The Backup Server will go down immediately.  Terminating sessions.

1017of

00:00000:00000:2004/11/15 11:04:25.37 kernel  kisignal: SQL Server terminated by system shutdown.
Nov 14 18:30:13 2004: Backup Server: 1.52.1.1: Backup Server terminating because of system shutdown
was the reason you looked for?

zy8215356

在线等待回复，谢了！

RS9000

不能备份,把备份日志贴出来

zy8215356

备份日志如下：Nov 14 18:23:10 2004: Backup Server/11.9.2/1032/P/NT (IX86)/OS 4.0/OPT/Thu Aug 13 22:03:25 1998
Nov 14 18:23:10 2004: Confidential property of Sybase, Inc.
Copyright 1987, 1998
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
Logging Backup Server messages in file 'd:\Sybase\install\backup.log'

Nov 14 18:30:13 2004: Backup Server: 1.52.1.1: Backup Server terminating because of system shutdown
Nov 14 18:30:13 2004: Backup Server: 3.48.1.1: The Backup Server will go down immediately.  Terminating sessions.

zy8215356

无耐，二天了没人关注，天下难道真的没有好人了吗？？

donniejeck

Nov 14 18:30:13 2004: Backup Server: 1.52.1.1: Backup Server terminating because of system shutdown
Nov 14 18:30:13 2004: Backup Server: 3.48.1.1: The Backup Server will go down immediately.  Terminating sessions.

小无赖

老兄,2004年的问题到现在还没解决吗?