Forum Użytkownikow Subiekt GT
InsERT GT => Subiekt GT => Wątek zaczęty przez: felga1987 w Grudzień 15, 2015, 14:49:06
-
Witammam problem z serverem SQL który nie startuje oto logi
2015-12-15 14:39:45.28 Server Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Dodatek Service Pack 3)
2015-12-15 14:39:45.29 Server (c) 2005 Microsoft Corporation.
2015-12-15 14:39:45.29 Server All rights reserved.
2015-12-15 14:39:45.29 Server Server process ID is 4388.
2015-12-15 14:39:45.29 Server Authentication mode is MIXED.
2015-12-15 14:39:45.29 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2015-12-15 14:39:45.29 Server This instance of SQL Server last reported using a process ID of 5832 at 2015-12-15 14:21:31 (local) 2015-12-15 13:21:31 (UTC). This is an informational message only; no user action is required.
2015-12-15 14:39:45.29 Server Registry startup parameters:
2015-12-15 14:39:45.29 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2015-12-15 14:39:45.29 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2015-12-15 14:39:45.29 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2015-12-15 14:39:45.31 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2015-12-15 14:39:45.31 Server Detected 2 CPUs. This is an informational message; no user action is required.
2015-12-15 14:39:45.93 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.
2015-12-15 14:39:45.96 Server Database mirroring has been enabled on this instance of SQL Server.
2015-12-15 14:39:45.97 spid4s Starting up database 'master'.
2015-12-15 14:39:46.06 spid4s Error: 9003, Severity: 20, State: 1.
2015-12-15 14:39:46.06 spid4s The log scan number (443:472:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2015-12-15 14:39:46.06 spid4s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
-
W wolnym tłumaczenie logów - nie zabezpieczyłeś serwera i doprowadziłeś do uszkodzenia systemowej bazy danych master, należy ponownie zainstalować serwer SQL i podłączyć bazę danych podmiotu, być może miałeś szczęście i jej nie uszkodziłeś.