Top-Themen

Aktuelle Themen (A bis Z)

Administrator.de FeedbackApache ServerAppleAssemblerAudioAusbildungAuslandBackupBasicBatch & ShellBenchmarksBibliotheken & ToolkitsBlogsCloud-DiensteClusterCMSCPU, RAM, MainboardsCSSC und C++DatenbankenDatenschutzDebianDigitiales FernsehenDNSDrucker und ScannerDSL, VDSLE-BooksE-BusinessE-MailEntwicklungErkennung und -AbwehrExchange ServerFestplatten, SSD, RaidFirewallFlatratesGoogle AndroidGrafikGrafikkarten & MonitoreGroupwareHardwareHosting & HousingHTMLHumor (lol)Hyper-VIconsIDE & EditorenInformationsdiensteInstallationInstant MessagingInternetInternet DomäneniOSISDN & AnaloganschlüsseiTunesJavaJavaScriptKiXtartKVMLAN, WAN, WirelessLinuxLinux DesktopLinux NetzwerkLinux ToolsLinux UserverwaltungLizenzierungMac OS XMicrosoftMicrosoft OfficeMikroTik RouterOSMonitoringMultimediaMultimedia & ZubehörNetzwerkeNetzwerkgrundlagenNetzwerkmanagementNetzwerkprotokolleNotebook & ZubehörNovell NetwareOff TopicOpenOffice, LibreOfficeOutlook & MailPapierkorbPascal und DelphiPeripheriegerätePerlPHPPythonRechtliche FragenRedHat, CentOS, FedoraRouter & RoutingSambaSAN, NAS, DASSchriftartenSchulung & TrainingSEOServerServer-HardwareSicherheitSicherheits-ToolsSicherheitsgrundlagenSolarisSonstige SystemeSoziale NetzwerkeSpeicherkartenStudentenjobs & PraktikumSuche ProjektpartnerSuseSwitche und HubsTipps & TricksTK-Netze & GeräteUbuntuUMTS, EDGE & GPRSUtilitiesVB for ApplicationsVerschlüsselung & ZertifikateVideo & StreamingViren und TrojanerVirtualisierungVisual StudioVmwareVoice over IPWebbrowserWebentwicklungWeiterbildungWindows 7Windows 8Windows 10Windows InstallationWindows MobileWindows NetzwerkWindows ServerWindows SystemdateienWindows ToolsWindows UpdateWindows UserverwaltungWindows VistaWindows XPXenserverXMLZusammenarbeit

MSSQL Server Agent startet nicht mehr

Mitglied: dimo11

dimo11 (Level 1) - Jetzt verbinden

02.08.2011, aktualisiert 08:16 Uhr, 12091 Aufrufe, 4 Kommentare

Hallo,
ich bräuchte dringend eure Hilfe ich weis nicht mehr was ich machen kann damit der Agent wieder läuft.

Nach einen Neustart des Servers startet der Server Agent auf einmal nicht mehr.

System Windows Server 2008, MSSQL 2008 R2.

Fehler beim einlochen mit Management Studio : "Die msdb-Datenbank kann nicht geöffnet werden. Sie wurde bei der Wiederherstellung als SUSPECT gekennzeichnet. Weitere Informationen finden Sie im SQL Server-Fehlerprotokoll. (Microsoft SQL Server, Fehler: 926)"

Leider lässt sich der Server-Agent auch nicht mehr manuell über die Dienste Starten.

Im SQLAGENT.OUT steht folgendes :

2011-08-02 07:58:33 - ! [298] SQLServer Error: 18456, Fehler bei der Anmeldung für den Benutzer 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000]
2011-08-02 07:58:33 - ! [298] SQLServer Error: 4060, Die von der Anmeldung angeforderte msdb-Datenbank kann nicht geöffnet werden. Fehler bei der Anmeldung. [SQLSTATE 42000]
2011-08-02 07:58:33 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2011-08-02 07:58:33 - ! [298] SQLServer Error: 18456, Fehler bei der Anmeldung für den Benutzer 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000]
2011-08-02 07:58:33 - ! [298] SQLServer Error: 4060, Die von der Anmeldung angeforderte msdb-Datenbank kann nicht geöffnet werden. Fehler bei der Anmeldung. [SQLSTATE 42000]
2011-08-02 07:58:33 - ! [382] Logon to server '(local)' failed (DisableAgentXPs)
2011-08-02 07:58:33 - ? [098] SQLServerAgent terminated (normally)


Im ERRORLOG :

2011-08-02 07:58:13.36 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

2011-08-02 07:58:13.36 Server (c) Microsoft Corporation.
2011-08-02 07:58:13.36 Server All rights reserved.
2011-08-02 07:58:13.36 Server Server process ID is 4104.
2011-08-02 07:58:13.36 Server System Manufacturer: 'FUJITSU', System Model: 'D2901-H1'.
2011-08-02 07:58:13.36 Server Authentication mode is MIXED.
2011-08-02 07:58:13.36 Server Logging SQL Server messages in file 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2011-08-02 07:58:13.36 Server This instance of SQL Server last reported using a process ID of 5588 at 02.08.2011 07:58:08 (local) 02.08.2011 05:58:08 (UTC). This is an informational message only; no user action is required.
2011-08-02 07:58:13.36 Server Registry startup parameters:
-d D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2011-08-02 07:58:13.36 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-08-02 07:58:13.36 Server Detected 4 CPUs. This is an informational message; no user action is required.
2011-08-02 07:58:13.41 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.
2011-08-02 07:58:13.45 Server Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-08-02 07:58:13.50 spid7s Starting up database 'master'.
2011-08-02 07:58:13.57 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2011-08-02 07:58:13.58 spid7s CHECKDB for database 'master' finished without errors on 2011-08-01 10:30:50.713 (local time). This is an informational message only; no user action is required.
2011-08-02 07:58:13.59 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2011-08-02 07:58:13.62 spid7s SQL Trace ID 1 was started by login "sa".
2011-08-02 07:58:13.62 spid7s Starting up database 'mssqlsystemresource'.
2011-08-02 07:58:13.63 spid7s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2011-08-02 07:58:13.67 spid7s Server name is '...'. This is an informational message only. No user action is required.
2011-08-02 07:58:13.67 spid11s Starting up database 'model'.
2011-08-02 07:58:13.69 spid11s Clearing tempdb database.
2011-08-02 07:58:13.80 spid11s Starting up database 'tempdb'.
2011-08-02 07:58:13.83 spid14s The Service Broker protocol transport is disabled or not configured.
2011-08-02 07:58:13.83 spid14s The Database Mirroring protocol transport is disabled or not configured.
2011-08-02 07:58:13.84 spid13s A new instance of the full-text filter daemon host process has been successfully started.
2011-08-02 07:58:13.84 spid14s Service Broker manager has started.
2011-08-02 07:58:13.87 spid21s Starting up database 'msdb'.
2011-08-02 07:58:13.88 spid13s Starting up database 'ReportServer'.
2011-08-02 07:58:13.88 spid23s Starting up database 'ReportServerTempDB'.
2011-08-02 07:58:13.91 spid21s Fehler: 9003, Schweregrad: 20, Status: 1.
2011-08-02 07:58:13.91 spid21s The log scan number (207:584:1) passed to log scan in database 'msdb' 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.
2011-08-02 07:58:13.91 spid21s Fehler: 3414, Schweregrad: 21, Status: 1.
2011-08-02 07:58:13.91 spid21s An error occurred during recovery, preventing the database 'msdb' (database ID 4) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
2011-08-02 07:58:13.97 spid7s Fehler: 8355, Schweregrad: 16, Status: 1.
2011-08-02 07:58:13.97 spid7s Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker.
2011-08-02 07:58:13.98 spid7s Recovery is complete. This is an informational message only. No user action is required.
2011-08-02 07:58:14.10 Server A self-generated certificate was successfully loaded for encryption.
2011-08-02 07:58:14.10 Server Server is listening on [ 'any' <ipv6> 1433].
2011-08-02 07:58:14.10 Server Server is listening on [ 'any' <ipv4> 1433].
2011-08-02 07:58:14.10 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2011-08-02 07:58:14.10 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2011-08-02 07:58:14.10 Server Server is listening on [ ::1 <ipv6> 1434].
2011-08-02 07:58:14.10 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2011-08-02 07:58:14.10 Server Dedicated admin connection support was established for listening locally on port 1434.
2011-08-02 07:58:14.11 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2011-08-02 07:58:14.11 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2011-08-02 07:58:33.40 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 07:58:33.40 Login failed for user 'NT AUTHORITY\SYSTEM'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 07:58:33.41 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 07:58:33.41 Login failed for user 'NT AUTHORITY\SYSTEM'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:03:49.42 spid56 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2011-08-02 08:03:49.43 spid56 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2011-08-02 08:06:16.13 spid56 Starting up database 'test'.
2011-08-02 08:06:16.19 spid56 Setting database option COMPATIBILITY_LEVEL to 100 for database test.
2011-08-02 08:06:16.22 spid56 Setting database option ANSI_NULL_DEFAULT to OFF for database test.
2011-08-02 08:06:16.23 spid56 Setting database option ANSI_NULLS to OFF for database test.
2011-08-02 08:06:16.24 spid56 Setting database option ANSI_PADDING to OFF for database test.
2011-08-02 08:06:16.26 spid56 Setting database option ANSI_WARNINGS to OFF for database test.
2011-08-02 08:06:16.27 spid56 Setting database option ARITHABORT to OFF for database test.
2011-08-02 08:06:16.28 spid56 Setting database option AUTO_CLOSE to OFF for database test.
2011-08-02 08:06:16.30 spid56 Setting database option AUTO_CREATE_STATISTICS to ON for database test.
2011-08-02 08:06:16.31 spid56 Setting database option AUTO_SHRINK to OFF for database test.
2011-08-02 08:06:16.32 spid56 Setting database option AUTO_UPDATE_STATISTICS to ON for database test.
2011-08-02 08:06:16.34 spid56 Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database test.
2011-08-02 08:06:16.36 spid56 Setting database option CURSOR_DEFAULT to GLOBAL for database test.
2011-08-02 08:06:16.37 spid56 Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database test.
2011-08-02 08:06:16.38 spid56 Setting database option NUMERIC_ROUNDABORT to OFF for database test.
2011-08-02 08:06:16.39 spid56 Setting database option QUOTED_IDENTIFIER to OFF for database test.
2011-08-02 08:06:16.41 spid56 Setting database option RECURSIVE_TRIGGERS to OFF for database test.
2011-08-02 08:06:16.42 spid56 Setting database option DISABLE_BROKER to ON for database test.
2011-08-02 08:06:16.43 spid56 Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database test.
2011-08-02 08:06:16.44 spid56 Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database test.
2011-08-02 08:06:16.45 spid56 Setting database option PARAMETERIZATION to SIMPLE for database test.
2011-08-02 08:06:16.47 spid56 Setting database option READ_WRITE to ON for database test.
2011-08-02 08:06:16.47 spid56 Setting database option RECOVERY to FULL for database test.
2011-08-02 08:06:16.48 spid56 Setting database option MULTI_USER to ON for database test.
2011-08-02 08:06:16.48 spid56 Setting database option PAGE_VERIFY to CHECKSUM for database test.
Mitglied: ackerdiesel
02.08.2011 um 08:47 Uhr
Hallo,

scheinbar hat der SQL-Agent keine Berechtigung. Ändere mal zum Test den Benutzer von "NT AUTHORITY\SYSTEM" auf einen Administrator und versuch dann mal den Agent zu starten.

Gruß
ackerdiesel
Bitte warten ..
Mitglied: dimo11
02.08.2011 um 08:56 Uhr
Hallo Danke für die Hilfe,

geht leider auch ned :

LOG :


2011-08-02 07:58:13.36 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

2011-08-02 07:58:13.36 Server (c) Microsoft Corporation.
2011-08-02 07:58:13.36 Server All rights reserved.
2011-08-02 07:58:13.36 Server Server process ID is 4104.
2011-08-02 07:58:13.36 Server System Manufacturer: 'FUJITSU', System Model: 'D2901-H1'.
2011-08-02 07:58:13.36 Server Authentication mode is MIXED.
2011-08-02 07:58:13.36 Server Logging SQL Server messages in file 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2011-08-02 07:58:13.36 Server This instance of SQL Server last reported using a process ID of 5588 at 02.08.2011 07:58:08 (local) 02.08.2011 05:58:08 (UTC). This is an informational message only; no user action is required.
2011-08-02 07:58:13.36 Server Registry startup parameters:
-d D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2011-08-02 07:58:13.36 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-08-02 07:58:13.36 Server Detected 4 CPUs. This is an informational message; no user action is required.
2011-08-02 07:58:13.41 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.
2011-08-02 07:58:13.45 Server Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2011-08-02 07:58:13.50 spid7s Starting up database 'master'.
2011-08-02 07:58:13.57 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2011-08-02 07:58:13.58 spid7s CHECKDB for database 'master' finished without errors on 2011-08-01 10:30:50.713 (local time). This is an informational message only; no user action is required.
2011-08-02 07:58:13.59 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2011-08-02 07:58:13.62 spid7s SQL Trace ID 1 was started by login "sa".
2011-08-02 07:58:13.62 spid7s Starting up database 'mssqlsystemresource'.
2011-08-02 07:58:13.63 spid7s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
2011-08-02 07:58:13.67 spid7s Server name is 'S15445442'. This is an informational message only. No user action is required.
2011-08-02 07:58:13.67 spid11s Starting up database 'model'.
2011-08-02 07:58:13.69 spid11s Clearing tempdb database.
2011-08-02 07:58:13.80 spid11s Starting up database 'tempdb'.
2011-08-02 07:58:13.83 spid14s The Service Broker protocol transport is disabled or not configured.
2011-08-02 07:58:13.83 spid14s The Database Mirroring protocol transport is disabled or not configured.
2011-08-02 07:58:13.84 spid13s A new instance of the full-text filter daemon host process has been successfully started.
2011-08-02 07:58:13.84 spid14s Service Broker manager has started.
2011-08-02 07:58:13.87 spid21s Starting up database 'msdb'.
2011-08-02 07:58:13.88 spid13s Starting up database 'ReportServer'.
2011-08-02 07:58:13.88 spid23s Starting up database 'ReportServerTempDB'.
2011-08-02 07:58:13.91 spid21s Fehler: 9003, Schweregrad: 20, Status: 1.
2011-08-02 07:58:13.91 spid21s The log scan number (207:584:1) passed to log scan in database 'msdb' 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.
2011-08-02 07:58:13.91 spid21s Fehler: 3414, Schweregrad: 21, Status: 1.
2011-08-02 07:58:13.91 spid21s An error occurred during recovery, preventing the database 'msdb' (database ID 4) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
2011-08-02 07:58:13.97 spid7s Fehler: 8355, Schweregrad: 16, Status: 1.
2011-08-02 07:58:13.97 spid7s Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker.
2011-08-02 07:58:13.98 spid7s Recovery is complete. This is an informational message only. No user action is required.
2011-08-02 07:58:14.10 Server A self-generated certificate was successfully loaded for encryption.
2011-08-02 07:58:14.10 Server Server is listening on [ 'any' <ipv6> 1433].
2011-08-02 07:58:14.10 Server Server is listening on [ 'any' <ipv4> 1433].
2011-08-02 07:58:14.10 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2011-08-02 07:58:14.10 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2011-08-02 07:58:14.10 Server Server is listening on [ ::1 <ipv6> 1434].
2011-08-02 07:58:14.10 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2011-08-02 07:58:14.10 Server Dedicated admin connection support was established for listening locally on port 1434.
2011-08-02 07:58:14.11 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2011-08-02 07:58:14.11 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2011-08-02 07:58:33.40 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 07:58:33.40 Login failed for user 'NT AUTHORITY\SYSTEM'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 07:58:33.41 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 07:58:33.41 Login failed for user 'NT AUTHORITY\SYSTEM'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:03:49.42 spid56 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2011-08-02 08:03:49.43 spid56 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2011-08-02 08:06:16.13 spid56 Starting up database 'test'.
2011-08-02 08:06:16.19 spid56 Setting database option COMPATIBILITY_LEVEL to 100 for database test.
2011-08-02 08:06:16.22 spid56 Setting database option ANSI_NULL_DEFAULT to OFF for database test.
2011-08-02 08:06:16.23 spid56 Setting database option ANSI_NULLS to OFF for database test.
2011-08-02 08:06:16.24 spid56 Setting database option ANSI_PADDING to OFF for database test.
2011-08-02 08:06:16.26 spid56 Setting database option ANSI_WARNINGS to OFF for database test.
2011-08-02 08:06:16.27 spid56 Setting database option ARITHABORT to OFF for database test.
2011-08-02 08:06:16.28 spid56 Setting database option AUTO_CLOSE to OFF for database test.
2011-08-02 08:06:16.30 spid56 Setting database option AUTO_CREATE_STATISTICS to ON for database test.
2011-08-02 08:06:16.31 spid56 Setting database option AUTO_SHRINK to OFF for database test.
2011-08-02 08:06:16.32 spid56 Setting database option AUTO_UPDATE_STATISTICS to ON for database test.
2011-08-02 08:06:16.34 spid56 Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database test.
2011-08-02 08:06:16.36 spid56 Setting database option CURSOR_DEFAULT to GLOBAL for database test.
2011-08-02 08:06:16.37 spid56 Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database test.
2011-08-02 08:06:16.38 spid56 Setting database option NUMERIC_ROUNDABORT to OFF for database test.
2011-08-02 08:06:16.39 spid56 Setting database option QUOTED_IDENTIFIER to OFF for database test.
2011-08-02 08:06:16.41 spid56 Setting database option RECURSIVE_TRIGGERS to OFF for database test.
2011-08-02 08:06:16.42 spid56 Setting database option DISABLE_BROKER to ON for database test.
2011-08-02 08:06:16.43 spid56 Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database test.
2011-08-02 08:06:16.44 spid56 Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database test.
2011-08-02 08:06:16.45 spid56 Setting database option PARAMETERIZATION to SIMPLE for database test.
2011-08-02 08:06:16.47 spid56 Setting database option READ_WRITE to ON for database test.
2011-08-02 08:06:16.47 spid56 Setting database option RECOVERY to FULL for database test.
2011-08-02 08:06:16.48 spid56 Setting database option MULTI_USER to ON for database test.
2011-08-02 08:06:16.48 spid56 Setting database option PAGE_VERIFY to CHECKSUM for database test.
2011-08-02 08:50:55.69 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:50:55.69 Login failed for user 'NT AUTHORITY\LOCAL SERVICE'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:50:55.71 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:50:55.71 Login failed for user 'NT AUTHORITY\LOCAL SERVICE'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:51:04.58 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:51:04.58 Login failed for user 'NT AUTHORITY\LOCAL SERVICE'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:51:04.60 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:51:04.60 Login failed for user 'NT AUTHORITY\LOCAL SERVICE'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:53:02.86 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:53:02.86 Login failed for user 'S15445442\Administrator'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:53:02.88 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:53:02.88 Login failed for user 'S15445442\Administrator'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:53:13.89 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:53:13.89 Login failed for user 'S15445442\Administrator'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:53:13.90 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:53:13.90 Login failed for user 'S15445442\Administrator'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:53:39.36 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:53:39.36 Login failed for user 'S15445442\Administrator'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:53:39.37 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:53:39.37 Login failed for user 'S15445442\Administrator'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:54:33.94 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:54:33.94 Login failed for user 'S15445442\Administrator'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
2011-08-02 08:54:33.96 Fehler: 18456, Schweregrad: 14, Status: 38.
2011-08-02 08:54:33.96 Login failed for user 'S15445442\Administrator'. Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank. [CLIENT: <local machine>]
Bitte warten ..
Mitglied: 32067
02.08.2011 um 09:41 Uhr
Hallo,

eine der System-Datenbanken, die msdb, hat nen schweres Problem, so dass diese nicht online genommen werden kann. In der DB hat der Agent seine Daten gespeichert, deshalb kommt der nicht hoch.

2011-08-02 07:58:13.91 spid21s The log scan number (207:584:1) passed to log scan in database 'msdb' 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.

Da der SQL Server selber startet, würde ich einfach die msdb aus dem letzten Backup restoren und gut. Das musst du aber über RESTORE DATABASE machen, denn die GUI braucht auch die msdb, da steht drin, welche Backups wann gelaufen sind.
Bitte warten ..
Mitglied: dimo11
02.08.2011 um 10:15 Uhr
Vielen Dank !!!!
Das hat geklappt.
Bitte warten ..
Ähnliche Inhalte
Windows Server

MSSQL Server 2012 Datenbank startet nicht nach Restore

Frage von gechgerWindows Server8 Kommentare

Hallo Forum, wir haben versucht, eine gesicherte Datenbank eines produktiven MSSQL-Servers 2008 mittels Restore im Server Mnagement Studio in ...

Windows Tools

SQL Server-Agent Dienst startet nicht Quelle: SQLAgentSQLExpress Ereignis-ID: 324

gelöst Frage von 117799Windows Tools5 Kommentare

Hallo Leute, ich habe folgendes Problem. Wir haben eine Domäne die Unter Windows Server 2012 R2 läuft. Außerdem haben ...

Windows Server

Upgrade von MSSQL Server 2008 R2 auf MSSQL Server 2012 schlägt fehl

Frage von ArgoadminWindows Server4 Kommentare

Hallo, ich muss einen unserer SQL-Server upgraden. Das Upgrade bricht mit einer Fehlermeldung (siehe auch Foto) ab: Fehler bei ...

Datenbanken

MSSQL quenquery

gelöst Frage von petereDatenbanken6 Kommentare

Hallo, ich stoße leider an die Grenzen meiner MSSQL-Kenntnisse. Ich muss diesen, eigentlich einfachen, UPDATE-Ausdruck via zwei Verbindungsserver-Verbindungen realisieren. ...

Neue Wissensbeiträge
Windows 10

Neue Sicherheitslücke in Windows 10 (Version 1709) durch Google öffentlich geworden

Information von kgborn vor 6 StundenWindows 10

Vor ein paar Tagen haben Googles Sicherheitsforscher vom Projekt Zero eine Sicherheitslücke im Edge-Browser publiziert. Jetzt wurde eine weitere ...

iOS
IOS 11.2.6 verfügbar
Information von sabines vor 12 StundeniOS

Mit dem Update soll der Bug behoben werden, bei dem eine bestimmte Zeichenkette IOS zum Absturz gebracht hat.

Sicherheit
Sicherheitsrisiko: Die Krux mit 7-Zip
Information von kgborn vor 1 TagSicherheit8 Kommentare

Bei vielen Anwendern ist das Tool 7-Zip zum Entpacken von Archivdateien im Einsatz. Die Software ist kostenlos und steht ...

Internet

Datendealing im WWW Tracking Methoden immer brutaler

Information von sabines vor 1 TagInternet

Interessanter Artikel zum Thema Tracking im WWW und die immer "besseren" Methoden des Trackings. Professor Arvind Narayanan (Princeton-Universität) betreibt ...

Heiß diskutierte Inhalte
Router & Routing
LANCOM VPN CLIENT einrichten
Frage von Finchen961988Router & Routing27 Kommentare

Hallo, ich habe ein Problem und hoffe ihr könnt mir helfen, wir haben einen Kunden der hat einen Speedport ...

Windows Server
AD DS findet Domäne nicht, behebbar?
Frage von schapitzWindows Server24 Kommentare

Guten Tag, ich habe bei einem Kunden ein Problem mit den AD DS. Umgebung ist folgende: Windows Server 2016 ...

LAN, WAN, Wireless
VPN Cisco ASA5505 PaloAlto PA-200
gelöst Frage von YannoschLAN, WAN, Wireless22 Kommentare

Hallo zusammen, ich würde gerne ein Site-to-Site VPN zwischen den beiden Standorten aufbauen. PaloAlto PA200 Internetanschluss Deutsche Telekom GK ...

Webbrowser
Welcher Browser ist der Beste?
Frage von justtinWebbrowser15 Kommentare

Hallo Leute Ich habe eine interessante Frage. Mich wurde mal interessieren welcher Browser ist eure meinung nach der beste? ...