Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Sofia, BG
    Posts
    2

    Question Unanswered: Error when SQL 2000 start

    When starting my SQL Server 2000 generate error and stop. This is the log:
    Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

    2004-01-20 11:05:36.59 server Copyright (C) 1988-2000 Microsoft Corporation.
    2004-01-20 11:05:36.59 server All rights reserved.
    2004-01-20 11:05:36.59 server Server Process ID is 115.
    2004-01-20 11:05:36.59 server Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
    2004-01-20 11:05:36.63 server SQL Server is starting at priority class 'normal'(1 CPU detected).
    2004-01-20 11:05:36.66 server SQL Server configured for thread mode processing.
    2004-01-20 11:05:36.66 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
    2004-01-20 11:05:36.67 server Attempting to initialize Distributed Transaction Coordinator.
    2004-01-20 11:05:38.69 spid3 Starting up database 'master'.
    2004-01-20 11:05:38.85 spid3 Server name is 'DB_SERVER'.
    2004-01-20 11:05:38.85 server Using 'SSNETLIB.DLL' version '8.0.194'.
    2004-01-20 11:05:38.87 server SQL server listening on TCP, Shared Memory, Named Pipes.
    2004-01-20 11:05:38.87 server SQL server listening on 192.168.1.29:1433, 172.16.48.10:1433, 127.0.0.1:1433.
    2004-01-20 11:05:38.87 server SQL Server is ready for client connections
    2004-01-20 11:05:38.87 spid5 Starting up database 'model'.
    2004-01-20 11:05:38.87 spid8 Starting up database 'msdb'.
    2004-01-20 11:05:38.87 spid9 Starting up database 'pubs'.
    2004-01-20 11:05:38.87 spid10 Starting up database 'Northwind'.
    2004-01-20 11:05:38.87 spid11 Starting up database 'SIM'.
    2004-01-20 11:05:39.21 spid5 Error: 9003, Severity: 20, State: 1
    2004-01-20 11:05:39.21 spid5 The LSN (5:377:1) passed to log scan in database 'model' is invalid..
    2004-01-20 11:05:39.31 spid8 Bypassing recovery for database 'msdb' because it is marked SUSPECT.
    2004-01-20 11:05:39.39 spid11 Starting up database 'GMS'.
    2004-01-20 11:05:39.39 spid8 Starting up database 'euro'.
    2004-01-20 11:05:40.14 spid10 Starting up database 'TigrisDB'.

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    have you moved your system's devices around recently?

  3. #3
    Join Date
    Jan 2004
    Location
    Sofia, BG
    Posts
    2

    Red face

    Originally posted by ms_sql_dba
    have you moved your system's devices around recently?
    No, but 2 weeks before, I receive a message (Administrator alert) from PC with installed on SQL 2000.

    "Drive Z: is nearly full. 1216688128 bytes are available.
    Please warn users and delete unneeded files."

    On "drive Z:" there is 9GB free space ...

    Thanks for reading.
    Best Regards

  4. #4
    Join Date
    Jan 2004
    Posts
    10

    Re: Error when SQL 2000 start

    looks like your system databases is having some problem.
    try restarting sql server in single user mode and do a dbcc checkdb on model and msdb.

    If this do not work, you might have to rebuild them

    amit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •