-
Member
Database Problem
Hello everyone, I have the problem that my database is going offline automatical.. sometimes it runs 7h, sometimes 22h and so on ...
The ERRORLOG shows this here...
2008-01-18 18:27:09.74 server Copyright (C) 1988-2000 Microsoft Corporation.
2008-01-18 18:27:09.74 server All rights reserved.
2008-01-18 18:27:09.74 server Server Process ID is 16100.
2008-01-18 18:27:09.74 server Logging SQL Server messages in file 'C:\Programme\Microsoft SQL Server\MSSQL$TROJA\log\ERRORLOG'.
2008-01-18 18:27:09.74 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2008-01-18 18:27:10.22 server SQL Server configured for thread mode processing.
2008-01-18 18:27:10.22 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2008-01-18 18:27:10.24 server Attempting to initialize Distributed Transaction Coordinator.
2008-01-18 18:27:11.74 spid3 Starting up database 'master'.
2008-01-18 18:27:11.85 spid3 0 transactions rolled back in database 'master' (1).
2008-01-18 18:27:11.85 spid3 Recovery is checkpointing database 'master' (1)
2008-01-18 18:27:11.88 server Using 'SSNETLIB.DLL' version '8.0.311'.
2008-01-18 18:27:11.88 spid5 Starting up database 'model'.
2008-01-18 18:27:11.88 spid3 Server name is 'RDS99332\TROJA'.
2008-01-18 18:27:11.89 spid8 Starting up database 'msdb'.
2008-01-18 18:27:11.89 spid9 Starting up database 'pubs'.
2008-01-18 18:27:11.89 spid10 Starting up database 'Northwind'.
2008-01-18 18:27:11.89 spid11 Starting up database 'kal_auth'.
2008-01-18 18:27:12.22 server SQL server listening on 62.141.48.213: 1667.
2008-01-18 18:27:12.24 server SQL server listening on 62.141.49.213: 1667.
2008-01-18 18:27:12.24 server SQL server listening on 127.0.0.1: 1667.
2008-01-18 18:27:12.30 server SQL server listening on TCP, Shared Memory, Named Pipes.
2008-01-18 18:27:12.30 server SQL Server is ready for client connections
2008-01-18 18:27:12.32 spid5 Clearing tempdb database.
2008-01-18 18:27:12.41 spid9 Starting up database 'kal_db'.
2008-01-18 18:27:13.38 spid11 35 transactions rolled forward in database 'kal_auth' (7).
2008-01-18 18:27:13.41 spid5 Starting up database 'tempdb'.
2008-01-18 18:27:13.44 spid11 0 transactions rolled back in database 'kal_auth' (7).
2008-01-18 18:27:13.47 spid11 Recovery is checkpointing database 'kal_auth' (7)
2008-01-18 18:27:14.29 spid9 36 transactions rolled forward in database 'kal_db' (8).
2008-01-18 18:27:14.32 spid9 0 transactions rolled back in database 'kal_db' (8).
2008-01-18 18:27:14.32 spid9 Recovery is checkpointing database 'kal_db' (8)
2008-01-18 18:27:14.35 spid3 Recovery complete.
2008-01-19 17:45:32.47 spid51 Server shut down by request.
------------------------------------------------------------------------
Yea I know "Server shut down by request." ... but the fact is I didn't shut downed it.. I realy dont know whats the problem is.
Help me plz =]
Last edited by Extron; 19-01-08 at 10:14 PM.
-