После перезагрузки не запускается служба SQLSERVER

@czech711 · Регистрация: 21.07.2016

Студворк — интернет-сервис помощи студентам

Добрый день, нужна помощь, накатилось виндовое обновления, сервак перезагрузился, после чего перестала запускаться служба SQLSERVER. К сожалению малая квалификация в этом вопросе не дает его решить. Лог прилагаю. Кто нибудь готов помочь???

2016-07-21 21:46:30.90 spid8s CHECKDB for database 'master' finished without errors on 2016-07-21 00:30:03.753 (local time). This is an informational message only; no user action is required.
2016-07-21 21:46:30.90 spid8s Resource governor reconfiguration succeeded.
2016-07-21 21:46:30.90 spid8s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2016-07-21 21:46:30.90 spid8s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2016-07-21 21:46:31.08 spid8s SQL Trace ID 1 was started by login "sa".
2016-07-21 21:46:31.09 spid8s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2016-07-21 21:46:31.10 spid18s Starting up database 'msdb'.
2016-07-21 21:46:31.10 spid19s Starting up database 'buh_oilsg'.
2016-07-21 21:46:31.10 spid20s Starting up database 'zup_oilsg'.
2016-07-21 21:46:31.10 spid11s Starting up database 'mssqlsystemresource'.
2016-07-21 21:46:31.10 spid21s Starting up database 'zup_nt-service'.
2016-07-21 21:46:31.10 spid22s Starting up database 'upr_torg_veles'.
2016-07-21 21:46:31.10 spid23s Starting up database 'buh_veles'.
2016-07-21 21:46:31.10 spid24s Starting up database 'buh_solidan'.
2016-07-21 21:46:31.10 spid28s Starting up database 'veles2016'.
2016-07-21 21:46:31.10 spid25s Starting up database 'torg_shtrih'.
2016-07-21 21:46:31.10 spid26s Starting up database 'zup_solidan'.
2016-07-21 21:46:31.10 spid27s Starting up database 'zup_veles'.
2016-07-21 21:46:31.22 spid15s A self-generated certificate was successfully loaded for encryption.
2016-07-21 21:46:31.22 spid15s Server is listening on [ 'any' <ipv6> 1433].
2016-07-21 21:46:31.22 spid15s Server is listening on [ 'any' <ipv4> 1433].
2016-07-21 21:46:31.22 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2016-07-21 21:46:31.22 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2016-07-21 21:46:31.23 Server Server is listening on [ ::1 <ipv6> 1434].
2016-07-21 21:46:31.23 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2016-07-21 21:46:31.23 Server Dedicated admin connection support was established for listening locally on port 1434.
2016-07-21 21:46:31.23 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.
2016-07-21 21:46:31.23 spid15s SQL Server is now ready for client connections. This is an informational message; no user action is required.
2016-07-21 21:46:31.23 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQLServer ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. 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.
2016-07-21 21:46:31.23 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQLServer:1433 ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. 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.
2016-07-21 21:46:31.38 spid11s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\ms sqlsystemresource.mdf.
2016-07-21 21:46:31.63 spid11s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2016-07-21 21:46:31.82 spid11s Stack Signature for the dump is 0x0000000000000000
2016-07-21 21:46:32.82 spid11s External dump process return code 0x20000001.
External dump process returned no errors.

@invm · 21.07.2016, 23:13

Весь лог покажите.

@czech711 · 21.07.2016, 23:52 **[ТС]**

не могу личные сообщения писать. можно мыло ваше или мне напишите vkotra@mail.ru

Добавлено через 9 минут
2016-07-21 23:27:12.07 Server Microsoft SQL Server 2014 - 12.0.4213.0 (X64)
Jun 9 2015 12:06:16
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

2016-07-21 23:27:12.07 Server UTC adjustment: 4:00
2016-07-21 23:27:12.07 Server (c) Microsoft Corporation.
2016-07-21 23:27:12.07 Server All rights reserved.
2016-07-21 23:27:12.07 Server Server process ID is 1640.
2016-07-21 23:27:12.07 Server System Manufacturer: 'HP', System Model: 'ProLiant ML110 G6'.
2016-07-21 23:27:12.07 Server Authentication mode is MIXED.
2016-07-21 23:27:12.07 Server Logging SQL Server messages in file 'E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\L og\ERRORLOG'.
2016-07-21 23:27:12.07 Server The service account is 'SQLSERVER\Администратор'. This is an informational message; no user action is required.
2016-07-21 23:27:12.07 Server Registry startup parameters:
-d E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\master.mdf
-e E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\Lo g\ERRORLOG
-l E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\mastlog.ldf
2016-07-21 23:27:12.07 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2016-07-21 23:27:12.35 Server SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2016-07-21 23:27:12.35 Server SQL Server is starting at high priority base (=13). This is an informational message only. No user action is required.
2016-07-21 23:27:12.35 Server Detected 8183 MB of RAM. This is an informational message; no user action is required.
2016-07-21 23:27:12.35 Server Using conventional memory in the memory manager.
2016-07-21 23:27:12.44 Server Default collation: Cyrillic_General_CI_AS (русский 1049)
2016-07-21 23:27:12.48 Server The maximum number of dedicated administrator connections for this instance is '1'

Добавлено через 5 минут
вообще пересмотрел, там 6 файлов с логами. В начале указал весь текст файла "errorlog"

Добавлено через 20 минут
invm, может еще что нужно что бы картина открылась. так как для меня sql...

@invm · 22.07.2016, 00:01

Сообщение от czech711

В начале указал весь текст файла "errorlog"

Был бы весь - там была бы версия сервера и т.п.

Наличие сообщений:

2016-07-21 21:46:31.38 spid11s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\ms sqlsystemresource.mdf.
2016-07-21 21:46:31.63 spid11s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2016-07-21 21:46:31.82 spid11s Stack Signature for the dump is 0x0000000000000000
2016-07-21 21:46:32.82 spid11s External dump process return code 0x20000001.
External dump process returned no errors.

Наводит на мысль о какой-то внутренней ошибке. Поэтому для начала попробуйте обновить SQL Server до SP2.
Не забудьте предварительно сделать резервные копии.

@czech711 · 22.07.2016, 00:05 **[ТС]**

invm, вы фрилансом не занимаетесь? просто нужно срочно... все спят... разбираться буду до утра сам

@invm · 22.07.2016, 00:32

czech711, нет, не занимаюсь. И тоже уже почти сплю.

Посмотрите еще, что есть в логах ОС.

@czech711 · 22.07.2016, 09:49 **[ТС]**

sqlservr (3348) Файловая система сообщает, что файл журнала на C:\Windows\system32\LogFiles\Sum\ содержит сектор размером 4194304, который не поддерживается, поэтому вместо него используется сектор размером 4096. Это может привести к потере устойчивости транзакции.

Добавлено через 33 минуты
sqlservr (3800) Ядро СУБД отсоединило базу данных (1, C:\Windows\system32\LogFiles\Sum\SystemI dentity.mdb). (Время=0*с)

Последовательность внутренней синхронизации: [1] 0.000, [2] 0.000, [3] 0.000, [4] 0.000, [5] 0.000, [6] 0.062, [7] 0.000, [8] 0.000, [9] 0.016, [10] 0.016, [11] 0.031, [12] 0.015.
Восстановленный кэш: 0

Добавлено через 23 минуты
2016-07-22 07:21:33.59 Server Microsoft SQL Server 2014 - 12.0.4213.0 (X64)
Jun 9 2015 12:06:16
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

2016-07-22 07:21:33.59 Server UTC adjustment: 4:00
2016-07-22 07:21:33.59 Server (c) Microsoft Corporation.
2016-07-22 07:21:33.59 Server All rights reserved.
2016-07-22 07:21:33.59 Server Server process ID is 3780.
2016-07-22 07:21:33.59 Server System Manufacturer: 'HP', System Model: 'ProLiant ML110 G6'.
2016-07-22 07:21:33.59 Server Authentication mode is MIXED.
2016-07-22 07:21:33.59 Server Logging SQL Server messages in file 'E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\L og\ERRORLOG'.
2016-07-22 07:21:33.59 Server The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
2016-07-22 07:21:33.59 Server Registry startup parameters:
-d E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\master.mdf
-e E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\Lo g\ERRORLOG
-l E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\mastlog.ldf
2016-07-22 07:21:33.59 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2016-07-22 07:21:33.86 Server SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2016-07-22 07:21:33.86 Server SQL Server is starting at high priority base (=13). This is an informational message only. No user action is required.
2016-07-22 07:21:33.86 Server Detected 8183 MB of RAM. This is an informational message; no user action is required.
2016-07-22 07:21:33.86 Server Using conventional memory in the memory manager.
2016-07-22 07:21:33.94 Server Default collation: Cyrillic_General_CI_AS (русский 1049)
2016-07-22 07:21:33.98 Server The maximum number of dedicated administrator connections for this instance is '1'
2016-07-22 07:21:33.98 Server This instance of SQL Server last reported using a process ID of 3800 at 22.07.2016 7:00:58 (local) 22.07.2016 3:00:58 (UTC). This is an informational message only; no user action is required.
2016-07-22 07:21:33.98 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.
2016-07-22 07:21:33.99 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.
2016-07-22 07:21:34.02 spid8s Starting up database 'master'.
2016-07-22 07:21:34.08 spid8s 43 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2016-07-22 07:21:34.08 Server CLR version v4.0.30319 loaded.
2016-07-22 07:21:34.12 spid8s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2016-07-22 07:21:34.15 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4. 0.30319\.
2016-07-22 07:21:34.20 spid8s CHECKDB for database 'master' finished without errors on 2016-07-21 00:30:03.753 (local time). This is an informational message only; no user action is required.
2016-07-22 07:21:34.20 spid8s Resource governor reconfiguration succeeded.
2016-07-22 07:21:34.20 spid8s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2016-07-22 07:21:34.21 spid8s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2016-07-22 07:21:34.38 spid8s SQL Trace ID 1 was started by login "sa".
2016-07-22 07:21:34.40 spid8s Server name is 'SQLSERVER'. This is an informational message only. No user action is required.
2016-07-22 07:21:34.40 spid19s Starting up database 'buh_oilsg'.
2016-07-22 07:21:34.40 spid18s Starting up database 'msdb'.
2016-07-22 07:21:34.40 spid20s Starting up database 'zup_oilsg'.
2016-07-22 07:21:34.40 spid11s Starting up database 'mssqlsystemresource'.
2016-07-22 07:21:34.40 spid21s Starting up database 'zup_nt-service'.
2016-07-22 07:21:34.40 spid23s Starting up database 'buh_veles'.
2016-07-22 07:21:34.41 spid22s Starting up database 'upr_torg_veles'.
2016-07-22 07:21:34.41 spid24s Starting up database 'buh_solidan'.
2016-07-22 07:21:34.41 spid25s Starting up database 'torg_shtrih'.
2016-07-22 07:21:34.42 spid26s Starting up database 'zup_solidan'.
2016-07-22 07:21:34.42 spid27s Starting up database 'zup_veles'.
2016-07-22 07:21:34.53 spid15s A self-generated certificate was successfully loaded for encryption.
2016-07-22 07:21:34.53 spid15s Server is listening on [ 'any' <ipv6> 1433].
2016-07-22 07:21:34.53 spid15s Server is listening on [ 'any' <ipv4> 1433].
2016-07-22 07:21:34.53 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2016-07-22 07:21:34.53 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2016-07-22 07:21:34.54 Server Server is listening on [ ::1 <ipv6> 1434].
2016-07-22 07:21:34.54 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2016-07-22 07:21:34.54 Server Dedicated admin connection support was established for listening locally on port 1434.
2016-07-22 07:21:34.54 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.
2016-07-22 07:21:34.54 spid15s SQL Server is now ready for client connections. This is an informational message; no user action is required.
2016-07-22 07:21:34.54 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQLServer ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. 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.
2016-07-22 07:21:34.54 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQLServer:1433 ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. 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.
2016-07-22 07:21:34.60 spid28s Starting up database 'veles2016'.
2016-07-22 07:21:34.65 spid25s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file c:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\torg_shtrih_log.ldf.
2016-07-22 07:21:35.17 spid11s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling)
2016-07-22 07:21:35.17 spid11s Stack Signature for the dump is 0x0000000000000000
2016-07-22 07:21:35.20 spid11s [INFO] Identity Begin End | State Result Error Speculate Prepared LazyCommit ReadOnly | Transaction Database ThreadId | ReadSet WriteSet ScanSet Savepoint LogSizeRq | CommitDep TotalComm Dependent 0 Dependent 1 Dependent 2 Dependent 3 Dependent 4 Dependent 5 Dependent 6 Dependent 7 | Area Location |
2016-07-22 07:21:35.57 Server Software Usage Metrics is enabled.
2016-07-22 07:21:36.25 spid11s External dump process return code 0x20000001.
External dump process returned no errors.

Добавлено через 3 часа 21 минуту
Устранил удалением обновлений винды, все заработало

Новые блоги и статьи Все статьи Все блоги /
Модель микоризы: классовый агентный подход anaschu 02.01.2026 Раньше это было два гриба и бактерия. Теперь три гриба, растение. И на уровне агентов добавится между грибами или бактериями взаимодействий. До того я пробовал подход через многомерные массивы,. . .	Учёным и волонтёрам проекта «Einstein@home» удалось обнаружить четыре гамма-лучевых пульсара в джете Млечного Пути Programma_Boinc 01.01.2026 Учёным и волонтёрам проекта «Einstein@home» удалось обнаружить четыре гамма-лучевых пульсара в джете Млечного Пути Сочетание глобально распределённой вычислительной мощности и инновационных. . .	Советы по крайней бережливости. Внимание, это ОЧЕНЬ длинный пост. Programma_Boinc 28.12.2025 Советы по крайней бережливости. Внимание, это ОЧЕНЬ длинный пост. Налог на собак: https:/ / ********/ gallery/ V06K53e Финансовый отчет в Excel: https:/ / ********/ gallery/ bKBkQFf Пост отсюда. . .	Кто-нибудь знает, где можно бесплатно получить настольный компьютер или ноутбук? США. Programma_Boinc 26.12.2025 Нашел на реддите интересную статью под названием Anyone know where to get a free Desktop or Laptop? Ниже её машинный перевод. После долгих разбирательств я наконец-то вернула себе. . .	Thinkpad X220 Tablet — это лучший бюджетный ноутбук для учёбы, точка. Programma_Boinc 23.12.2025 Рецензия / Мнение/ Перевод Нашел на реддите интересную статью под названием The Thinkpad X220 Tablet is the best budget school laptop period . Ниже её машинный перевод. Thinkpad X220 Tablet —. . .
PhpStorm 2025.3: WSL Terminal всегда стартует в ~ and_y87 14.12.2025 PhpStorm 2025. 3: WSL Terminal всегда стартует в ~ (home), игнорируя директорию проекта Симптом: После обновления до PhpStorm 2025. 3 встроенный терминал WSL открывается в домашней директории. . .	Как объединить две одинаковые БД Access с разными данными VikBal 11.12.2025 Помогите пожалуйста !! Как объединить 2 одинаковые БД Access с разными данными.	Новый ноутбук volvo 07.12.2025 Всем привет. По скидке в "черную пятницу" взял себе новый ноутбук Lenovo ThinkBook 16 G7 на Амазоне: Ryzen 5 7533HS 64 Gb DDR5 1Tb NVMe 16" Full HD Display Win11 Pro	Музыка, написанная Искусственным Интеллектом volvo 04.12.2025 Всем привет. Некоторое время назад меня заинтересовало, что уже умеет ИИ в плане написания музыки для песен, и, собственно, исполнения этих самых песен. Стихов у нас много, уже вышли 4 книги, еще 3. . .	От async/await к виртуальным потокам в Python IndentationError 23.11.2025 Армин Ронахер поставил под сомнение async/ await. Создатель Flask заявляет: цветные функции - провал, виртуальные потоки - решение. Не threading-динозавры, а новое поколение лёгких потоков. Откат?. . .

@czech711 0 / 0 / 0 Регистрация: 21.07.2016 Сообщений: 8

	После перезагрузки не запускается служба SQLSERVER 21.07.2016, 22:52. Показов 7645. Ответов 6 Метки нет (Все метки) Добрый день, нужна помощь, накатилось виндовое обновления, сервак перезагрузился, после чего перестала запускаться служба SQLSERVER. К сожалению малая квалификация в этом вопросе не дает его решить. Лог прилагаю. Кто нибудь готов помочь??? 2016-07-21 21:46:30.90 spid8s CHECKDB for database 'master' finished without errors on 2016-07-21 00:30:03.753 (local time). This is an informational message only; no user action is required. 2016-07-21 21:46:30.90 spid8s Resource governor reconfiguration succeeded. 2016-07-21 21:46:30.90 spid8s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2016-07-21 21:46:30.90 spid8s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2016-07-21 21:46:31.08 spid8s SQL Trace ID 1 was started by login "sa". 2016-07-21 21:46:31.09 spid8s Server name is 'SQLSERVER'. This is an informational message only. No user action is required. 2016-07-21 21:46:31.10 spid18s Starting up database 'msdb'. 2016-07-21 21:46:31.10 spid19s Starting up database 'buh_oilsg'. 2016-07-21 21:46:31.10 spid20s Starting up database 'zup_oilsg'. 2016-07-21 21:46:31.10 spid11s Starting up database 'mssqlsystemresource'. 2016-07-21 21:46:31.10 spid21s Starting up database 'zup_nt-service'. 2016-07-21 21:46:31.10 spid22s Starting up database 'upr_torg_veles'. 2016-07-21 21:46:31.10 spid23s Starting up database 'buh_veles'. 2016-07-21 21:46:31.10 spid24s Starting up database 'buh_solidan'. 2016-07-21 21:46:31.10 spid28s Starting up database 'veles2016'. 2016-07-21 21:46:31.10 spid25s Starting up database 'torg_shtrih'. 2016-07-21 21:46:31.10 spid26s Starting up database 'zup_solidan'. 2016-07-21 21:46:31.10 spid27s Starting up database 'zup_veles'. 2016-07-21 21:46:31.22 spid15s A self-generated certificate was successfully loaded for encryption. 2016-07-21 21:46:31.22 spid15s Server is listening on [ 'any' <ipv6> 1433]. 2016-07-21 21:46:31.22 spid15s Server is listening on [ 'any' <ipv4> 1433]. 2016-07-21 21:46:31.22 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. 2016-07-21 21:46:31.22 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ]. 2016-07-21 21:46:31.23 Server Server is listening on [ ::1 <ipv6> 1434]. 2016-07-21 21:46:31.23 Server Server is listening on [ 127.0.0.1 <ipv4> 1434]. 2016-07-21 21:46:31.23 Server Dedicated admin connection support was established for listening locally on port 1434. 2016-07-21 21:46:31.23 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. 2016-07-21 21:46:31.23 spid15s SQL Server is now ready for client connections. This is an informational message; no user action is required. 2016-07-21 21:46:31.23 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQLServer ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. 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. 2016-07-21 21:46:31.23 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQLServer:1433 ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. 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. 2016-07-21 21:46:31.38 spid11s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\ms sqlsystemresource.mdf. 2016-07-21 21:46:31.63 spid11s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling) 2016-07-21 21:46:31.82 spid11s Stack Signature for the dump is 0x0000000000000000 2016-07-21 21:46:32.82 spid11s External dump process return code 0x20000001. External dump process returned no errors. 0

@invm 3614 / 2135 / 756 Регистрация: 02.06.2013 Сообщений: 5,169
	21.07.2016, 23:13
	Весь лог покажите. 0

@czech711 0 / 0 / 0 Регистрация: 21.07.2016 Сообщений: 8
	21.07.2016, 23:52 [ТС]
	не могу личные сообщения писать. можно мыло ваше или мне напишите vkotra@mail.ru Добавлено через 9 минут 2016-07-21 23:27:12.07 Server Microsoft SQL Server 2014 - 12.0.4213.0 (X64) Jun 9 2015 12:06:16 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) 2016-07-21 23:27:12.07 Server UTC adjustment: 4:00 2016-07-21 23:27:12.07 Server (c) Microsoft Corporation. 2016-07-21 23:27:12.07 Server All rights reserved. 2016-07-21 23:27:12.07 Server Server process ID is 1640. 2016-07-21 23:27:12.07 Server System Manufacturer: 'HP', System Model: 'ProLiant ML110 G6'. 2016-07-21 23:27:12.07 Server Authentication mode is MIXED. 2016-07-21 23:27:12.07 Server Logging SQL Server messages in file 'E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\L og\ERRORLOG'. 2016-07-21 23:27:12.07 Server The service account is 'SQLSERVER\Администратор'. This is an informational message; no user action is required. 2016-07-21 23:27:12.07 Server Registry startup parameters: -d E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\master.mdf -e E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\Lo g\ERRORLOG -l E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\mastlog.ldf 2016-07-21 23:27:12.07 Server Command Line Startup Parameters: -s "MSSQLSERVER" 2016-07-21 23:27:12.35 Server SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required. 2016-07-21 23:27:12.35 Server SQL Server is starting at high priority base (=13). This is an informational message only. No user action is required. 2016-07-21 23:27:12.35 Server Detected 8183 MB of RAM. This is an informational message; no user action is required. 2016-07-21 23:27:12.35 Server Using conventional memory in the memory manager. 2016-07-21 23:27:12.44 Server Default collation: Cyrillic_General_CI_AS (русский 1049) 2016-07-21 23:27:12.48 Server The maximum number of dedicated administrator connections for this instance is '1' Добавлено через 5 минут вообще пересмотрел, там 6 файлов с логами. В начале указал весь текст файла "errorlog" Добавлено через 20 минут invm, может еще что нужно что бы картина открылась. так как для меня sql... 0

@czech711 0 / 0 / 0 Регистрация: 21.07.2016 Сообщений: 8
	22.07.2016, 00:05 [ТС]
	invm, вы фрилансом не занимаетесь? просто нужно срочно... все спят... разбираться буду до утра сам 0

@invm 3614 / 2135 / 756 Регистрация: 02.06.2013 Сообщений: 5,169
	22.07.2016, 00:32
	czech711, нет, не занимаюсь. И тоже уже почти сплю. Посмотрите еще, что есть в логах ОС. 0

@czech711 0 / 0 / 0 Регистрация: 21.07.2016 Сообщений: 8
	22.07.2016, 09:49 [ТС]
	sqlservr (3348) Файловая система сообщает, что файл журнала на C:\Windows\system32\LogFiles\Sum\ содержит сектор размером 4194304, который не поддерживается, поэтому вместо него используется сектор размером 4096. Это может привести к потере устойчивости транзакции. Добавлено через 33 минуты sqlservr (3800) Ядро СУБД отсоединило базу данных (1, C:\Windows\system32\LogFiles\Sum\SystemI dentity.mdb). (Время=0с) Последовательность внутренней синхронизации: [1] 0.000, [2] 0.000, [3] 0.000, [4] 0.000, [5] 0.000, [6] 0.062, [7] 0.000, [8] 0.000, [9] 0.016, [10] 0.016, [11] 0.031, [12] 0.015. Восстановленный кэш: 0 Добавлено через 23 минуты* 2016-07-22 07:21:33.59 Server Microsoft SQL Server 2014 - 12.0.4213.0 (X64) Jun 9 2015 12:06:16 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) 2016-07-22 07:21:33.59 Server UTC adjustment: 4:00 2016-07-22 07:21:33.59 Server (c) Microsoft Corporation. 2016-07-22 07:21:33.59 Server All rights reserved. 2016-07-22 07:21:33.59 Server Server process ID is 3780. 2016-07-22 07:21:33.59 Server System Manufacturer: 'HP', System Model: 'ProLiant ML110 G6'. 2016-07-22 07:21:33.59 Server Authentication mode is MIXED. 2016-07-22 07:21:33.59 Server Logging SQL Server messages in file 'E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\L og\ERRORLOG'. 2016-07-22 07:21:33.59 Server The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required. 2016-07-22 07:21:33.59 Server Registry startup parameters: -d E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\master.mdf -e E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\Lo g\ERRORLOG -l E:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\mastlog.ldf 2016-07-22 07:21:33.59 Server Command Line Startup Parameters: -s "MSSQLSERVER" 2016-07-22 07:21:33.86 Server SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required. 2016-07-22 07:21:33.86 Server SQL Server is starting at high priority base (=13). This is an informational message only. No user action is required. 2016-07-22 07:21:33.86 Server Detected 8183 MB of RAM. This is an informational message; no user action is required. 2016-07-22 07:21:33.86 Server Using conventional memory in the memory manager. 2016-07-22 07:21:33.94 Server Default collation: Cyrillic_General_CI_AS (русский 1049) 2016-07-22 07:21:33.98 Server The maximum number of dedicated administrator connections for this instance is '1' 2016-07-22 07:21:33.98 Server This instance of SQL Server last reported using a process ID of 3800 at 22.07.2016 7:00:58 (local) 22.07.2016 3:00:58 (UTC). This is an informational message only; no user action is required. 2016-07-22 07:21:33.98 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. 2016-07-22 07:21:33.99 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. 2016-07-22 07:21:34.02 spid8s Starting up database 'master'. 2016-07-22 07:21:34.08 spid8s 43 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required. 2016-07-22 07:21:34.08 Server CLR version v4.0.30319 loaded. 2016-07-22 07:21:34.12 spid8s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required. 2016-07-22 07:21:34.15 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4. 0.30319\. 2016-07-22 07:21:34.20 spid8s CHECKDB for database 'master' finished without errors on 2016-07-21 00:30:03.753 (local time). This is an informational message only; no user action is required. 2016-07-22 07:21:34.20 spid8s Resource governor reconfiguration succeeded. 2016-07-22 07:21:34.20 spid8s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2016-07-22 07:21:34.21 spid8s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2016-07-22 07:21:34.38 spid8s SQL Trace ID 1 was started by login "sa". 2016-07-22 07:21:34.40 spid8s Server name is 'SQLSERVER'. This is an informational message only. No user action is required. 2016-07-22 07:21:34.40 spid19s Starting up database 'buh_oilsg'. 2016-07-22 07:21:34.40 spid18s Starting up database 'msdb'. 2016-07-22 07:21:34.40 spid20s Starting up database 'zup_oilsg'. 2016-07-22 07:21:34.40 spid11s Starting up database 'mssqlsystemresource'. 2016-07-22 07:21:34.40 spid21s Starting up database 'zup_nt-service'. 2016-07-22 07:21:34.40 spid23s Starting up database 'buh_veles'. 2016-07-22 07:21:34.41 spid22s Starting up database 'upr_torg_veles'. 2016-07-22 07:21:34.41 spid24s Starting up database 'buh_solidan'. 2016-07-22 07:21:34.41 spid25s Starting up database 'torg_shtrih'. 2016-07-22 07:21:34.42 spid26s Starting up database 'zup_solidan'. 2016-07-22 07:21:34.42 spid27s Starting up database 'zup_veles'. 2016-07-22 07:21:34.53 spid15s A self-generated certificate was successfully loaded for encryption. 2016-07-22 07:21:34.53 spid15s Server is listening on [ 'any' <ipv6> 1433]. 2016-07-22 07:21:34.53 spid15s Server is listening on [ 'any' <ipv4> 1433]. 2016-07-22 07:21:34.53 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. 2016-07-22 07:21:34.53 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ]. 2016-07-22 07:21:34.54 Server Server is listening on [ ::1 <ipv6> 1434]. 2016-07-22 07:21:34.54 Server Server is listening on [ 127.0.0.1 <ipv4> 1434]. 2016-07-22 07:21:34.54 Server Dedicated admin connection support was established for listening locally on port 1434. 2016-07-22 07:21:34.54 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. 2016-07-22 07:21:34.54 spid15s SQL Server is now ready for client connections. This is an informational message; no user action is required. 2016-07-22 07:21:34.54 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQLServer ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. 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. 2016-07-22 07:21:34.54 Server The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQLServer:1433 ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. 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. 2016-07-22 07:21:34.60 spid28s Starting up database 'veles2016'. 2016-07-22 07:21:34.65 spid25s There have been 256 misaligned log IOs which required falling back to synchronous IO. The current IO is on file c:\SQL_Base\MSSQL12.MSSQLSERVER\MSSQL\DA TA\torg_shtrih_log.ldf. 2016-07-22 07:21:35.17 spid11s Unable to create stack dump file due to stack shortage (ex_terminator - Last chance exception handling) 2016-07-22 07:21:35.17 spid11s Stack Signature for the dump is 0x0000000000000000 2016-07-22 07:21:35.20 spid11s [INFO] Identity Begin End \| State Result Error Speculate Prepared LazyCommit ReadOnly \| Transaction Database ThreadId \| ReadSet WriteSet ScanSet Savepoint LogSizeRq \| CommitDep TotalComm Dependent 0 Dependent 1 Dependent 2 Dependent 3 Dependent 4 Dependent 5 Dependent 6 Dependent 7 \| Area Location \| 2016-07-22 07:21:35.57 Server Software Usage Metrics is enabled. 2016-07-22 07:21:36.25 spid11s External dump process return code 0x20000001. External dump process returned no errors. Добавлено через 3 часа 21 минуту Устранил удалением обновлений винды, все заработало 0