Database Problem

Results 1 to 1 of 1
  1. #1
    Member Extron is offline
    MemberRank
    Nov 2007 Join Date
    39Posts

    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.




Advertisement