Forum Użytkownikow Subiekt GT
InsERT GT => Subiekt GT => Wątek zaczęty przez: NAAP w Wrzesień 26, 2022, 15:14:40
-
Dzień dobry,
potrzebuję zarchiwizować bazę Subiet GT 1.72 SP2 uruchomionego na SQL 2017 14.0.2042.3 (RTM).
Wszystko działało i nagle przestało działać. ;-) Tak konkretnie to przestało działać 10 dni temu ale ja nie miałem okazji tego wcześniej zauważyć a powiedziano mi o problemie dzisiaj.
Ciężko mi sięgnąć pamięcią co konkretnie „mogło się dziać” 16 IX, ale dopuszczam mniej lub bardziej standardowe czyszczenie systemu i usuwanie teoretycznie niepotrzebnych programów.
Obecnie na liście zainstalowanych znajdują się:
- Browser for SQL Server 2017,
- Microsoft ODBC Driver 11 for SQL Server
- Microsoft ODBC Driver 13 for SQL Server
- Microsoft ODBC Driver 17 for SQL Server
- Microsoft OLE DB Driver 11 for SQL Server
- Microsoft SQL Server 2012 Native Client
- Microsoft SQL Server 2014
- Microsoft SQL Server 2014 Setup
- Microsoft SQL Server 2014 Transacr-SQL ScriptDom
- Microsoft SQL Server 2017
- Microsoft SQL Server 2017 Setup
- Microsoft SQL Server 2017 T-SQL Language Services
- Microsoft SQL Server Compact 3.5 SP2 ENU
- Microsoft SQL Server Compact 3.5 SP2 x64 ENU
- Microsoft SQL Server Management Studio 18.12.1
- Microsoft VSS Writer for SQL Server 2017
Obawiam się, że kiedyś było znacznie więcej „SQL XYZ backward compatibility”.
Z samym serwerem jest raczej wszystko ok - tak wnoszę po braku błędów po uruchomieniu „system config. checker” w SQL Server Installation Center.
Ostatecznie nie wiem jak się do sprawy zabrać -> próba archiwizacji mówi o tym, że szczegóły błędu można znaleźć w logu serwera.
Odpalam więc program serwisowy a tam bez konkretów. Rzuca się w oczy tylko problem z Bridge’em ale to raczej bez związku:
2022-09-26 14:40:34 Logon Error: 18456, Severity: 14, State: 38.
2022-09-26 14:40:34 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database 'iai_shop_bridge'. [CLIENT: ::1]
2022-09-26 14:40:35 spid17s A new instance of the full-text filter daemon host process has been successfully started.
2022-09-26 14:40:35 spid21s Starting up database 'msdb'.
2022-09-26 14:40:35 spid22s Starting up database 'iai_shop_bridge'.
2022-09-26 14:40:35 spid12s Starting up database 'mssqlsystemresource'.
2022-09-26 14:40:35 spid12s The resource database build version is 14.00.2042. This is an informational message only. No user action is required.
2022-09-26 14:40:35 spid22s Parallel redo is started for database 'iai_shop_bridge' with worker pool size [2].
2022-09-26 14:40:35 spid12s Starting up database 'model'.
2022-09-26 14:40:35 spid22s Parallel redo is shutdown for database 'iai_shop_bridge' with worker pool size [2].
2022-09-26 14:40:36 spid12s Polybase feature disabled.
2022-09-26 14:40:36 spid12s Clearing tempdb database.
2022-09-26 14:40:36 spid12s Starting up database 'tempdb'.
2022-09-26 14:40:36 spid18s The Service Broker endpoint is in disabled or stopped state.
2022-09-26 14:40:36 spid18s The Database Mirroring endpoint is in disabled or stopped state.
2022-09-26 14:40:36 spid18s Service Broker manager has started.
2022-09-26 14:40:36 spid6s Recovery is complete. This is an informational message only. No user action is required.
2022-09-26 14:40:44 spid51 Starting up database 'iai_shop_bridge'.
2022-09-26 14:40:44 spid51 Parallel redo is started for database 'iai_shop_bridge' with worker pool size [2].
2022-09-26 14:40:44 spid51 Parallel redo is shutdown for database 'iai_shop_bridge' with worker pool size [2].
2022-09-26 14:45:33 spid57 Using 'dbghelp.dll' version '4.0.5'
2022-09-26 14:45:55 spid57 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2022-09-26 14:45:55 spid57 Using 'xplog70.dll' version '2017.140.2042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2022-09-26 14:45:55 spid57 Starting up database 'iai_downloader'.
2022-09-26 14:45:55 spid57 Parallel redo is started for database 'iai_downloader' with worker pool size [2].
2022-09-26 14:45:55 spid57 Parallel redo is shutdown for database 'iai_downloader' with worker pool size [2].
2022-09-26 14:45:55 spid57 Starting up database 'RedWire'.
2022-09-26 14:45:56 spid57 Parallel redo is started for database 'RedWire' with worker pool size [2].
2022-09-26 14:45:56 spid57 Parallel redo is shutdown for database 'RedWire' with worker pool size [2].
2022-09-26 14:46:05 spid57 Starting up database 'iai_downloader'.
2022-09-26 14:46:05 spid57 Parallel redo is started for database 'iai_downloader' with worker pool size [2].
2022-09-26 14:46:05 spid57 Parallel redo is shutdown for database 'iai_downloader' with worker pool size [2].
2022-09-26 14:46:43 spid64 Starting up database 'iai_downloader'.
2022-09-26 14:46:43 spid64 Parallel redo is started for database 'iai_downloader' with worker pool size [2].
2022-09-26 14:46:43 spid64 Parallel redo is shutdown for database 'iai_downloader' with worker pool size [2].
2022-09-26 14:51:25 spid81 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2022-09-26 14:51:25 spid81 Using 'xpstar.dll' version '2017.140.2042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2022-09-26 14:51:26 spid81 Starting up database 'iai_downloader'.
2022-09-26 14:51:26 spid81 Parallel redo is started for database 'iai_downloader' with worker pool size [2].
2022-09-26 14:51:26 spid81 Parallel redo is shutdown for database 'iai_downloader' with worker pool size [2].
Z góry dziękuję za pomoc w naprawieniu bałaganu. ;-)