Remove From My Forums

SQL Dumps müllen den Server zu

Frage

Anmelden

Einen wunderschönen Abend an @lle,

ich habe seit mehreren Tagen das Problem, dass unser SQL Server und mit Logs voll schreibt, mittlerweile ergibt das ~60 MB PRO MINUTE die er in das LOG Verzeichnis schreibt. Mittlerweile habe ich schon einige Probleme behoben gehabt aber ich sehe nun kein Licht mehr am Ende des Tunnels, vielleicht könnt ihr mir ja helfen.

ERRORLOG:

2018-12-16 16:13:17.05 Server      Microsoft SQL Server 2014 (SP3-CU1) (KB4470220) - 12.0.6205.1 (X64) 
	Nov 30 2018 02:59:03 
	Copyright (c) Microsoft Corporation
	Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

2018-12-16 16:13:17.08 Server      UTC adjustment: 1:00
2018-12-16 16:13:17.09 Server      (c) Microsoft Corporation.
2018-12-16 16:13:17.09 Server      All rights reserved.
2018-12-16 16:13:17.09 Server      Server process ID is 1832.
2018-12-16 16:13:17.09 Server      System Manufacturer: 'Microsoft Corporation', System Model: 'Virtual Machine'.
2018-12-16 16:13:17.11 Server      Authentication mode is MIXED.
2018-12-16 16:13:17.11 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.SAGE\MSSQL\Log\ERRORLOG'.
2018-12-16 16:13:17.11 Server      The service account is 'NT Service\MSSQL$SAGE'. This is an informational message; no user action is required.
2018-12-16 16:13:17.11 Server      Registry startup parameters: 
	 -d C:\Program Files\Microsoft SQL Server\MSSQL12.SAGE\MSSQL\DATA\master.mdf
	 -e C:\Program Files\Microsoft SQL Server\MSSQL12.SAGE\MSSQL\Log\ERRORLOG
	 -l C:\Program Files\Microsoft SQL Server\MSSQL12.SAGE\MSSQL\DATA\mastlog.ldf
2018-12-16 16:13:17.11 Server      Command Line Startup Parameters:
	 -s "SAGE"
2018-12-16 16:13:18.46 Server      SQL Server detected 2 sockets with 8 cores per socket and 8 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2018-12-16 16:13:18.46 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2018-12-16 16:13:18.46 Server      Detected 51997 MB of RAM. This is an informational message; no user action is required.
2018-12-16 16:13:18.46 Server      Using conventional memory in the memory manager.
2018-12-16 16:13:19.23 Server      Default collation: Latin1_General_CI_AS (Deutsch 1031)
2018-12-16 16:13:21.72 Server      This instance of SQL Server last reported using a process ID of 1832 at 16.12.2018 16:08:20 (local) 16.12.2018 15:08:20 (UTC). This is an informational message only; no user action is required.
2018-12-16 16:13:21.72 Server      The maximum number of dedicated administrator connections for this instance is '1'
2018-12-16 16:13:21.74 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2018-12-16 16:13:21.74 Server      Node configuration: node 1: CPU mask: 0x000000000000ff00:0 Active CPU mask: 0x000000000000ff00:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2018-12-16 16:13:21.78 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.
2018-12-16 16:13:21.78 Server      Lock partitioning is enabled.  This is an informational message only. No user action is required.
2018-12-16 16:13:21.83 Server      Database Instant File Initialization: deaktiviert. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
2018-12-16 16:13:22.05 spid8s      Starting up database 'master'.
2018-12-16 16:13:22.44 Server      CLR version v4.0.30319 loaded.
2018-12-16 16:13:22.94 spid8s      CHECKDB for database 'master' finished without errors on 2018-12-15 21:44:49.157 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:22.97 spid8s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2018-12-16 16:13:22.99 spid8s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
2018-12-16 16:13:23.47 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2018-12-16 16:13:24.00 spid8s      SQL Trace ID 1 was started by login "sa".
2018-12-16 16:13:24.11 spid8s      Server name is 'VSERVER24\SAGE'. This is an informational message only. No user action is required.
2018-12-16 16:13:24.62 spid14s     A self-generated certificate was successfully loaded for encryption.
2018-12-16 16:13:24.64 spid14s     Server is listening on [ 'any' <ipv6> 1433].
2018-12-16 16:13:24.64 spid14s     Server is listening on [ 'any' <ipv4> 1433].
2018-12-16 16:13:24.65 spid14s     Server is listening on [ 'any' <ipv6> 52351].
2018-12-16 16:13:24.65 spid14s     Server is listening on [ 'any' <ipv4> 52351].
2018-12-16 16:13:24.66 spid14s     Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SAGE ].
2018-12-16 16:13:24.66 spid14s     Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$SAGE\sql\query ].
2018-12-16 16:13:24.66 Server      Server is listening on [ ::1 <ipv6> 52352].
2018-12-16 16:13:24.66 Server      Server is listening on [ 127.0.0.1 <ipv4> 52352].
2018-12-16 16:13:24.66 Server      Dedicated admin connection support was established for listening locally on port 52352.
2018-12-16 16:13:24.67 spid14s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
2018-12-16 16:13:24.70 Server      SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
2018-12-16 16:13:24.77 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/vServer24.SZABO-SCANDIC.COM:SAGE ] for the SQL Server service. Windows return code: 0x200b, state: 15. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
2018-12-16 16:13:24.77 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/vServer24.SZABO-SCANDIC.COM:1433 ] for the SQL Server service. Windows return code: 0x200b, state: 15. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
2018-12-16 16:13:29.52 Logon       Fehler: 18456, Schweregrad: 14, Status: 38.
2018-12-16 16:13:29.52 Logon       Login failed for user 'NT SERVICE\ReportServer$SAGE'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank 'ReportServer'. [CLIENT: 10.80.10.24]
2018-12-16 16:13:34.05 Logon       Fehler: 18456, Schweregrad: 14, Status: 38.
2018-12-16 16:13:34.05 Logon       Login failed for user 'NT SERVICE\ReportServer$SAGE'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank 'ReportServer'. [CLIENT: 10.80.10.24]
2018-12-16 16:13:37.44 spid15s     A new instance of the full-text filter daemon host process has been successfully started.
2018-12-16 16:13:38.15 spid19s     Starting up database 'br72_test01'.
2018-12-16 16:13:38.15 spid18s     Starting up database 'msdb'.
2018-12-16 16:13:38.15 spid10s     Starting up database 'mssqlsystemresource'.
2018-12-16 16:13:38.15 spid26s     Starting up database 'SSISDB'.
2018-12-16 16:13:38.18 spid10s     The resource database build version is 12.00.6205. This is an informational message only. No user action is required.
2018-12-16 16:13:38.23 spid25s     Starting up database 'br72_Preisarchiv'.
2018-12-16 16:13:38.24 spid21s     Starting up database 'ReportServerTempDB'.
2018-12-16 16:13:38.24 spid22s     Starting up database 'bfinanztest'.
2018-12-16 16:13:38.24 spid23s     Starting up database 'br72'.
2018-12-16 16:13:38.24 spid20s     Starting up database 'ReportServer'.
2018-12-16 16:13:38.24 spid24s     Starting up database 'bfinanz'.
2018-12-16 16:13:38.37 spid10s     Starting up database 'model'.
2018-12-16 16:13:39.19 spid10s     CHECKDB for database 'model' finished without errors on 2018-12-15 21:45:08.797 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:39.21 spid10s     Clearing tempdb database.
2018-12-16 16:13:39.85 spid10s     Starting up database 'tempdb'.
2018-12-16 16:13:40.04 spid10s     The tempdb database has 1 data file(s).
2018-12-16 16:13:40.08 spid27s     The Service Broker endpoint is in disabled or stopped state.
2018-12-16 16:13:40.19 spid27s     The Database Mirroring endpoint is in disabled or stopped state.
2018-12-16 16:13:40.20 spid18s     CHECKDB for database 'msdb' finished without errors on 2018-12-15 21:45:20.703 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:40.26 spid27s     Service Broker manager has started.
2018-12-16 16:13:40.39 spid26s     CHECKDB for database 'SSISDB' finished without errors on 2018-12-15 21:50:27.493 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:40.40 spid20s     CHECKDB for database 'ReportServer' finished without errors on 2018-12-16 15:28:06.893 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:40.55 spid25s     CHECKDB for database 'br72_Preisarchiv' finished without errors on 2018-12-16 09:30:23.473 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:40.57 spid21s     CHECKDB for database 'ReportServerTempDB' finished without errors on 2018-12-15 21:50:19.293 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:40.71 spid22s     CHECKDB for database 'bfinanztest' finished without errors on 2018-12-15 21:47:37.670 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:40.98 spid24s     CHECKDB for database 'bfinanz' finished without errors on 2018-12-16 09:24:31.667 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:41.00 spid19s     CHECKDB for database 'br72_test01' finished without errors on 2018-12-11 19:20:42.387 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:41.05 spid23s     CHECKDB for database 'br72' finished without errors on 2018-12-15 12:49:36.750 (local time). This is an informational message only; no user action is required.
2018-12-16 16:13:42.08 spid8s      Recovery is complete. This is an informational message only. No user action is required.
2018-12-16 16:13:42.36 spid51      Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2018-12-16 16:13:42.39 spid51      Using 'xpsqlbot.dll' version '2014.120.6205' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2018-12-16 16:13:42.58 spid51      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2018-12-16 16:13:42.64 spid51      Using 'xpstar.dll' version '2014.120.6205' to execute extended stored procedure 'xp_sqlagent_notify'. This is an informational message only; no user action is required.
2018-12-16 16:13:48.80 spid24s     ex_dump_if_requested: Exception raised, major=52, minor=42, state=9, severity=22, attempting to create symptom dump
2018-12-16 16:13:48.86 spid24s     Using 'dbghelp.dll' version '4.0.5'
2018-12-16 16:13:49.63 spid24s     **Dump thread - spid = 0, EC = 0x0000000A3373CF10
2018-12-16 16:13:49.64 spid24s     ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL12.SAGE\MSSQL\LOG\SQLDump14669.txt

Das Login Problem verstehe ich ebenfalls nicht, da die Datenbank verfügbar ist :( (Status 38 --> Die Datenbank kann nicht gefunden werden)

SQLDump:

07FF868C7EFFF  0004f000
2018-12-16 21:30:24.20 spid36s     * DEVOBJ                         00007FF867A00000  00007FF867A27FFF  00028000
2018-12-16 21:30:24.20 spid36s     * SAMCLI                         00007FF863950000  00007FF863966FFF  00017000
2018-12-16 21:30:24.20 spid36s     * CRYPTBASE                      00007FF8689D0000  00007FF8689DAFFF  0000b000
2018-12-16 21:30:24.20 spid36s     * bcryptPrimitives               00007FF868960000  00007FF8689C2FFF  00063000
2018-12-16 21:30:24.20 spid36s     * instapi120                     00007FF863810000  00007FF86381EFFF  0000f000
2018-12-16 21:30:24.20 spid36s     * cscapi                         00007FF8561A0000  00007FF8561B1FFF  00012000
2018-12-16 21:30:24.20 spid36s     * sqlevn70                       00007FF855E50000  00007FF856195FFF  00346000
2018-12-16 21:30:24.20 spid36s     * sqlevn70                       00007FF855B90000  00007FF855E40FFF  002b1000
2018-12-16 21:30:24.20 spid36s     * CRYPTSP                        00007FF8683F0000  00007FF86840FFFF  00020000
2018-12-16 21:30:24.20 spid36s     * rsaenh                         00007FF868030000  00007FF868065FFF  00036000
2018-12-16 21:30:24.20 spid36s     * bcrypt                         00007FF868640000  00007FF868665FFF  00026000
2018-12-16 21:30:24.20 spid36s     * imagehlp                       00007FF8690C0000  00007FF8690D5FFF  00016000
2018-12-16 21:30:24.20 spid36s     * ncrypt                         00007FF868610000  00007FF868634FFF  00025000
2018-12-16 21:30:24.20 spid36s     * NTASN1                         00007FF8685D0000  00007FF868606FFF  00037000
2018-12-16 21:30:24.20 spid36s     * gpapi                          00007FF867D70000  00007FF867D93FFF  00024000
2018-12-16 21:30:24.20 spid36s     * CLUSAPI                        00007FF854770000  00007FF8547DDFFF  0006e000
2018-12-16 21:30:24.20 spid36s     * cryptdll                       00007FF868510000  00007FF868529FFF  0001a000
2018-12-16 21:30:24.20 spid36s     * RESUTILS                       00007FF8547F0000  00007FF85483BFFF  0004c000
2018-12-16 21:30:24.20 spid36s     * VERSION                        00007FF863820000  00007FF863829FFF  0000a000
2018-12-16 21:30:24.20 spid36s     * msv1_0                         00007FF868320000  00007FF86838DFFF  0006e000
2018-12-16 21:30:24.20 spid36s     * kerberos                       00007FF868410000  00007FF868501FFF  000f2000
2018-12-16 21:30:24.20 spid36s     * schannel                       00007FF867FC0000  00007FF86802DFFF  0006e000
2018-12-16 21:30:24.20 spid36s     * MSCOREE                        00007FF862E30000  00007FF862E93FFF  00064000
2018-12-16 21:30:24.20 spid36s     * mscoreei                       00007FF862D90000  00007FF862E2BFFF  0009c000
2018-12-16 21:30:24.20 spid36s     * SqlServerSpatial120            00007FF8533D0000  00007FF85348BFFF  000bc000
2018-12-16 21:30:24.20 spid36s     * security                       00007FF863560000  00007FF863562FFF  00003000
2018-12-16 21:30:24.20 spid36s     * kernel.appcore                 00007FF867850000  00007FF86785AFFF  0000b000
2018-12-16 21:30:24.20 spid36s     * clbcatq                        00007FF869940000  00007FF8699F5FFF  000b6000
2018-12-16 21:30:24.20 spid36s     * ualapi                         00007FF8641A0000  00007FF8641B8FFF  00019000
2018-12-16 21:30:24.20 spid36s     * ESENT                          00007FF863ED0000  00007FF864199FFF  002ca000
2018-12-16 21:30:24.20 spid36s     * ntmarta                        00007FF866880000  00007FF8668B1FFF  00032000
2018-12-16 21:30:24.20 spid36s     * SHELL32                        00007FF869E30000  00007FF86B35AFFF  0152b000
2018-12-16 21:30:24.20 spid36s     * SHLWAPI                        00007FF8698E0000  00007FF869933FFF  00054000
2018-12-16 21:30:24.20 spid36s     * sqlncli11                      00007FF852AD0000  00007FF852E23FFF  00354000
2018-12-16 21:30:24.20 spid36s     * COMCTL32                       00007FF8633C0000  00007FF863463FFF  000a4000
2018-12-16 21:30:24.20 spid36s     * COMDLG32                       00007FF869B80000  00007FF869C35FFF  000b6000
2018-12-16 21:30:24.20 spid36s     * SHCORE                         00007FF8673E0000  00007FF867491FFF  000b2000
2018-12-16 21:30:24.20 spid36s     * SQLNCLIR11                     000000005E200000  000000005E237FFF  00038000
2018-12-16 21:30:24.20 spid36s     * DPAPI                          00007FF867810000  00007FF867819FFF  0000a000
2018-12-16 21:30:24.20 spid36s     * netbios                        00007FF8561C0000  00007FF8561CAFFF  0000b000
2018-12-16 21:30:24.20 spid36s     * clr                            00007FF8623A0000  00007FF862D8BFFF  009ec000
2018-12-16 21:30:24.20 spid36s     * MSVCR120_CLR0400               00007FF8622A0000  00007FF862396FFF  000f7000
2018-12-16 21:30:24.20 spid36s     * BatchParser                    00007FF8521D0000  00007FF8521F7FFF  00028000
2018-12-16 21:30:24.20 spid36s     * mscorlib.ni                    00007FF860D10000  00007FF862297FFF  01588000
2018-12-16 21:30:24.20 spid36s     * clrjit                         00007FF85FF50000  00007FF86007AFFF  0012b000
2018-12-16 21:30:24.20 spid36s     * ftimport                       00000000452B0000  00000000452D4FFF  00025000
2018-12-16 21:30:24.20 spid36s     * MSFTE                          0000000049980000  0000000049D2DFFF  003ae000
2018-12-16 21:30:24.20 spid36s     * dbghelp                        000000005E060000  000000005E1F5FFF  00196000
2018-12-16 21:30:24.20 spid36s     * mswsock                        00007FF868390000  00007FF8683E8FFF  00059000
2018-12-16 21:30:24.20 spid36s     * ntdsapi                        00007FF866400000  00007FF866428FFF  00029000
2018-12-16 21:30:24.20 spid36s     * DSPARSE                        00007FF863E60000  00007FF863E6CFFF  0000d000
2018-12-16 21:30:24.20 spid36s     * DNSAPI                         00007FF868190000  00007FF868233FFF  000a4000
2018-12-16 21:30:24.20 spid36s     * rasadhlp                       00007FF8641C0000  00007FF8641C9FFF  0000a000
2018-12-16 21:30:24.20 spid36s     * IPHLPAPI                       00007FF865550000  00007FF865579FFF  0002a000
2018-12-16 21:30:24.20 spid36s     * WINNSI                         00007FF865540000  00007FF865549FFF  0000a000
2018-12-16 21:30:24.20 spid36s     * fwpuclnt                       00007FF865460000  00007FF8654CAFFF  0006b000
2018-12-16 21:30:24.20 spid36s     * ncryptsslp                     00007FF853290000  00007FF8532ACFFF  0001d000
2018-12-16 21:30:24.20 spid36s     * xpsqlbot                       00007FF84CCB0000  00007FF84CCB7FFF  00008000
2018-12-16 21:30:24.20 spid36s     * xpstar                         00007FF84CC40000  00007FF84CCA7FFF  00068000
2018-12-16 21:30:24.20 spid36s     * ODBC32                         00007FF8522B0000  00007FF852371FFF  000c2000
2018-12-16 21:30:24.20 spid36s     * SQLSCM                         00007FF852510000  00007FF85251EFFF  0000f000
2018-12-16 21:30:24.20 spid36s     * xpstar                         00007FF84CC30000  00007FF84CC3EFFF  0000f000
2018-12-16 21:30:24.20 spid36s     * DSROLE                         00007FF8663F0000  00007FF8663F9FFF  0000a000
2018-12-16 21:30:24.20 spid36s     * dbghelp                        000000005D4C0000  000000005D655FFF  00196000
2018-12-16 21:30:24.20 spid36s     *
2018-12-16 21:30:24.20 spid36s     *     P1Home: 00000000496286C0:  00007FF85AF3184C  000000005EB8EB9B  000095519A4E53DE  00007FF85B081FC4  000000000000000A  00000000FFFFFFFF  
2018-12-16 21:30:24.20 spid36s     *     P2Home: 0000000000000000:  
2018-12-16 21:30:24.20 spid36s     *     P3Home: 0000000000510000:  0000000000000000  0100249F7FD05E27  00000002FFEEFFEE  0000000001BA0018  0000000000510120  0000000000510000  
2018-12-16 21:30:24.20 spid36s     *     P4Home: 0000000000000000:  
2018-12-16 21:30:24.20 spid36s     *     P5Home: 0000000000000000:  
2018-12-16 21:30:24.20 spid36s     *     P6Home: 000000000000000B:  
2018-12-16 21:30:24.20 spid36s     * ContextFlags: 000000000010000F:  
2018-12-16 21:30:24.20 spid36s     *      MxCsr: 0000000000001FA0:  
2018-12-16 21:30:24.20 spid36s     *      SegCs: 0000000000000033:  
2018-12-16 21:30:24.20 spid36s     *      SegDs: 000000000000002B:  
2018-12-16 21:30:24.20 spid36s     *      SegEs: 000000000000002B:  
2018-12-16 21:30:24.20 spid36s     *      SegFs: 0000000000000053:  
2018-12-16 21:30:24.20 spid36s     *      SegGs: 000000000000002B:  
2018-12-16 21:30:24.20 spid36s     *      SegSs: 000000000000002B:  
2018-12-16 21:30:24.20 spid36s     *     EFlags: 0000000000000202:  
2018-12-16 21:30:24.20 spid36s     *        Rax: 0000009A0000004D:  
2018-12-16 21:30:24.20 spid36s     *        Rcx: 0000004D00000000:  
2018-12-16 21:30:24.20 spid36s     *        Rdx: 0000000000000104:  
2018-12-16 21:30:24.20 spid36s     *        Rbx: 0000000000000000:  
2018-12-16 21:30:24.20 spid36s     *        Rsp: 0000000049628E10:  0000000000000000  0000000000000000  0000000A1FADEF10  0000000049629090  00000000000042AC  0000000000000000  
2018-12-16 21:30:24.20 spid36s     *        Rbp: 000000004962AA40:  0064005F00780065  005F0070006D0075  0072005F00660069  0065007500710065  0064006500740073  007800450020003A  
2018-12-16 21:30:24.20 spid36s     *        Rsi: 0000000A1FADEF10:  0000000A1FADEF10  0000000A1FADEDE0  0000000000000000  0000000000000000  0000000A1FADEF30  0000000A1FADEF30  
2018-12-16 21:30:24.20 spid36s     *        Rdi: 0000000049629090:  0000000020414520  000000000000000F  0000000100000001  0000000000000000  0000000000000000  0000000A2710E000  
2018-12-16 21:30:24.20 spid36s     *         R8: 0000000000000000:  
2018-12-16 21:30:24.20 spid36s     *         R9: 0000020800000003:  
2018-12-16 21:30:24.20 spid36s     *        R10: 0000000000000000:  
2018-12-16 21:30:24.20 spid36s     *        R11: 0000000000000000:  
2018-12-16 21:30:24.20 spid36s     *        R12: 000000000000083F:  
2018-12-16 21:30:24.20 spid36s     *        R13: 0000000000000001:  
2018-12-16 21:30:24.20 spid36s     *        R14: 0000000000000001:  
2018-12-16 21:30:24.20 spid36s     *        R15: 0000000000000000:  
2018-12-16 21:30:24.20 spid36s     *        Rip: 00007FF868FA8E6C:  000000C0248C8B48  FFFF85C4E8CC3348  C3000000D8C48148  9090909090909090  38418B4D28EC8348  11E8D18B49CA8B48  
2018-12-16 21:30:24.20 spid36s     * *******************************************************************************
2018-12-16 21:30:24.20 spid36s     * -------------------------------------------------------------------------------
2018-12-16 21:30:24.20 spid36s     * Short Stack Dump
2018-12-16 21:30:24.21 spid36s     00007FF868FA8E6C Module(KERNELBASE+0000000000008E6C)
2018-12-16 21:30:24.21 spid36s     00007FF859C754FE Module(sqllang+0000000000F254FE)
2018-12-16 21:30:24.21 spid36s     00007FF859C790B2 Module(sqllang+0000000000F290B2)
2018-12-16 21:30:24.22 spid36s     00007FF85922E5E2 Module(sqllang+00000000004DE5E2)
2018-12-16 21:30:24.22 spid36s     00007FF85800137F Module(sqldk+000000000003137F)
2018-12-16 21:30:24.22 spid36s     00007FF857FEE612 Module(sqldk+000000000001E612)
2018-12-16 21:30:24.23 spid36s     00007FF857FEE4A9 Module(sqldk+000000000001E4A9)
2018-12-16 21:30:24.23 spid36s     00007FF85E1BD11D Module(sqlmin+000000000317D11D)
2018-12-16 21:30:24.23 spid36s     00007FF85B29EB4C Module(sqlmin+000000000025EB4C)
2018-12-16 21:30:24.23 spid36s     00007FF85BD09A43 Module(sqlmin+0000000000CC9A43)
2018-12-16 21:30:24.23 spid36s     00007FF85BD09925 Module(sqlmin+0000000000CC9925)
2018-12-16 21:30:24.23 spid36s     00007FF85BD0BCC9 Module(sqlmin+0000000000CCBCC9)
2018-12-16 21:30:24.23 spid36s     00007FF85BCF5B2A Module(sqlmin+0000000000CB5B2A)
2018-12-16 21:30:24.24 spid36s     00007FF85BC85C6C Module(sqlmin+0000000000C45C6C)
2018-12-16 21:30:24.24 spid36s     00007FF85BC854ED Module(sqlmin+0000000000C454ED)
2018-12-16 21:30:24.24 spid36s     00007FF85B28C826 Module(sqlmin+000000000024C826)
2018-12-16 21:30:24.24 spid36s     00007FF85B059173 Module(sqlmin+0000000000019173)
2018-12-16 21:30:24.24 spid36s     00007FF85B059049 Module(sqlmin+0000000000019049)
2018-12-16 21:30:24.24 spid36s     00007FF85B057D63 Module(sqlmin+0000000000017D63)
2018-12-16 21:30:24.24 spid36s     00007FF85B057A0A Module(sqlmin+0000000000017A0A)
2018-12-16 21:30:24.24 spid36s     00007FF858D5498F Module(sqllang+000000000000498F)
2018-12-16 21:30:24.24 spid36s     00007FF85B0576E5 Module(sqlmin+00000000000176E5)
2018-12-16 21:30:24.24 spid36s     00007FF857FD4800 Module(sqldk+0000000000004800)
2018-12-16 21:30:24.24 spid36s     00007FF857FD45C7 Module(sqldk+00000000000045C7)
2018-12-16 21:30:24.24 spid36s     00007FF857FD4296 Module(sqldk+0000000000004296)
2018-12-16 21:30:24.24 spid36s     00007FF857FEB54F Module(sqldk+000000000001B54F)
2018-12-16 21:30:24.24 spid36s     00007FF857FEB6A0 Module(sqldk+000000000001B6A0)
2018-12-16 21:30:24.24 spid36s     00007FF857FEB629 Module(sqldk+000000000001B629)
2018-12-16 21:30:24.25 spid36s     00007FF857FEBEB8 Module(sqldk+000000000001BEB8)
2018-12-16 21:30:24.26 spid36s     00007FF8692413D2 Module(KERNEL32+00000000000013D2)
2018-12-16 21:30:24.26 spid36s     00007FF86BA454F4 Module(ntdll+00000000000154F4)
2018-12-16 21:30:24.27 spid36s     Stack Signature for the dump is 0x0000000098CFB4FD
2018-12-16 21:30:24.65 spid36s     External dump process return code 0x20000001.
External dump process returned no errors.

2018-12-16 21:30:34.23 spid19s     ex_dump_if_requested: Exception raised, major=52, minor=42, state=9, severity=22, attempting to create symptom dump
2018-12-16 21:30:34.23 spid19s     **Dump thread - spid = 0, EC = 0x00000009C1EE6F10
2018-12-16 21:30:34.23 spid19s     ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL12.SAGE\MSSQL\LOG\SQLDump16562.txt
2018-12-16 21:30:34.23 spid19s     * *******************************************************************************
2018-12-16 21:30:34.23 spid19s     *
2018-12-16 21:30:34.23 spid19s     * BEGIN STACK DUMP:
2018-12-16 21:30:34.23 spid19s     *   12/16/18 21:30:34 spid 19
2018-12-16 21:30:34.23 spid19s     *
2018-12-16 21:30:34.23 spid19s     * ex_dump_if_requested: Exception raised, major=52, minor=42, state=9, severity=22
2018-12-16 21:30:34.23 spid19s     *
2018-12-16 21:30:34.23 spid19s     *  
2018-12-16 21:30:34.23 spid19s     *
2018-12-16 21:30:34.23 spid19s     *  MODULE                          BASE      END       SIZE
2018-12-16 21:30:34.23 spid19s     * sqlservr                       00007FF7FDF60000  00007FF7FDFBFFFF  00060000
2018-12-16 21:30:34.23 spid19s     * ntdll                          00007FF86BA30000  00007FF86BBDCFFF  001ad000
2018-12-16 21:30:34.23 spid19s     * KERNEL32                       00007FF869240000  00007FF86937DFFF  0013e000
2018-12-16 21:30:34.23 spid19s     * KERNELBASE                     00007FF868FA0000  00007FF8690B5FFF  00116000
2018-12-16 21:30:34.23 spid19s     * NETAPI32                       00007FF866290000  00007FF8662A5FFF  00016000
2018-12-16 21:30:34.23 spid19s     * pdh                            00007FF85EF90000  00007FF85EFDEFFF  0004f000
2018-12-16 21:30:34.23 spid19s     * opends60                       00007FF85EF70000  00007FF85EF78FFF  00009000
2018-12-16 21:30:34.23 spid19s     * ADVAPI32                       00007FF869120000  00007FF8691C9FFF  000aa000
2018-12-16 21:30:34.23 spid19s     * MSVCR100                       000000005EB50000  000000005EC21FFF  000d2000
2018-12-16 21:30:34.23 spid19s     * MSVCP100                       000000005EA80000  000000005EB17FFF  00098000
2018-12-16 21:30:34.23 spid19s     * SQLOS                          00007FF85EF60000  00007FF85EF66FFF  00007000
2018-12-16 21:30:34.23 spid19s     * sqlmin                         00007FF85B040000  00007FF85EF5DFFF  03f1e000
2018-12-16 21:30:34.23 spid19s     * sqllang                        00007FF858D50000  00007FF85B037FFF  022e8000
2018-12-16 21:30:34.23 spid19s     * sqlTsEs                        00007FF8584B0000  00007FF858D43FFF  00894000
2018-12-16 21:30:34.23 spid19s     * sqldk                          00007FF857FD0000  00007FF8584ADFFF  004de000
2018-12-16 21:30:34.23 spid19s     * netutils                       00007FF867530000  00007FF86753BFFF  0000c000
2018-12-16 21:30:34.23 spid19s     * srvcli                         00007FF868770000  00007FF868795FFF  00026000
2018-12-16 21:30:34.23 spid19s     * wkscli                         00007FF8677F0000  00007FF867806FFF  00017000
2018-12-16 21:30:34.24 spid19s     * msvcrt                         00007FF86B770000  00007FF86B819FFF  000aa000
2018-12-16 21:30:34.24 spid19s     * RPCRT4                         00007FF8697A0000  00007FF8698DFFFF  00140000
2018-12-16 21:30:34.24 spid19s     * sechost                        00007FF8691D0000  00007FF869228FFF  00059000
2018-12-16 21:30:34.24 spid19s     * CRYPT32                        00007FF868DC0000  00007FF868F9EFFF  001df000
2018-12-16 21:30:34.24 spid19s     * Secur32                        00007FF863EA0000  00007FF863EABFFF  0000c000
2018-12-16 21:30:34.24 spid19s     * PSAPI                          00007FF869A00000  00007FF869A06FFF  00007000
2018-12-16 21:30:34.24 spid19s     * WS2_32                         00007FF869740000  00007FF869799FFF  0005a000
2018-12-16 21:30:34.24 spid19s     * WINHTTP                        00007FF8631B0000  00007FF863276FFF  000c7000
2018-12-16 21:30:34.24 spid19s     * USER32                         00007FF869CB0000  00007FF869E26FFF  00177000
2018-12-16 21:30:34.24 spid19s     * ole32                          00007FF8695A0000  00007FF869733FFF  00194000
2018-12-16 21:30:34.24 spid19s     * OLEAUT32                       00007FF8694D0000  00007FF869595FFF  000c6000
2018-12-16 21:30:34.24 spid19s     * qds                            00007FF857F40000  00007FF857FCDFFF  0008e000
2018-12-16 21:30:34.24 spid19s     * USERENV                        00007FF868120000  00007FF868140FFF  00021000
2018-12-16 21:30:34.24 spid19s     * AUTHZ                          00007FF867E20000  00007FF867E67FFF  00048000
2018-12-16 21:30:34.24 spid19s     * WINTRUST                       00007FF868D60000  00007FF868DB0FFF  00051000
2018-12-16 21:30:34.24 spid19s     * WINMM                          00007FF857360000  00007FF857381FFF  00022000
2018-12-16 21:30:34.24 spid19s     * SspiCli                        00007FF868C80000  00007FF868CADFFF  0002e000
2018-12-16 21:30:34.24 spid19s     * MSASN1                         00007FF868C10000  00007FF868C20FFF  00011000
2018-12-16 21:30:34.24 spid19s     * NSI                            00007FF86B760000  00007FF86B768FFF  00009000
2018-12-16 21:30:34.24 spid19s     * combase                        00007FF86B820000  00007FF86BA2FFFF  00210000
2018-12-16 21:30:34.24 spid19s     * GDI32                          00007FF869380000  00007FF8694CBFFF  0014c000
2018-12-16 21:30:34.24 spid19s     * profapi                        00007FF868B60000  00007FF868B74FFF  00015000
2018-12-16 21:30:34.24 spid19s     * WINMMBASE                      00007FF857330000  00007FF857359FFF  0002a000
2018-12-16 21:30:34.24 spid19s     * LOGONCLI                       00007FF868150000  00007FF86818EFFF  0003f000
2018-12-16 21:30:34.24 spid19s     * cfgmgr32                       00007FF868C30000  00007FF868C7EFFF  0004f000
2018-12-16 21:30:34.24 spid19s     * DEVOBJ                         00007FF867A00000  00007FF867A27FFF  00028000
2018-12-16 21:30:34.24 spid19s     * SAMCLI                         00007FF863950000  00007FF863966FFF  00017000
2018-12-16 21:30:34.24 spid19s     * CRYPTBASE                      00007FF8689D0000  00007FF8689DAFFF  0000b000
2018-12-16 21:30:34.24 spid19s     * bcryptPrimitives               00007FF868960000  00007FF8689C2FFF  00063000
2018-12-16 21:30:34.24 spid19s     * instapi120                     00007FF863810000  00007FF86381EFFF  0000f000
2018-12-16 21:30:34.24 spid19s     * cscapi                         00007FF8561A0000  00007FF8561B1FFF  00012000
2018-12-16 21:30:34.24 spid19s     * sqlevn70                       00007FF855E50000  00007FF856195FFF  00346000
2018-12-16 21:30:34.24 spid19s     * sqlevn70                       00007FF855B90000  00007FF855E40FFF  002b1000
2018-12-16 21:30:34.24 spid19s     * CRYPTSP                        00007FF8683F0000  00007FF86840FFFF  00020000
2018-12-16 21:30:34.24 spid19s     * rsaenh                         00007FF868030000  00007FF868065FFF  00036000
2018-12-16 21:30:34.24 spid19s     * bcrypt                         00007FF868640000  00007FF868665FFF  00026000
2018-12-16 21:30:34.24 spid19s     * imagehlp                       00007FF8690C0000  00007FF8690D5FFF  00016000
2018-12-16 21:30:34.24 spid19s     * ncrypt                         00007FF868610000  00007FF868634FFF  00025000
2018-12-16 21:30:34.24 spid19s     * NTASN1                         00007FF8685D0000  00007FF868606FFF  00037000
2018-12-16 21:30:34.24 spid19s     * gpapi                          00007FF867D70000  00007FF867D93FFF  00024000
2018-12-16 21:30:34.24 spid19s     * CLUSAPI                        00007FF854770000  00007FF8547DDFFF  0006e000
2018-12-16 21:30:34.24 spid19s     * cryptdll                       00007FF868510000  00007FF868529FFF  0001a000
2018-12-16 21:30:34.24 spid19s     * RESUTILS                       00007FF8547F0000  00007FF85483BFFF  0004c000
2018-12-16 21:30:34.24 spid19s     * VERSION                        00007FF863820000  00007FF863829FFF  0000a000
2018-12-16 21:30:34.24 spid19s     * msv1_0                         00007FF868320000  00007FF86838DFFF  0006e000
2018-12-16 21:30:34.24 spid19s     * kerberos                       00007FF868410000  00007FF868501FFF  000f2000
2018-12-16 21:30:34.24 spid19s     * schannel                       00007FF867FC0000  00007FF86802DFFF  0006e000
2018-12-16 21:30:34.24 spid19s     * MSCOREE                        00007FF862E30000  00007FF862E93FFF  00064000
2018-12-16 21:30:34.24 spid19s     * mscoreei                       00007FF862D90000  00007FF862E2BFFF  0009c000
2018-12-16 21:30:34.24 spid19s     * SqlServerSpatial120            00007FF8533D0000  00007FF85348BFFF  000bc000
2018-12-16 21:30:34.24 spid19s     * security                       00007FF863560000  00007FF863562FFF  00003000
2018-12-16 21:30:34.24 spid19s     * kernel.appcore                 00007FF867850000  00007FF86785AFFF  0000b000
2018-12-16 21:30:34.24 spid19s     * clbcatq                        00007FF869940000  00007FF8699F5FFF  000b6000
2018-12-16 21:30:34.24 spid19s     * ualapi                         00007FF8641A0000  00007FF8641B8FFF  00019000
2018-12-16 21:30:34.24 spid19s     * ESENT                          00007FF863ED0000  00007FF864199FFF  002ca000
2018-12-16 21:30:34.24 spid19s     * ntmarta                        00007FF866880000  00007FF8668B1FFF  00032000
2018-12-16 21:30:34.24 spid19s     * SHELL32                        00007FF869E30000  00007FF86B35AFFF  0152b000
2018-12-16 21:30:34.24 spid19s     * SHLWAPI                        00007FF8698E0000  00007FF869933FFF  00054000
2018-12-16 21:30:34.24 spid19s     * sqlncli11                      00007FF852AD0000  00007FF852E23FFF  00354000
2018-12-16 21:30:34.24 spid19s     * COMCTL32                       00007FF8633C0000  00007FF863463FFF  000a4000
2018-12-16 21:30:34.24 spid19s     * COMDLG32                       00007FF869B80000  00007FF869C35FFF  000b6000
2018-12-16 21:30:34.24 spid19s     * SHCORE                         00007FF8673E0000  00007FF867491FFF  000b2000
2018-12-16 21:30:34.24 spid19s     * SQLNCLIR11                     000000005E200000  000000005E237FFF  00038000
2018-12-16 21:30:34.24 spid19s     * DPAPI                          00007FF867810000  00007FF867819FFF  0000a000
2018-12-16 21:30:34.24 spid19s     * netbios                        00007FF8561C0000  00007FF8561CAFFF  0000b000
2018-12-16 21:30:34.24 spid19s     * clr                            00007FF8623A0000  00007FF862D8BFFF  009ec000
2018-12-16 21:30:34.24 spid19s     * MSVCR120_CLR0400               00007FF8622A0000  00007FF862396FFF  000f7000
2018-12-16 21:30:34.24 spid19s     * BatchParser                    00007FF8521D0000  00007FF8521F7FFF  00028000
2018-12-16 21:30:34.24 spid19s     * mscorlib.ni                    00007FF860D10000  00007FF862297FFF  01588000
2018-12-16 21:30:34.24 spid19s     * clrjit                         00007FF85FF50000  00007FF86007AFFF  0012b000
2018-12-16 21:30:34.24 spid19s     * ftimport                       00000000452B0000  00000000452D4FFF  00025000
2018-12-16 21:30:34.24 spid19s     * MSFTE                          0000000049980000  0000000049D2DFFF  003ae000
2018-12-16 21:30:34.24 spid19s     * dbghelp                        000000005E060000  000000005E1F5FFF  00196000
2018-12-16 21:30:34.24 spid19s     * mswsock                        00007FF868390000  00007FF8683E8FFF  00059000
2018-12-16 21:30:34.24 spid19s     * ntdsapi                        00007FF866400000  00007FF866428FFF  00029000
2018-12-16 21:30:34.24 spid19s     * DSPARSE                        00007FF863E60000  00007FF863E6CFFF  0000d000
2018-12-16 21:30:34.24 spid19s     * DNSAPI                         00007FF868190000  00007FF868233FFF  000a4000
2018-12-16 21:30:34.24 spid19s     * rasadhlp                       00007FF8641C0000  00007FF8641C9FFF  0000a000
2018-12-16 21:30:34.24 spid19s     * IPHLPAPI                       00007FF865550000  00007FF865579FFF  0002a000
2018-12-16 21:30:34.24 spid19s     * WINNSI                         00007FF865540000  00007FF865549FFF  0000a000
2018-12-16 21:30:34.24 spid19s     * fwpuclnt                       00007FF865460000  00007FF8654CAFFF  0006b000
2018-12-16 21:30:34.24 spid19s     * ncryptsslp                     00007FF853290000  00007FF8532ACFFF  0001d000
2018-12-16 21:30:34.24 spid19s     * xpsqlbot                       00007FF84CCB0000  00007FF84CCB7FFF  00008000
2018-12-16 21:30:34.24 spid19s     * xpstar                         00007FF84CC40000  00007FF84CCA7FFF  00068000
2018-12-16 21:30:34.24 spid19s     * ODBC32                         00007FF8522B0000  00007FF852371FFF  000c2000
2018-12-16 21:30:34.24 spid19s     * SQLSCM                         00007FF852510000  00007FF85251EFFF  0000f000
2018-12-16 21:30:34.24 spid19s     * xpstar                         00007FF84CC30000  00007FF84CC3EFFF  0000f000
2018-12-16 21:30:34.24 spid19s     * DSROLE                         00007FF8663F0000  00007FF8663F9FFF  0000a000
2018-12-16 21:30:34.24 spid19s     * dbghelp                        000000005D4C0000  000000005D655FFF  00196000
2018-12-16 21:30:34.24 spid19s     *
2018-12-16 21:30:34.24 spid19s     *     P1Home: 00000000163F8850:  00007FF85AF3184C  000000005EB8EB9B  00009551C5135D4E  0000000000000000  000000000000000A  00000000FFFFFFFF  
2018-12-16 21:30:34.24 spid19s     *     P2Home: 0000000000000000:  
2018-12-16 21:30:34.24 spid19s     *     P3Home: 0000000000510000:  0000000000000000  0100249F7FD05E27  00000002FFEEFFEE  0000000001BA0018  0000000000510120  0000000000510000  
2018-12-16 21:30:34.24 spid19s     *     P4Home: 0000000000000000:  
2018-12-16 21:30:34.24 spid19s     *     P5Home: 0000000000000000:  
2018-12-16 21:30:34.24 spid19s     *     P6Home: 000000000000000B:  
2018-12-16 21:30:34.24 spid19s     * ContextFlags: 000000000010000F:  
2018-12-16 21:30:34.24 spid19s     *      MxCsr: 0000000000001FA0:  
2018-12-16 21:30:34.24 spid19s     *      SegCs: 0000000000000033:  
2018-12-16 21:30:34.24 spid19s     *      SegDs: 000000000000002B:  
2018-12-16 21:30:34.24 spid19s     *      SegEs: 000000000000002B:  
2018-12-16 21:30:34.24 spid19s     *      SegFs: 0000000000000053:  
2018-12-16 21:30:34.24 spid19s     *      SegGs: 000000000000002B:  
2018-12-16 21:30:34.24 spid19s     *      SegSs: 000000000000002B:  
2018-12-16 21:30:34.24 spid19s     *     EFlags: 0000000000000202:  
2018-12-16 21:30:34.24 spid19s     *        Rax: 0000009A0000004D:  
2018-12-16 21:30:34.24 spid19s     *        Rcx: 0000004D00000000:  
2018-12-16 21:30:34.24 spid19s     *        Rdx: 0000000000000104:  
2018-12-16 21:30:34.24 spid19s     *        Rbx: 0000000000000000:  
2018-12-16 21:30:34.24 spid19s     *        Rsp: 00000000163F8FA0:  0000000000000000  0000000000000000  00000009C1EE6F10  00000000163F9220  00000000000042AC  0000000000000000  
2018-12-16 21:30:34.24 spid19s     *        Rbp: 00000000163FABD0:  0064005F00780065  005F0070006D0075  0072005F00660069  0065007500710065  0064006500740073  007800450020003A  
2018-12-16 21:30:34.24 spid19s     *        Rsi: 00000009C1EE6F10:  00000009C1EE6F10  00000009C1EE6DE0  0000000000000000  0000000000000000  00000009C1EE6F30  00000009C1EE6F30  
2018-12-16 21:30:34.24 spid19s     *        Rdi: 00000000163F9220:  00000000204136B0  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000000000000  
2018-12-16 21:30:34.24 spid19s     *         R8: 0000000000000000:  
2018-12-16 21:30:34.24 spid19s     *         R9: 0000020800000003:  
2018-12-16 21:30:34.24 spid19s     *        R10: 0000000000000000:  
2018-12-16 21:30:34.24 spid19s     *        R11: 0000000000000000:  
2018-12-16 21:30:34.24 spid19s     *        R12: 000000000000083F:  
2018-12-16 21:30:34.24 spid19s     *        R13: 0000000000000001:  
2018-12-16 21:30:34.24 spid19s     *        R14: 0000000000000001:  
2018-12-16 21:30:34.24 spid19s     *        R15: 0000000000000000:  
2018-12-16 21:30:34.24 spid19s     *        Rip: 00007FF868FA8E6C:  000000C0248C8B48  FFFF85C4E8CC3348  C3000000D8C48148  9090909090909090  38418B4D28EC8348  11E8D18B49CA8B48  
2018-12-16 21:30:34.24 spid19s     * *******************************************************************************
2018-12-16 21:30:34.24 spid19s     * -------------------------------------------------------------------------------
2018-12-16 21:30:34.24 spid19s     * Short Stack Dump
2018-12-16 21:30:34.25 spid19s     00007FF868FA8E6C Module(KERNELBASE+0000000000008E6C)
2018-12-16 21:30:34.25 spid19s     00007FF859C754FE Module(sqllang+0000000000F254FE)
2018-12-16 21:30:34.25 spid19s     00007FF859C790B2 Module(sqllang+0000000000F290B2)
2018-12-16 21:30:34.26 spid19s     00007FF85922E5E2 Module(sqllang+00000000004DE5E2)
2018-12-16 21:30:34.26 spid19s     00007FF85800137F Module(sqldk+000000000003137F)
2018-12-16 21:30:34.26 spid19s     00007FF857FEE612 Module(sqldk+000000000001E612)
2018-12-16 21:30:34.27 spid19s     00007FF857FEE4A9 Module(sqldk+000000000001E4A9)
2018-12-16 21:30:34.27 spid19s     00007FF85E1BD11D Module(sqlmin+000000000317D11D)
2018-12-16 21:30:34.27 spid19s     00007FF85B29EB4C Module(sqlmin+000000000025EB4C)
2018-12-16 21:30:34.27 spid19s     00007FF85BD09A43 Module(sqlmin+0000000000CC9A43)
2018-12-16 21:30:34.27 spid19s     00007FF85BD09925 Module(sqlmin+0000000000CC9925)
2018-12-16 21:30:34.27 spid19s     00007FF85BD0BCC9 Module(sqlmin+0000000000CCBCC9)
2018-12-16 21:30:34.27 spid19s     00007FF85BCF5B2A Module(sqlmin+0000000000CB5B2A)
2018-12-16 21:30:34.27 spid19s     00007FF85BC85C6C Module(sqlmin+0000000000C45C6C)
2018-12-16 21:30:34.27 spid19s     00007FF85BC854ED Module(sqlmin+0000000000C454ED)
2018-12-16 21:30:34.28 spid19s     00007FF85B28C826 Module(sqlmin+000000000024C826)
2018-12-16 21:30:34.28 spid19s     00007FF85B059173 Module(sqlmin+0000000000019173)
2018-12-16 21:30:34.28 spid19s     00007FF85B059049 Module(sqlmin+0000000000019049)
2018-12-16 21:30:34.28 spid19s     00007FF85B057D63 Module(sqlmin+0000000000017D63)
2018-12-16 21:30:34.28 spid19s     00007FF85B057A0A Module(sqlmin+0000000000017A0A)
2018-12-16 21:30:34.28 spid19s     00007FF858D5498F Module(sqllang+000000000000498F)
2018-12-16 21:30:34.28 spid19s     00007FF85B0576E5 Module(sqlmin+00000000000176E5)
2018-12-16 21:30:34.28 spid19s     00007FF857FD4800 Module(sqldk+0000000000004800)
2018-12-16 21:30:34.28 spid19s     00007FF857FD45C7 Module(sqldk+00000000000045C7)
2018-12-16 21:30:34.28 spid19s     00007FF857FD4296 Module(sqldk+0000000000004296)
2018-12-16 21:30:34.28 spid19s     00007FF857FEB54F Module(sqldk+000000000001B54F)
2018-12-16 21:30:34.28 spid19s     00007FF857FEB6A0 Module(sqldk+000000000001B6A0)
2018-12-16 21:30:34.28 spid19s     00007FF857FEB629 Module(sqldk+000000000001B629)
2018-12-16 21:30:34.29 spid19s     00007FF857FEBEB8 Module(sqldk+000000000001BEB8)
2018-12-16 21:30:34.30 spid19s     00007FF8692413D2 Module(KERNEL32+00000000000013D2)
2018-12-16 21:30:34.30 spid19s     00007FF86BA454F4 Module(ntdll+00000000000154F4)
2018-12-16 21:30:34.30 spid19s     Stack Signature for the dump is 0x0000000098CFB4FD

Bin für jeden Tipp und Hilfe dankbar.

schönen Abend noch

LG
Gregor

Sonntag, 16. Dezember 2018 20:35

Antworten

0

Anmelden
Problem ist behoben.

Beim überspielen einer ECHT Datenbank in ein Testsystem wurden auch die Konsistenzprobleme der Datenbank mitgenommen, es wurde nur vergessen auch ein DBCC CHECKDB auf die Testdatenbank zu machen und diese anschlie0end zu reparieren.

LG
Gregor
- Als Antwort markiert GregTheDeViL5 Montag, 17. Dezember 2018 02:15
Montag, 17. Dezember 2018 02:15

Antworten

|

Zitieren

Alle Antworten

0

Anmelden
Problem ist behoben.

Beim überspielen einer ECHT Datenbank in ein Testsystem wurden auch die Konsistenzprobleme der Datenbank mitgenommen, es wurde nur vergessen auch ein DBCC CHECKDB auf die Testdatenbank zu machen und diese anschlie0end zu reparieren.

LG
Gregor
- Als Antwort markiert GregTheDeViL5 Montag, 17. Dezember 2018 02:15
Montag, 17. Dezember 2018 02:15

Antworten

|

Zitieren
1

Anmelden
2018-12-16 16:13:24.67 spid14s SQL Server is now ready for client connections. This is an informational message; no user action is required. ... 2018-12-16 16:13:34.05 Logon Login failed for user 'NT SERVICE\ReportServer$SAGE'.Ursache:
Fehler beim Öffnen der explizit angegebenen Datenbank 'ReportServer'. [CLIENT: 10.80.10.24] ... 2018-12-16 16:13:38.24 spid20s Starting up database 'ReportServer'.

Das Login Problem verstehe ich ebenfalls nicht, da die Datenbank verfügbar ist :( (Status 38 --> Die Datenbank kann nicht gefunden werden)

Hallo Gregor,

der SQL Server selbst war zu dem Zeitpunkt bereit für Verbindungen, aber der ReportServer Dienst (SSRS) verbindet sich beim Start mit der ReportServer+ReportServerTemp Datenbank und die waren zu dem Zeitpunkt noch nicht Verfügbar. Alsoo hat der Login selbst funktioniert, nur der Zugriff auf die DB nicht.

Olaf Helper

[ Blog] [ Xing] [ MVP]
- Bearbeitet Olaf HelperMVP Mittwoch, 19. Dezember 2018 11:46
Montag, 17. Dezember 2018 07:15

Antworten

|

Zitieren

Produkte

Resources

Solutions

Updates

Testversionen

Verwandte Websites

Training

Zertifizierungen

Weitere Ressourcen

Für Produkte

Mehr Support

Kein IT-Experte?

Benutzer mit den meisten Antworten

SQL Dumps müllen den Server zu

Frage

Antworten

Alle Antworten

Produkte

Resources

Solutions

Updates

Testversionen

Verwandte Websites

Training

Zertifizierungen

Weitere Ressourcen

Für Produkte

Mehr Support

Kein IT-Experte?

Benutzer mit den meisten Antworten

SQL Dumps m&#252;llen den Server zu

Frage

Antworten

Alle Antworten

SQL Dumps müllen den Server zu