none
Deleted log files - need help to start MS SQL

    Question

  • One drive crashed wiping all log files. I copied back an older version of mastlog.ldf but still not able to start SQL. Message when tryign to start fro Services is error code 3417. The SQL error log reads below.

    2013-04-22 13:03:30.35 Server      Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64)
        Aug 22 2012 19:25:47
        Copyright (c) 1988-2008 Microsoft Corporation
        Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

    2013-04-22 13:03:30.35 Server      (c) 2005 Microsoft Corporation.
    2013-04-22 13:03:30.35 Server      All rights reserved.
    2013-04-22 13:03:30.35 Server      Server process ID is 1948.
    2013-04-22 13:03:30.35 Server      System Manufacturer: 'Supermicro', System Model: 'X7DBN'.
    2013-04-22 13:03:30.35 Server      Authentication mode is MIXED.
    2013-04-22 13:03:30.35 Server      Logging SQL Server messages in file 'L:\MSSQL\Error\ERRORLOG'.
    2013-04-22 13:03:30.35 Server      This instance of SQL Server last reported using a process ID of 3448 at 4/22/2013 1:02:04 PM (local) 4/22/2013 8:02:04 PM (UTC). This is an informational message only; no user action is required.
    2013-04-22 13:03:30.35 Server      Registry startup parameters:
         -d D:\MSSQL\Data\master.mdf
         -e L:\MSSQL\Error\ERRORLOG
         -l L:\MSSQL\Log\mastlog.ldf
    2013-04-22 13:03:30.38 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2013-04-22 13:03:30.38 Server      Detected 8 CPUs. This is an informational message; no user action is required.
    2013-04-22 13:03:30.38 Server      Cannot use Large Page Extensions:  lock memory privilege was not granted.
    2013-04-22 13:03:30.45 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2013-04-22 13:03:30.48 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff Active CPU mask: 0x00000000000000ff. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2013-04-22 13:03:30.51 spid6s      Starting up database 'master'.
    2013-04-22 13:03:30.60 spid6s      Error: 5173, Severity: 16, State: 1.
    2013-04-22 13:03:30.60 spid6s      One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.  If this is an existing database, the file may be corrupted and should be restored from a backup.
    2013-04-22 13:03:30.60 spid6s      Error: 5173, Severity: 16, State: 1.
    2013-04-22 13:03:30.60 spid6s      One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.  If this is an existing database, the file may be corrupted and should be restored from a backup.

    Monday, April 22, 2013 8:06 PM

Answers

All replies