Hallo,
Also mein Problem ist das meine MSSQL Datenbank (Enterprisemanager 2000) ständig automatisch aus geht, diese SQL DB befindet sich auf einen Windows 2000 Server.
Der ERRORLOG zeigt folgendes ...
-----------------------------------------------------------------------
2008-01-20 23:10:06.15 server Copyright (C) 1988-2000 Microsoft Corporation.
2008-01-20 23:10:06.16 server All rights reserved.
2008-01-20 23:10:06.16 server Server Process ID is 8216.
2008-01-20 23:10:06.16 server Logging SQL Server messages in file 'C:\Programme\Microsoft SQL Server\MSSQL$TROJA\log\ERRORLOG'.
2008-01-20 23:10:06.18 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2008-01-20 23:10:06.30 server SQL Server configured for thread mode processing.
2008-01-20 23:10:06.30 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2008-01-20 23:10:06.30 server Attempting to initialize Distributed Transaction Coordinator.
2008-01-20 23:10:07.58 spid3 Starting up database 'master'.
2008-01-20 23:10:07.68 spid3 0 transactions rolled back in database 'master' (1).
2008-01-20 23:10:07.68 spid3 Recovery is checkpointing database 'master' (1)
2008-01-20 23:10:07.71 server Using 'SSNETLIB.DLL' version '8.0.311'.
2008-01-20 23:10:07.89 spid5 Starting up database 'model'.
2008-01-20 23:10:07.91 server SQL server listening on 62.141.48.213: 1667.
2008-01-20 23:10:07.91 server SQL server listening on 62.141.49.213: 1667.
2008-01-20 23:10:07.91 server SQL server listening on 127.0.0.1: 1667.
2008-01-20 23:10:07.91 server SQL server listening on TCP, Shared Memory, Named Pipes.
2008-01-20 23:10:07.91 server SQL Server is ready for client connections
2008-01-20 23:10:07.91 spid3 Server name is 'RDS99332\TROJA'.
2008-01-20 23:10:07.93 spid8 Starting up database 'msdb'.
2008-01-20 23:10:07.93 spid9 Starting up database 'pubs'.
2008-01-20 23:10:07.93 spid10 Starting up database 'Northwind'.
2008-01-20 23:10:07.93 spid11 Starting up database 'kal_auth'.
2008-01-20 23:10:08.14 spid5 Clearing tempdb database.
2008-01-20 23:10:08.19 spid9 Starting up database 'kal_db'.
2008-01-20 23:10:09.13 spid5 Starting up database 'tempdb'.
2008-01-20 23:10:09.14 spid11 27 transactions rolled forward in database 'kal_auth' (7).
2008-01-20 23:10:09.19 spid11 0 transactions rolled back in database 'kal_auth' (7).
2008-01-20 23:10:09.21 spid11 Recovery is checkpointing database 'kal_auth' (7)
2008-01-20 23:10:10.25 spid9 1415 transactions rolled forward in database 'kal_db' (8).
2008-01-20 23:10:10.25 spid9 0 transactions rolled back in database 'kal_db' (8).
2008-01-20 23:10:10.27 spid9 Recovery is checkpointing database 'kal_db' (8)
2008-01-20 23:10:10.30 spid3 Recovery complete.
2008-01-21 10:51:15.68 spid73 Server shut down by request.
-----------------------------------------------------------------------
Nun ja, dort steht was von "Server shut down by request", nur ich habe die Datenbank gar nicht selber ausgeschaltet.
Ich bitte um Hilfe.
MFG Benni
Also mein Problem ist das meine MSSQL Datenbank (Enterprisemanager 2000) ständig automatisch aus geht, diese SQL DB befindet sich auf einen Windows 2000 Server.
Der ERRORLOG zeigt folgendes ...
-----------------------------------------------------------------------
2008-01-20 23:10:06.15 server Copyright (C) 1988-2000 Microsoft Corporation.
2008-01-20 23:10:06.16 server All rights reserved.
2008-01-20 23:10:06.16 server Server Process ID is 8216.
2008-01-20 23:10:06.16 server Logging SQL Server messages in file 'C:\Programme\Microsoft SQL Server\MSSQL$TROJA\log\ERRORLOG'.
2008-01-20 23:10:06.18 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2008-01-20 23:10:06.30 server SQL Server configured for thread mode processing.
2008-01-20 23:10:06.30 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2008-01-20 23:10:06.30 server Attempting to initialize Distributed Transaction Coordinator.
2008-01-20 23:10:07.58 spid3 Starting up database 'master'.
2008-01-20 23:10:07.68 spid3 0 transactions rolled back in database 'master' (1).
2008-01-20 23:10:07.68 spid3 Recovery is checkpointing database 'master' (1)
2008-01-20 23:10:07.71 server Using 'SSNETLIB.DLL' version '8.0.311'.
2008-01-20 23:10:07.89 spid5 Starting up database 'model'.
2008-01-20 23:10:07.91 server SQL server listening on 62.141.48.213: 1667.
2008-01-20 23:10:07.91 server SQL server listening on 62.141.49.213: 1667.
2008-01-20 23:10:07.91 server SQL server listening on 127.0.0.1: 1667.
2008-01-20 23:10:07.91 server SQL server listening on TCP, Shared Memory, Named Pipes.
2008-01-20 23:10:07.91 server SQL Server is ready for client connections
2008-01-20 23:10:07.91 spid3 Server name is 'RDS99332\TROJA'.
2008-01-20 23:10:07.93 spid8 Starting up database 'msdb'.
2008-01-20 23:10:07.93 spid9 Starting up database 'pubs'.
2008-01-20 23:10:07.93 spid10 Starting up database 'Northwind'.
2008-01-20 23:10:07.93 spid11 Starting up database 'kal_auth'.
2008-01-20 23:10:08.14 spid5 Clearing tempdb database.
2008-01-20 23:10:08.19 spid9 Starting up database 'kal_db'.
2008-01-20 23:10:09.13 spid5 Starting up database 'tempdb'.
2008-01-20 23:10:09.14 spid11 27 transactions rolled forward in database 'kal_auth' (7).
2008-01-20 23:10:09.19 spid11 0 transactions rolled back in database 'kal_auth' (7).
2008-01-20 23:10:09.21 spid11 Recovery is checkpointing database 'kal_auth' (7)
2008-01-20 23:10:10.25 spid9 1415 transactions rolled forward in database 'kal_db' (8).
2008-01-20 23:10:10.25 spid9 0 transactions rolled back in database 'kal_db' (8).
2008-01-20 23:10:10.27 spid9 Recovery is checkpointing database 'kal_db' (8)
2008-01-20 23:10:10.30 spid3 Recovery complete.
2008-01-21 10:51:15.68 spid73 Server shut down by request.
-----------------------------------------------------------------------
Nun ja, dort steht was von "Server shut down by request", nur ich habe die Datenbank gar nicht selber ausgeschaltet.
Ich bitte um Hilfe.
MFG Benni
Comment