Databases showed "recovery pending" (SQL 2019)

Matrix-Matrix-Matrix 46 Reputation points
2021-01-02T12:31:46.093+00:00

Hello,

  • customer has one SQL 2019 Standard on a Windows 2016 Std. (vmware esxi) and he use four databases
  • I restarted the Windows Server three different times in the last month because of application maintenance
  • at two times SQL Databases showed in MS SQL Studio: recovery pending

adhoc Solution was:

  • rightlick restarting SQL-Instance via Studio again

SQL Log I will post here later

Details:

abla_DB (very small)
import_DB (recovery pending) (import_DB.mdf = 3 GB, with approx. 60GB Filestream Folder), BAK = 65 GB)
practical_DB (recovery pending) practical_DB.mdf = 20 GB, with approx 1,5GB Filestream Folder, BAK = 20 GB)
system_DB (very small)

Side-Infos:

  • Veeam Backup and Replication is doing Image-Backup
  • no SQL Dumb backup via sql agent configured yet
  • before reboot I manually stopped onetimes SQL Server Instance Service, looks like no effect
  • the Server is installed since 1-2 month

Can you help me find the cause?

Thx + Best Regards in advance!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,164 questions
{count} vote

Accepted answer
  1. Jeffrey Williams 1,896 Reputation points
    2021-01-02T18:02:47.007+00:00

    I see this:

    12/31/2020 10:38:54,Server,Unbekannt,SQL Server detected 12 sockets with 1 cores per socket and 1 logical processors per socket<c/> 12 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

    And this:

    12/31/2020 10:27:08,spid11s,Unbekannt,A failure occurred while FILESTREAM configuration was being changed or applied. For more information<c/> see the SQL Server error log.
    12/31/2020 10:27:08,spid11s,Unbekannt,FILESTREAM: effective level = 0<c/> configured level = 2.
    12/31/2020 10:27:08,spid11s,Unbekannt,FILESTREAM: failed to connect to kernel driver RsFx0600.<nl/><{1038F43D-3391-45F7-B1B3-BADF26459429}>Failed to initialize CFsaShareFilter: Error 0x80070015 (-2147024875)

    You could try setting the SQL Server service to delay start - as it seems some of the drives may not be available after a server restart.

    2 people found this answer helpful.
    0 comments No comments

6 additional answers

Sort by: Most helpful
  1. Matrix-Matrix-Matrix 46 Reputation points
    2021-01-02T12:34:17.157+00:00

    52864-photo-one.jpg

    1 person found this answer helpful.
    0 comments No comments

  2. Oscar Maqueda 611 Reputation points Microsoft Employee
    2021-01-02T12:36:26.423+00:00
    0 comments No comments

  3. Matrix-Matrix-Matrix 46 Reputation points
    2021-01-02T13:10:28.26+00:00

    a)
    Veeam Backup and Replication (image backup software)
    had sometimes yellow warning with this message: Unable to truncate Microsoft SQL Server transaction logs. Details: Failed to process 'TruncateSQLLog' command. CoInitialize() failed. HRESULT=0x80070583.

    b)
    Diskspace is > 100GB
    Memory is 128GB physical and 32GB is max for databases

    c)
    Recovery Model is simple

    d)
    Autoclose is false

    e)
    *.LDF Files are approx 400MB


  4. Matrix-Matrix-Matrix 46 Reputation points
    2021-01-02T13:22:42.757+00:00

    Hello,

    Windows Server Restart was 12/31/2020 10-11 in the morning

    Do you see a interessting thing in the Log?

    The log of 12/16/2020 in the evening looks nearly the same. (there was the same problem after windows server reboot)

    12/31/2020 10:39:55,spid51,Unbekannt,Using 'xplog70.dll' version '2019.150.2000' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    12/31/2020 10:39:55,spid51,Unbekannt,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
    12/31/2020 10:39:15,Server,Unbekannt,Software Usage Metrics is enabled.
    12/31/2020 10:38:58,spid53,Unbekannt,Using 'xpstar.dll' version '2019.150.2000' to execute extended stored procedure 'xp_sqlagent_notify'. This is an informational message only; no user action is required.
    12/31/2020 10:38:57,spid53,Unbekannt,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
    12/31/2020 10:38:57,spid53,Unbekannt,Using 'xpsqlbot.dll' version '2019.150.2000' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    12/31/2020 10:38:57,spid53,Unbekannt,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
    12/31/2020 10:38:57,spid53,Unbekannt,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    12/31/2020 10:38:57,spid10s,Unbekannt,Recovery is complete. This is an informational message only. No user action is required.
    12/31/2020 10:38:57,spid23s,Unbekannt,Service Broker manager has started.
    12/31/2020 10:38:57,spid23s,Unbekannt,The Database Mirroring endpoint is in disabled or stopped state.
    12/31/2020 10:38:57,spid23s,Unbekannt,The Service Broker endpoint is in disabled or stopped state.
    12/31/2020 10:38:57,spid12s,Unbekannt,The tempdb database has 8 data file(s).
    12/31/2020 10:38:56,spid12s,Unbekannt,Starting up database 'tempdb'.
    12/31/2020 10:38:56,spid24s,Unbekannt,Parallel redo is shutdown for database 'PraxisDb' with worker pool size [6].
    12/31/2020 10:38:56,spid25s,Unbekannt,Parallel redo is shutdown for database 'ImportDb' with worker pool size [6].
    12/31/2020 10:38:56,spid12s,Unbekannt,Clearing tempdb database.
    12/31/2020 10:38:56,spid25s,Unbekannt,Parallel redo is started for database 'ImportDb' with worker pool size [6].
    12/31/2020 10:38:56,spid27s,Unbekannt,Parallel redo is shutdown for database 'SystemDb' with worker pool size [6].
    12/31/2020 10:38:56,spid24s,Unbekannt,Parallel redo is started for database 'PraxisDb' with worker pool size [6].
    12/31/2020 10:38:56,spid26s,Unbekannt,Parallel redo is shutdown for database 'AblageDb' with worker pool size [6].
    12/31/2020 10:38:56,spid12s,Unbekannt,Starting up database 'model'.
    12/31/2020 10:38:56,spid23s,Unbekannt,Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
    12/31/2020 10:38:56,spid27s,Unbekannt,Parallel redo is started for database 'SystemDb' with worker pool size [6].
    12/31/2020 10:38:56,spid26s,Unbekannt,Parallel redo is started for database 'AblageDb' with worker pool size [6].
    12/31/2020 10:38:56,spid12s,Unbekannt,The resource database build version is 15.00.2000. This is an informational message only. No user action is required.
    12/31/2020 10:38:56,spid23s,Unbekannt,Starting up database 'msdb'.
    12/31/2020 10:38:56,spid27s,Unbekannt,Starting up database 'SystemDb'.
    12/31/2020 10:38:56,spid25s,Unbekannt,Starting up database 'ImportDb'.
    12/31/2020 10:38:56,spid26s,Unbekannt,Starting up database 'AblageDb'.
    12/31/2020 10:38:56,spid24s,Unbekannt,Starting up database 'PraxisDb'.
    12/31/2020 10:38:56,spid12s,Unbekannt,Starting up database 'mssqlsystemresource'.
    12/31/2020 10:38:55,spid20s,Unbekannt,A new instance of the full-text filter daemon host process has been successfully started.
    12/31/2020 10:38:55,Logon,Unbekannt,Login failed for user 'customer-domain\Administrator'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "msdb". [CLIENT: 192.168.100.1]
    12/31/2020 10:38:55,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:38:55,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:38:55,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:38:55,Server,Unbekannt,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/customername-servername-2.customer-domain.local:49881 ] for the SQL Server service. Windows return code: 0x200b<c/> 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.
    12/31/2020 10:38:55,Server,Unbekannt,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/customername-servername-2.customer-domain.local:DBSERVER ] for the SQL Server service. Windows return code: 0x200b<c/> 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.
    12/31/2020 10:38:55,Server,Unbekannt,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.
    12/31/2020 10:38:55,spid19s,Unbekannt,SQL Server is now ready for client connections. This is an informational message; no user action is required.
    12/31/2020 10:38:55,Server,Unbekannt,Dedicated admin connection support was established for listening locally on port 49882.
    12/31/2020 10:38:55,Server,Unbekannt,Server is listening on [ 127.0.0.1 <ipv4> 49882].
    12/31/2020 10:38:55,Server,Unbekannt,Server is listening on [ ::1 <ipv6> 49882].
    12/31/2020 10:38:55,spid19s,Unbekannt,Server local connection provider is ready to accept connection on [ \.\pipe\MSSQL$DBSERVER\sql\query ].
    12/31/2020 10:38:55,spid19s,Unbekannt,Server local connection provider is ready to accept connection on [ \.\pipe\SQLLocal\DBSERVER ].
    12/31/2020 10:38:55,spid19s,Unbekannt,Server is listening on [ 'any' <ipv4> 49881].
    12/31/2020 10:38:55,spid19s,Unbekannt,Server is listening on [ 'any' <ipv6> 49881].
    12/31/2020 10:38:55,spid19s,Unbekannt,A self-generated certificate was successfully loaded for encryption.
    12/31/2020 10:38:55,spid10s,Unbekannt,Server name is 'customername-servername-2\DBSERVER'. This is an informational message only. No user action is required.
    12/31/2020 10:38:55,spid10s,Unbekannt,SQL Trace ID 1 was started by login "sa".
    12/31/2020 10:38:55,spid10s,Unbekannt,FILESTREAM feature is enabled. This is an informational message. No user action is required.
    12/31/2020 10:38:55,spid10s,Unbekannt,FILESTREAM: effective level = 2 (remote access enabled)<c/> configured level = 2<c/> file system access share name = 'DBSERVER'.
    12/31/2020 10:38:55,spid10s,Unbekannt,FILESTREAM: connected to kernel driver RsFx0600. This is an informational message. No user action is required.
    12/31/2020 10:38:55,spid10s,Unbekannt,SQL Server Audit has started the audits. This is an informational message. No user action is required.
    12/31/2020 10:38:55,spid10s,Unbekannt,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    12/31/2020 10:38:55,Server,Unbekannt,Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.
    12/31/2020 10:38:54,Server,Unbekannt,CLR version v4.0.30319 loaded.
    12/31/2020 10:38:54,spid10s,Unbekannt,Starting up database 'master'.
    12/31/2020 10:38:54,Server,Unbekannt,clwb is selected for pmem flush operation.
    12/31/2020 10:38:54,Server,Unbekannt,Total Log Writer threads: 2. This is an informational message; no user action is required.
    12/31/2020 10:38:54,Server,Unbekannt,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.
    12/31/2020 10:38:54,Server,Unbekannt,[INFO] Created Extended Events session 'hkenginexesession'
    12/31/2020 10:38:54,Server,Unbekannt,In-Memory OLTP initialized on lowend machine.
    12/31/2020 10:38:54,Server,Unbekannt,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.
    12/31/2020 10:38:54,Server,Unbekannt,Node configuration: node 1: CPU mask: 0x0000000000000fc0:0 Active CPU mask: 0x0000000000000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    12/31/2020 10:38:54,Server,Unbekannt,Node configuration: node 0: CPU mask: 0x000000000000003f: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.
    12/31/2020 10:38:54,Server,Unbekannt,This instance of SQL Server last reported using a process ID of 3472 at 31.12.2020 10:38:48 (local) 31.12.2020 09:38:48 (UTC). This is an informational message only; no user action is required.
    12/31/2020 10:38:54,Server,Unbekannt,The maximum number of dedicated administrator connections for this instance is '1'
    12/31/2020 10:38:54,Server,Unbekannt,Query Store settings initialized with enabled = 1<c/>
    12/31/2020 10:38:54,Server,Unbekannt,Buffer pool extension is already disabled. No action is necessary.
    12/31/2020 10:38:54,Server,Unbekannt,Default collation: Latin1_General_CI_AS (Deutsch 1031)
    12/31/2020 10:38:54,Server,Unbekannt,Buffer Pool: Allocating 8388608 bytes for 5150720 hashPages.
    12/31/2020 10:38:54,Server,Unbekannt,Page exclusion bitmap is enabled.
    12/31/2020 10:38:54,Server,Unbekannt,Using conventional memory in the memory manager.
    12/31/2020 10:38:54,Server,Unbekannt,Detected 98303 MB of RAM. This is an informational message; no user action is required.
    12/31/2020 10:38:54,Server,Unbekannt,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    12/31/2020 10:38:54,Server,Unbekannt,SQL Server detected 12 sockets with 1 cores per socket and 1 logical processors per socket<c/> 12 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    12/31/2020 10:38:54,Server,Unbekannt,Command Line Startup Parameters:<nl/> -s "DBSERVER"
    12/31/2020 10:38:54,Server,Unbekannt,Registry startup parameters: <nl/> -d D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\DATA\master.mdf<nl/> -e D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\Log\ERRORLOG<nl/> -l D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\DATA\mastlog.ldf
    12/31/2020 10:38:54,Server,Unbekannt,The service account is 'NT Service\MSSQL$DBSERVER'. This is an informational message; no user action is required.
    12/31/2020 10:38:54,Server,Unbekannt,Logging SQL Server messages in file 'D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\Log\ERRORLOG'.
    12/31/2020 10:38:54,Server,Unbekannt,Authentication mode is MIXED.
    12/31/2020 10:38:54,Server,Unbekannt,System Manufacturer: 'VMware<c/> Inc.'<c/> System Model: 'VMware Virtual Platform'.
    12/31/2020 10:38:54,Server,Unbekannt,Server process ID is 10104.
    12/31/2020 10:38:54,Server,Unbekannt,All rights reserved.
    12/31/2020 10:38:54,Server,Unbekannt,(c) Microsoft Corporation.
    12/31/2020 10:38:54,Server,Unbekannt,UTC adjustment: 1:00
    12/31/2020 10:38:54,Server,Unbekannt,Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) <nl/> Sep 24 2019 13:48:23 <nl/> Copyright (C) 2019 Microsoft Corporation<nl/> Standard Edition (64-bit) on Windows Server 2016 Standard Evaluation 10.0 <X64> (Build 14393: ) (Hypervisor)
    12/31/2020 10:38:47,spid11s,Unbekannt,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
    12/31/2020 10:38:47,spid11s,Unbekannt,.NET Framework runtime has been stopped.
    12/31/2020 10:38:47,spid36s,Unbekannt,Service Broker manager has shut down.
    12/31/2020 10:38:47,spid11s,Unbekannt,SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
    12/31/2020 10:38:46,spid51,Unbekannt,Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    12/31/2020 10:38:25,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:38:25,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:38:15,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:38:15,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:37:45,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:37:45,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:37:35,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:37:35,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:37:05,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:37:05,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:36:55,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:36:55,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:36:25,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:36:25,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:36:15,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:36:15,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:35:15,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:35:15,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:35:05,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:35:05,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:34:05,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:34:05,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:33:55,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:33:55,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:32:55,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:32:55,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:32:45,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:32:45,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:31:36,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:31:36,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:31:26,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:31:26,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:31:25,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "ImportDb". [CLIENT: <local machine>]
    12/31/2020 10:31:25,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:31:14,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "ImportDb". [CLIENT: <local machine>]
    12/31/2020 10:31:14,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:31:04,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "ImportDb". [CLIENT: <local machine>]
    12/31/2020 10:31:04,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:30:54,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "ImportDb". [CLIENT: <local machine>]
    12/31/2020 10:30:54,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:30:49,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "ImportDb". [CLIENT: <local machine>]
    12/31/2020 10:30:49,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:30:39,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "ImportDb". [CLIENT: <local machine>]
    12/31/2020 10:30:39,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:30:39,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:30:39,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:30:29,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:30:29,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:30:29,spid64,Unbekannt,Using 'xplog70.dll' version '2019.150.2000' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    12/31/2020 10:30:29,spid64,Unbekannt,Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
    12/31/2020 10:30:19,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:30:19,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:30:09,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:30:09,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:30:04,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:30:04,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:29:54,Logon,Unbekannt,Login failed for user 'DbAdmin'.Ursache: Fehler beim Öffnen der explizit angegebenen Datenbank "PraxisDb". [CLIENT: <local machine>]
    12/31/2020 10:29:54,Logon,Unbekannt,Fehler: 18456<c/> Schweregrad: 14<c/> Status: 38.
    12/31/2020 10:27:27,Server,Unbekannt,Software Usage Metrics is enabled.
    12/31/2020 10:27:15,spid51,Unbekannt,Using 'xpstar.dll' version '2019.150.2000' to execute extended stored procedure 'xp_sqlagent_notify'. This is an informational message only; no user action is required.
    12/31/2020 10:27:15,spid51,Unbekannt,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
    12/31/2020 10:27:15,spid51,Unbekannt,Using 'xpsqlbot.dll' version '2019.150.2000' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    12/31/2020 10:27:15,spid51,Unbekannt,Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
    12/31/2020 10:27:15,spid11s,Unbekannt,Recovery is complete. This is an informational message only. No user action is required.
    12/31/2020 10:27:15,spid36s,Unbekannt,Service Broker manager has started.
    12/31/2020 10:27:15,spid36s,Unbekannt,The Database Mirroring endpoint is in disabled or stopped state.
    12/31/2020 10:27:15,spid36s,Unbekannt,The Service Broker endpoint is in disabled or stopped state.
    12/31/2020 10:27:15,spid12s,Unbekannt,The tempdb database has 8 data file(s).
    12/31/2020 10:27:14,spid51,Unbekannt,Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    12/31/2020 10:27:14,spid12s,Unbekannt,Starting up database 'tempdb'.
    12/31/2020 10:27:13,spid12s,Unbekannt,Clearing tempdb database.
    12/31/2020 10:27:13,spid37s,Unbekannt,Parallel redo is shutdown for database 'SystemDb' with worker pool size [6].
    12/31/2020 10:27:12,spid37s,Unbekannt,Parallel redo is started for database 'SystemDb' with worker pool size [6].
    12/31/2020 10:27:12,spid40s,Unbekannt,Parallel redo is shutdown for database 'AblageDb' with worker pool size [6].
    12/31/2020 10:27:12,spid12s,Unbekannt,Starting up database 'model'.
    12/31/2020 10:27:12,spid38s,Unbekannt,A file activation error occurred. The physical file name 'D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\DATA\PraxisDb_Filestream' may be incorrect. Diagnose and correct additional errors<c/> and retry the operation.
    12/31/2020 10:27:12,spid38s,Unbekannt,Error: 5105<c/> Severity: 16<c/> State: 14.
    12/31/2020 10:27:12,spid39s,Unbekannt,A file activation error occurred. The physical file name 'D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\DATA\ImportDb_Filestream' may be incorrect. Diagnose and correct additional errors<c/> and retry the operation.
    12/31/2020 10:27:12,spid39s,Unbekannt,Error: 5105<c/> Severity: 16<c/> State: 14.
    12/31/2020 10:27:12,spid40s,Unbekannt,Parallel redo is started for database 'AblageDb' with worker pool size [6].
    12/31/2020 10:27:12,spid39s,Unbekannt,FILESTREAM feature is disabled.
    12/31/2020 10:27:12,spid39s,Unbekannt,Error: 5591<c/> Severity: 16<c/> State: 5.
    12/31/2020 10:27:12,spid38s,Unbekannt,FILESTREAM feature is disabled.
    12/31/2020 10:27:12,spid38s,Unbekannt,Error: 5591<c/> Severity: 16<c/> State: 5.
    12/31/2020 10:27:12,spid12s,Unbekannt,The resource database build version is 15.00.2000. This is an informational message only. No user action is required.
    12/31/2020 10:27:12,spid37s,Unbekannt,Starting up database 'SystemDb'.
    12/31/2020 10:27:12,spid40s,Unbekannt,Starting up database 'AblageDb'.
    12/31/2020 10:27:12,spid12s,Unbekannt,Starting up database 'mssqlsystemresource'.
    12/31/2020 10:27:12,spid36s,Unbekannt,Starting up database 'msdb'.
    12/31/2020 10:27:12,spid39s,Unbekannt,Starting up database 'ImportDb'.
    12/31/2020 10:27:12,spid38s,Unbekannt,Starting up database 'PraxisDb'.
    12/31/2020 10:27:11,spid33s,Unbekannt,A new instance of the full-text filter daemon host process has been successfully started.
    12/31/2020 10:27:09,Server,Unbekannt,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/customername-MCS-2.customer-domain.local:49881 ] for the SQL Server service. Windows return code: 0x200b<c/> 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.
    12/31/2020 10:27:09,Server,Unbekannt,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/customername-MCS-2.customer-domain.local:DBSERVER ] for the SQL Server service. Windows return code: 0x200b<c/> 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.
    12/31/2020 10:27:09,Server,Unbekannt,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.
    12/31/2020 10:27:09,spid32s,Unbekannt,SQL Server is now ready for client connections. This is an informational message; no user action is required.
    12/31/2020 10:27:09,Server,Unbekannt,Dedicated admin connection support was established for listening locally on port 49882.
    12/31/2020 10:27:09,Server,Unbekannt,Server is listening on [ 127.0.0.1 <ipv4> 49882].
    12/31/2020 10:27:09,Server,Unbekannt,Server is listening on [ ::1 <ipv6> 49882].
    12/31/2020 10:27:09,spid32s,Unbekannt,Server local connection provider is ready to accept connection on [ \.\pipe\MSSQL$DBSERVER\sql\query ].
    12/31/2020 10:27:09,spid32s,Unbekannt,Server local connection provider is ready to accept connection on [ \.\pipe\SQLLocal\DBSERVER ].
    12/31/2020 10:27:09,spid32s,Unbekannt,Server is listening on [ 'any' <ipv4> 49881].
    12/31/2020 10:27:09,spid32s,Unbekannt,Server is listening on [ 'any' <ipv6> 49881].
    12/31/2020 10:27:09,spid32s,Unbekannt,A self-generated certificate was successfully loaded for encryption.
    12/31/2020 10:27:09,spid11s,Unbekannt,Server name is 'customername-MCS-2\DBSERVER'. This is an informational message only. No user action is required.
    12/31/2020 10:27:09,spid11s,Unbekannt,SQL Trace ID 1 was started by login "sa".
    12/31/2020 10:27:08,spid11s,Unbekannt,A failure occurred while FILESTREAM configuration was being changed or applied. For more information<c/> see the SQL Server error log.
    12/31/2020 10:27:08,spid11s,Unbekannt,FILESTREAM: effective level = 0<c/> configured level = 2.
    12/31/2020 10:27:08,spid11s,Unbekannt,FILESTREAM: failed to connect to kernel driver RsFx0600.<nl/><{1038F43D-3391-45F7-B1B3-BADF26459429}>Failed to initialize CFsaShareFilter: Error 0x80070015 (-2147024875)
    12/31/2020 10:27:08,spid11s,Unbekannt,SQL Server Audit has started the audits. This is an informational message. No user action is required.<nl/><{942949C8-7DFD-45B9-BA7B-AC5B0D5D4FB2}>RsFxMgmtInitialize failed (the RsFx device is not ready.): Error 0x80070015 (-2147024875)
    12/31/2020 10:27:08,spid11s,Unbekannt,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    12/31/2020 10:27:07,Server,Unbekannt,Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319.
    12/31/2020 10:27:07,spid11s,Unbekannt,Starting up database 'master'.
    12/31/2020 10:27:07,Server,Unbekannt,clwb is selected for pmem flush operation.
    12/31/2020 10:27:07,Server,Unbekannt,Total Log Writer threads: 2. This is an informational message; no user action is required.
    12/31/2020 10:27:07,Server,Unbekannt,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.
    12/31/2020 10:27:07,Server,Unbekannt,[INFO] Created Extended Events session 'hkenginexesession'
    12/31/2020 10:27:07,Server,Unbekannt,CLR version v4.0.30319 loaded.
    12/31/2020 10:27:07,Server,Unbekannt,In-Memory OLTP initialized on lowend machine.
    12/31/2020 10:27:07,Server,Unbekannt,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.
    12/31/2020 10:27:06,Server,Unbekannt,Node configuration: node 1: CPU mask: 0x0000000000000fc0:0 Active CPU mask: 0x0000000000000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    12/31/2020 10:27:06,Server,Unbekannt,Node configuration: node 0: CPU mask: 0x000000000000003f: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.
    12/31/2020 10:27:06,Server,Unbekannt,This instance of SQL Server last reported using a process ID of 3544 at 31.12.2020 10:25:46 (local) 31.12.2020 09:25:46 (UTC). This is an informational message only; no user action is required.
    12/31/2020 10:27:06,Server,Unbekannt,The maximum number of dedicated administrator connections for this instance is '1'
    12/31/2020 10:27:06,Server,Unbekannt,Query Store settings initialized with enabled = 1<c/>
    12/31/2020 10:27:04,Server,Unbekannt,Buffer pool extension is already disabled. No action is necessary.
    12/31/2020 10:27:04,Server,Unbekannt,Default collation: Latin1_General_CI_AS (Deutsch 1031)
    12/31/2020 10:27:03,Server,Unbekannt,Buffer Pool: Allocating 8388608 bytes for 5150720 hashPages.
    12/31/2020 10:27:03,Server,Unbekannt,Page exclusion bitmap is enabled.
    12/31/2020 10:27:03,Server,Unbekannt,Using conventional memory in the memory manager.
    12/31/2020 10:27:03,Server,Unbekannt,Detected 98303 MB of RAM. This is an informational message; no user action is required.
    12/31/2020 10:27:03,Server,Unbekannt,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    12/31/2020 10:27:03,Server,Unbekannt,SQL Server detected 12 sockets with 1 cores per socket and 1 logical processors per socket<c/> 12 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    12/31/2020 10:27:03,Server,Unbekannt,Command Line Startup Parameters:<nl/> -s "DBSERVER"
    12/31/2020 10:27:03,Server,Unbekannt,Registry startup parameters: <nl/> -d D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\DATA\master.mdf<nl/> -e D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\Log\ERRORLOG<nl/> -l D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\DATA\mastlog.ldf
    12/31/2020 10:27:03,Server,Unbekannt,The service account is 'NT Service\MSSQL$DBSERVER'. This is an informational message; no user action is required.
    12/31/2020 10:27:03,Server,Unbekannt,Logging SQL Server messages in file 'D:\SQL_Database\MSSQL15.DBSERVER\MSSQL\Log\ERRORLOG'.
    12/31/2020 10:27:03,Server,Unbekannt,Authentication mode is MIXED.
    12/31/2020 10:27:03,Server,Unbekannt,System Manufacturer: 'VMware<c/> Inc.'<c/> System Model: 'VMware Virtual Platform'.
    12/31/2020 10:27:03,Server,Unbekannt,Server process ID is 3472.
    12/31/2020 10:27:03,Server,Unbekannt,All rights reserved.
    12/31/2020 10:27:03,Server,Unbekannt,(c) Microsoft Corporation.
    12/31/2020 10:27:03,Server,Unbekannt,UTC adjustment: 1:00
    12/31/2020 10:27:02,Server,Unbekannt,Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) <nl/> Sep 24 2019 13:48:23 <nl/> Copyright (C) 2019 Microsoft Corporation<nl/> Standard Edition (64-bit) on Windows Ser


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.