Гость
Целевая тема:
Создать новую тему:
Автор:
Форумы / Microsoft SQL Server [игнор отключен] [закрыт для гостей] / Срочно!! Помогите решить проблемму с 6.5 / 7 сообщений из 7, страница 1 из 1
04.10.2001, 06:31
    #32014944
Hermit
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Срочно!! Помогите решить проблемму с 6.5
Hi All
Есть проблемма.
ИНОГДА СТАЛ ПОДВИСАТЬ SQL server 6.5
Подвисание представляет собой то что сервер работает но юзеров новых не пускает, при этом
все кто раньше вошел все работают.Сервер джобы исполняет исправно.
Количество юзеров примерно 50. выделено 180.
В Error логе появляются такие надписи:

01/10/01 08:55:59.65 ods Error : 17824, Severity: 10, State: 0
01/10/01 08:55:59.65 ods Unable to write to ListenOn connection 'BARBIE', loginname 'Lil', hostname ''.
01/10/01 08:55:59.64 ods OS Error : 64,
01/10/01 08:55:59.67 ods Error : 17824, Severity: 10, State: 0
01/10/01 08:55:59.67 ods Unable to write to ListenOn connection 'BARBIE', loginname 'Lil', hostname ''.
01/10/01 08:55:59.67 ods OS Error : 64,
01/10/01 08:55:59.68 spid29 Error : 1608, Severity: 21, State: 2
01/10/01 08:55:59.68 spid29 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/01 08:57:04.82 ods Error : 17824, Severity: 10, State: 0
01/10/01 08:57:04.82 ods Unable to write to ListenOn connection 'BARBIE', loginname 'Lil', hostname ''.
01/10/01 08:57:04.82 ods OS Error : 64,

Помогает только рестарт сервера, причем сервиис SQL не даунит сервер.
подвисает на надписи SQL SErver Stopping. не доходит до надписи SQL Server Stopped.
Только рестарт NT причем происходит корректно.
Происходит все это с периодичностью в 2 - 3 дня

Ничего нового на SQL сервер не ставили. как 2 года засетапили так все работало.
Какие методы поиска ошибки
как можно найти багу?

SQL Server 6.5 Sp4 SERVER ASTOR 2 2xPIII-500 512Mb


Новый лог файл, за вчера.

01/10/03 14:11:26.12 backup DATABASE dumped with following info: Database Name:PrintBase, Creation Date and Time14:10), Pages dumped:77906, Current Sequence:37165 15299981, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextV NAME=auto TYPE=DISK FILE=1)
01/10/03 14:11:37.17 backup DATABASE dumped with following info: Database Name:Design, Creation Date and Time14:11), Pages dumped:9475, Current Sequence:37165 15317976, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Design TYPE=DISK FILE=1)
01/10/03 14:11:38.31 backup DATABASE dumped with following info: Database Name:AdmBase, Creation Date and Time14:11), Pages dumped:611, Current Sequence:36215 10943938, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=AdmBase TYPE=DISK FILE=1)
01/10/03 14:11:44.28 backup DATABASE dumped with following info: Database Name:CompStore, Creation Date and Time14:11), Pages dumped:4936, Current Sequence:37165 14795915, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Compstr TYPE=DISK FILE=1)
01/10/03 14:11:49.78 backup DATABASE dumped with following info: Database Name:Staff, Creation Date and Time14:11), Pages dumped:4252, Current Sequence:37165 14364473, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Staff TYPE=DISK FILE=1)
01/10/03 14:11:53.46 backup DATABASE dumped with following info: Database Name:xoz, Creation Date and Time14:11), Pages dumped:1781, Current Sequence:36220 12418027, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Xoz TYPE=DISK FILE=1)
01/10/03 14:12:01.06 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time14:11), Pages dumped:6543, Current Sequence:37165 14435733, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NEXTD NAME=BMaster TYPE=DISK FILE=1)
01/10/03 15:11:28.06 backup DATABASE dumped with following info: Database Name:PrintBase, Creation Date and Time15:10), Pages dumped:77919, Current Sequence:37165 16344257, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextV NAME=auto TYPE=DISK FILE=1)
01/10/03 15:11:39.40 backup DATABASE dumped with following info: Database Name:Design, Creation Date and Time15:11), Pages dumped:9475, Current Sequence:37165 16254356, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Design TYPE=DISK FILE=1)
01/10/03 15:11:40.46 backup DATABASE dumped with following info: Database Name:AdmBase, Creation Date and Time15:11), Pages dumped:611, Current Sequence:36215 10943938, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=AdmBase TYPE=DISK FILE=1)
01/10/03 15:11:46.45 backup DATABASE dumped with following info: Database Name:CompStore, Creation Date and Time15:11), Pages dumped:4936, Current Sequence:37165 15336135, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Compstr TYPE=DISK FILE=1)
01/10/03 15:11:51.92 backup DATABASE dumped with following info: Database Name:Staff, Creation Date and Time15:11), Pages dumped:4252, Current Sequence:37165 14364473, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Staff TYPE=DISK FILE=1)
01/10/03 15:11:55.54 backup DATABASE dumped with following info: Database Name:xoz, Creation Date and Time15:11), Pages dumped:1781, Current Sequence:36220 12418027, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Xoz TYPE=DISK FILE=1)
01/10/03 15:12:03.14 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time15:11), Pages dumped:6543, Current Sequence:37165 14435733, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NEXTD NAME=BMaster TYPE=DISK FILE=1)
01/10/03 16:11:28.14 backup DATABASE dumped with following info: Database Name:PrintBase, Creation Date and Time16:10), Pages dumped:77934, Current Sequence:37165 17406520, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextV NAME=auto TYPE=DISK FILE=1)
01/10/03 16:11:39.34 backup DATABASE dumped with following info: Database Name:Design, Creation Date and Time16:11), Pages dumped:9475, Current Sequence:37165 17190538, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Design TYPE=DISK FILE=1)
01/10/03 16:11:40.42 backup DATABASE dumped with following info: Database Name:AdmBase, Creation Date and Time16:11), Pages dumped:611, Current Sequence:36215 10943938, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=AdmBase TYPE=DISK FILE=1)
01/10/03 16:11:46.37 backup DATABASE dumped with following info: Database Name:CompStore, Creation Date and Time16:11), Pages dumped:4936, Current Sequence:37165 15336135, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Compstr TYPE=DISK FILE=1)
01/10/03 16:11:51.79 backup DATABASE dumped with following info: Database Name:Staff, Creation Date and Time16:11), Pages dumped:4252, Current Sequence:37165 14364473, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Staff TYPE=DISK FILE=1)
01/10/03 16:11:55.49 backup DATABASE dumped with following info: Database Name:xoz, Creation Date and Time16:11), Pages dumped:1781, Current Sequence:36220 12418027, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Xoz TYPE=DISK FILE=1)
01/10/03 16:12:03.06 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time16:11), Pages dumped:6543, Current Sequence:37165 14435733, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NEXTD NAME=BMaster TYPE=DISK FILE=1)
01/10/03 17:11:29.84 backup DATABASE dumped with following info: Database Name:PrintBase, Creation Date and Time17:10), Pages dumped:77943, Current Sequence:37165 18522853, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextV NAME=auto TYPE=DISK FILE=1)
01/10/03 17:11:41.01 backup DATABASE dumped with following info: Database Name:Design, Creation Date and Time17:11), Pages dumped:9478, Current Sequence:37165 18541031, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Design TYPE=DISK FILE=1)
01/10/03 17:11:42.07 backup DATABASE dumped with following info: Database Name:AdmBase, Creation Date and Time17:11), Pages dumped:611, Current Sequence:36215 10943938, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=AdmBase TYPE=DISK FILE=1)
01/10/03 17:11:48.01 backup DATABASE dumped with following info: Database Name:CompStore, Creation Date and Time17:11), Pages dumped:4936, Current Sequence:37165 15336135, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Compstr TYPE=DISK FILE=1)
01/10/03 17:11:53.54 backup DATABASE dumped with following info: Database Name:Staff, Creation Date and Time17:11), Pages dumped:4252, Current Sequence:37165 14364473, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Staff TYPE=DISK FILE=1)
01/10/03 17:11:57.21 backup DATABASE dumped with following info: Database Name:xoz, Creation Date and Time17:11), Pages dumped:1781, Current Sequence:36220 12418027, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Xoz TYPE=DISK FILE=1)
01/10/03 17:12:04.87 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time17:11), Pages dumped:6543, Current Sequence:37165 14435733, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NEXTD NAME=BMaster TYPE=DISK FILE=1)
01/10/03 17:34:10.28 ods Error : 17824, Severity: 10, State: 0
01/10/03 17:34:10.28 ods Unable to write to ListenOn connection '\.\pipe\sql\query', loginname 'nata', hostname ''.
01/10/03 17:34:10.24 ods OS Error : 109,
01/10/03 17:48:56.85 ods Error : 17824, Severity: 10, State: 0
01/10/03 17:48:56.85 ods Unable to write to ListenOn connection 'BARBIE', loginname 'nik', hostname ''.
01/10/03 17:48:56.85 ods OS Error : 64,
01/10/03 17:48:56.85 spid32 Error : 1608, Severity: 21, State: 2
01/10/03 17:48:56.85 spid32 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 17:48:56.96 ods Error : 17824, Severity: 10, State: 0
01/10/03 17:48:56.96 ods Unable to write to ListenOn connection 'BARBIE', loginname 'nik', hostname ''.
01/10/03 17:48:56.96 ods OS Error : 64,
01/10/03 17:48:56.96 spid33 Error : 1608, Severity: 21, State: 2
01/10/03 17:48:56.96 spid33 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 17:54:20.18 spid19 Error : 925, Severity: 19, State: 1
01/10/03 17:54:20.18 spid19 Maximum number of used databases for each query has been exceeded. The maximum allowed is 8.
01/10/03 17:54:24.29 spid14 Error : 925, Severity: 19, State: 1
01/10/03 17:54:24.29 spid14 Maximum number of used databases for each query has been exceeded. The maximum allowed is 8.
01/10/03 17:59:06.64 ods Error : 17824, Severity: 10, State: 0
01/10/03 17:59:06.64 ods Unable to write to ListenOn connection '\.\pipe\sql\query', loginname 'nata', hostname ''.
01/10/03 17:59:06.64 ods OS Error : 232,
01/10/03 17:59:06.64 spid15 Error : 1608, Severity: 21, State: 2
01/10/03 17:59:06.64 spid15 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 18:00:12.36 ods Error : 17824, Severity: 10, State: 0
01/10/03 18:00:12.36 ods Unable to write to ListenOn connection 'BARBIE', loginname 'mariska', hostname ''.
01/10/03 18:00:12.36 ods OS Error : 64,
01/10/03 18:00:12.36 spid31 Error : 1608, Severity: 21, State: 2
01/10/03 18:00:12.36 spid31 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 18:00:12.46 ods Error : 17824, Severity: 10, State: 0
01/10/03 18:00:12.46 ods Unable to write to ListenOn connection 'BARBIE', loginname 'mariska', hostname ''.
01/10/03 18:00:12.46 ods OS Error : 64,
01/10/03 18:00:12.46 spid51 Error : 1608, Severity: 21, State: 2
01/10/03 18:00:12.46 spid51 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 18:01:55.06 ods Error : 17824, Severity: 10, State: 0
01/10/03 18:01:55.06 ods Unable to write to ListenOn connection 'BARBIE', loginname 'S971', hostname ''.
01/10/03 18:01:55.06 ods OS Error : 64,
01/10/03 18:01:55.06 spid11 Error : 1608, Severity: 21, State: 2
01/10/03 18:01:55.06 spid11 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 18:03:50.37 ods Error : 17824, Severity: 10, State: 0
01/10/03 18:03:50.37 ods Unable to write to ListenOn connection '\.\pipe\sql\query', loginname 'nata', hostname ''.
01/10/03 18:03:50.37 ods OS Error : 232,
01/10/03 18:03:50.37 spid19 Error : 1608, Severity: 21, State: 2
01/10/03 18:03:50.37 spid19 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 18:06:04.21 ods Error : 17824, Severity: 10, State: 0
01/10/03 18:06:04.21 ods Unable to write to ListenOn connection 'BARBIE', loginname 'olya', hostname ''.
01/10/03 18:06:04.21 ods OS Error : 64,
01/10/03 18:06:04.21 spid18 Error : 1608, Severity: 21, State: 2
01/10/03 18:06:04.21 spid18 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 18:11:25.07 backup DATABASE dumped with following info: Database Name:PrintBase, Creation Date and Time18:10), Pages dumped:77973, Current Sequence:37165 19117040, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextV NAME=auto TYPE=DISK FILE=1)
01/10/03 18:11:36.15 backup DATABASE dumped with following info: Database Name:Design, Creation Date and Time18:11), Pages dumped:9480, Current Sequence:37165 19135003, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Design TYPE=DISK FILE=1)
01/10/03 18:11:37.18 backup DATABASE dumped with following info: Database Name:AdmBase, Creation Date and Time18:11), Pages dumped:611, Current Sequence:36215 10943938, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=AdmBase TYPE=DISK FILE=1)
01/10/03 18:11:43.09 backup DATABASE dumped with following info: Database Name:CompStore, Creation Date and Time18:11), Pages dumped:4936, Current Sequence:37165 15336135, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Compstr TYPE=DISK FILE=1)
01/10/03 18:11:48.59 backup DATABASE dumped with following info: Database Name:Staff, Creation Date and Time18:11), Pages dumped:4252, Current Sequence:37165 14364473, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Staff TYPE=DISK FILE=1)
01/10/03 18:11:52.15 backup DATABASE dumped with following info: Database Name:xoz, Creation Date and Time18:11), Pages dumped:1781, Current Sequence:36220 12418027, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Xoz TYPE=DISK FILE=1)
01/10/03 18:11:59.50 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time18:11), Pages dumped:6543, Current Sequence:37165 14435733, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NEXTD NAME=BMaster TYPE=DISK FILE=1)
01/10/03 18:30:36.18 ods Error : 17824, Severity: 10, State: 0
01/10/03 18:30:36.18 ods Unable to write to ListenOn connection '\.\pipe\sql\query', loginname 'nata', hostname ''.
01/10/03 18:30:36.17 ods OS Error : 232,
01/10/03 18:30:36.20 spid31 Error : 1608, Severity: 21, State: 2
01/10/03 18:30:36.20 spid31 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 18:55:54.62 ods Error : 17824, Severity: 10, State: 0
01/10/03 18:55:54.62 ods Unable to write to ListenOn connection 'BARBIE', loginname 'Ok', hostname ''.
01/10/03 18:55:54.62 ods OS Error : 64,
01/10/03 18:55:54.62 spid31 Error : 1608, Severity: 21, State: 2
01/10/03 18:55:54.62 spid31 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 19:11:23.96 backup DATABASE dumped with following info: Database Name:PrintBase, Creation Date and Time19:10), Pages dumped:77982, Current Sequence:37165 19117040, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextV NAME=auto TYPE=DISK FILE=1)
01/10/03 19:11:34.89 backup DATABASE dumped with following info: Database Name:Design, Creation Date and Time19:11), Pages dumped:9487, Current Sequence:37165 19135003, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Design TYPE=DISK FILE=1)
01/10/03 19:11:35.93 backup DATABASE dumped with following info: Database Name:AdmBase, Creation Date and Time19:11), Pages dumped:611, Current Sequence:36215 10943938, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=AdmBase TYPE=DISK FILE=1)
01/10/03 19:11:41.79 backup DATABASE dumped with following info: Database Name:CompStore, Creation Date and Time19:11), Pages dumped:4936, Current Sequence:37165 15336135, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Compstr TYPE=DISK FILE=1)
01/10/03 19:11:47.17 backup DATABASE dumped with following info: Database Name:Staff, Creation Date and Time19:11), Pages dumped:4252, Current Sequence:37165 14364473, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Staff TYPE=DISK FILE=1)
01/10/03 19:11:50.84 backup DATABASE dumped with following info: Database Name:xoz, Creation Date and Time19:11), Pages dumped:1781, Current Sequence:36220 12418027, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Xoz TYPE=DISK FILE=1)
01/10/03 19:11:58.09 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time19:11), Pages dumped:6543, Current Sequence:37165 14435733, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NEXTD NAME=BMaster TYPE=DISK FILE=1)
01/10/03 20:08:14.85 ods Error : 17824, Severity: 10, State: 0
01/10/03 20:08:14.85 ods Unable to write to ListenOn connection '\.\pipe\sql\query', loginname 'nata', hostname ''.
01/10/03 20:08:14.84 ods OS Error : 232,
01/10/03 20:08:14.89 spid22 Error : 1608, Severity: 21, State: 2
01/10/03 20:08:14.89 spid22 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 20:11:23.85 backup DATABASE dumped with following info: Database Name:PrintBase, Creation Date and Time20:10), Pages dumped:77982, Current Sequence:37165 19117040, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextV NAME=auto TYPE=DISK FILE=1)
01/10/03 20:11:34.64 backup DATABASE dumped with following info: Database Name:Design, Creation Date and Time20:11), Pages dumped:9487, Current Sequence:37165 19135003, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Design TYPE=DISK FILE=1)
01/10/03 20:11:35.68 backup DATABASE dumped with following info: Database Name:AdmBase, Creation Date and Time20:11), Pages dumped:611, Current Sequence:36215 10943938, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=AdmBase TYPE=DISK FILE=1)
01/10/03 20:11:41.65 backup DATABASE dumped with following info: Database Name:CompStore, Creation Date and Time20:11), Pages dumped:4936, Current Sequence:37165 15336135, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Compstr TYPE=DISK FILE=1)
01/10/03 20:11:48.71 backup DATABASE dumped with following info: Database Name:Staff, Creation Date and Time20:11), Pages dumped:4252, Current Sequence:37165 14364473, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Staff TYPE=DISK FILE=1)
01/10/03 20:11:52.73 backup DATABASE dumped with following info: Database Name:xoz, Creation Date and Time20:11), Pages dumped:1781, Current Sequence:36220 12418027, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Xoz TYPE=DISK FILE=1)
01/10/03 20:12:00.03 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time20:11), Pages dumped:6543, Current Sequence:37165 14435733, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NEXTD NAME=BMaster TYPE=DISK FILE=1)
01/10/03 20:34:08.54 ods Error : 17824, Severity: 10, State: 0
01/10/03 20:34:08.54 ods Unable to write to ListenOn connection 'BARBIE', loginname 'dewdrop', hostname ''.
01/10/03 20:34:08.54 ods OS Error : 64,
01/10/03 20:34:08.56 spid22 Error : 1608, Severity: 21, State: 2
01/10/03 20:34:08.56 spid22 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 20:34:08.64 ods Error : 17824, Severity: 10, State: 0
01/10/03 20:34:08.64 ods Unable to write to ListenOn connection 'BARBIE', loginname 'dewdrop', hostname ''.
01/10/03 20:34:08.64 ods OS Error : 64,
01/10/03 20:34:08.64 spid30 Error : 1608, Severity: 21, State: 2
01/10/03 20:34:08.64 spid30 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 20:38:17.35 ods Error : 17824, Severity: 10, State: 0
01/10/03 20:38:17.35 ods Unable to write to ListenOn connection 'BARBIE', loginname 'dewdrop', hostname ''.
01/10/03 20:38:17.35 ods OS Error : 64,
01/10/03 20:38:17.35 spid22 Error : 1608, Severity: 21, State: 2
01/10/03 20:38:17.35 spid22 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/03 21:11:24.45 backup DATABASE dumped with following info: Database Name:PrintBase, Creation Date and Time21:10), Pages dumped:78118, Current Sequence:37165 19117040, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextV NAME=auto TYPE=DISK FILE=1)
01/10/03 21:11:35.21 backup DATABASE dumped with following info: Database Name:Design, Creation Date and Time21:11), Pages dumped:9487, Current Sequence:37165 19135003, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Design TYPE=DISK FILE=1)
01/10/03 21:11:36.28 backup DATABASE dumped with following info: Database Name:AdmBase, Creation Date and Time21:11), Pages dumped:611, Current Sequence:36215 10943938, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=AdmBase TYPE=DISK FILE=1)
01/10/03 21:11:42.17 backup DATABASE dumped with following info: Database Name:CompStore, Creation Date and Time21:11), Pages dumped:4936, Current Sequence:37165 15336135, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Compstr TYPE=DISK FILE=1)
01/10/03 21:11:47.51 backup DATABASE dumped with following info: Database Name:Staff, Creation Date and Time21:11), Pages dumped:4252, Current Sequence:37165 14364473, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Staff TYPE=DISK FILE=1)
01/10/03 21:11:51.14 backup DATABASE dumped with following info: Database Name:xoz, Creation Date and Time21:11), Pages dumped:1781, Current Sequence:36220 12418027, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NextD NAME=Xoz TYPE=DISK FILE=1)
01/10/03 21:11:58.53 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time21:11), Pages dumped:6543, Current Sequence:37165 14435733, Sort Order:108, Striped:NO, Number of Dump Devices:1, device infoVOLID=NEXTD NAME=BMaster TYPE=DISK FILE=1)
01/10/04 08:56:27.39 ods Error : 17824, Severity: 10, State: 0
01/10/04 08:56:27.39 ods Unable to write to ListenOn connection '1433', loginname 'm205', hostname ''.
01/10/04 08:56:27.37 ods OS Error : 64,
01/10/04 08:56:27.42 spid44 Error : 1608, Severity: 21, State: 2
01/10/04 08:56:27.42 spid44 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/04 09:00:18.01 ods Error : 17824, Severity: 10, State: 0
01/10/04 09:00:18.01 ods Unable to write to ListenOn connection '1433', loginname 'm205', hostname ''.
01/10/04 09:00:18.01 ods OS Error : 64,
01/10/04 09:00:18.01 spid48 Error : 1608, Severity: 21, State: 2
01/10/04 09:00:18.01 spid48 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/04 09:03:59.45 ods Error : 17824, Severity: 10, State: 0
01/10/04 09:03:59.45 ods Unable to write to ListenOn connection 'BARBIE', loginname 'Doi', hostname ''.
01/10/04 09:03:59.45 ods OS Error : 64,
01/10/04 09:03:59.45 spid48 Error : 1608, Severity: 21, State: 2
01/10/04 09:03:59.45 spid48 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/04 09:04:05.48 ods Error : 17824, Severity: 10, State: 0
01/10/04 09:04:05.48 ods Unable to write to ListenOn connection 'BARBIE', loginname 'Doi', hostname ''.
01/10/04 09:04:05.48 ods OS Error : 64,
01/10/04 09:04:05.48 spid54 Error : 1608, Severity: 21, State: 2
01/10/04 09:04:05.48 spid54 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/04 09:04:09.75 ods Error : 17824, Severity: 10, State: 0
01/10/04 09:04:09.75 ods Unable to write to ListenOn connection 'BARBIE', loginname 'Doi', hostname ''.
01/10/04 09:04:09.75 ods OS Error : 64,
01/10/04 09:04:09.75 spid59 Error : 1608, Severity: 21, State: 2
01/10/04 09:04:09.75 spid59 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/04 09:05:50.56 ods Error : 17824, Severity: 10, State: 0
01/10/04 09:05:50.56 ods Unable to write to ListenOn connection 'BARBIE', loginname 'Doi', hostname ''.
01/10/04 09:05:50.56 ods OS Error : 64,
01/10/04 09:05:50.56 spid50 Error : 1608, Severity: 21, State: 2
01/10/04 09:05:50.56 spid50 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
01/10/04 09:06:28.07 kernel SQL Server terminating because of system shutdown
01/10/04 09:06:28.10 kernel LogEvent: Failed to report the current event; operating system error = (null)
01/10/04 09:06:29.85 ods Error : 17824, Severity: 10, State: 0
01/10/04 09:06:29.85 ods Unable to write to ListenOn connection '\.\pipe\sql\query', loginname 'sa', hostname 'KEN'.
01/10/04 09:06:29.85 ods OS Error : 232,
...
Рейтинг: 0 / 0
08.10.2001, 07:01
    #32015020
Александр Гладченко
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Срочно!! Помогите решить проблемму с 6.5
Обратите внимание на эту строку:
Maximum number of used databases for each query has been exceeded. The maximum allowed is 8
...
Рейтинг: 0 / 0
08.10.2001, 10:58
    #32015052
Hermit
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Срочно!! Помогите решить проблемму с 6.5
Обратил

Но

Ошибка эта появилась первый раз.
В опциях сервера стаит Open DataBAses у меня 20
тоесть можно открыть 20 баз
а их у меня включая системные (Master,TempDb,msdb) 17 штук.
причем 3 изних уже не работают и на них стоит Dbo Use only
4 из 17 служебные и используются крайне редко.
а подвисоны были и в воскресенье когда работали 2 человека
все эти базы у меня независимые и не соеденены друг с другом.
исключая 3 штуки которые самые активные и юзаются постоянно.
...
Рейтинг: 0 / 0
08.10.2001, 11:46
    #32015058
Daymon
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Срочно!! Помогите решить проблемму с 6.5
я конечно не спец в 6,5 но такое ощущение что идут бекапы и они занимают либо все ресурсы либо одновренно открытые базы и юзера не могут подключится попробуй запускать бекапы по одному (после того как предыдущий отработал)
...
Рейтинг: 0 / 0
08.10.2001, 11:58
    #32015059
Hermitap
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Срочно!! Помогите решить проблемму с 6.5
А они и запускаются по одному...

Они выполняются каждый час. а зависоны происходят раз в 2-3 дня примерно...
прияем если подвисло... бекапы всеравно отрабатываются корректно
причем раз зависло вечером... и всю ночь висело
но бекапы отработались все нормально..

а ведь чтобы они отработались, MSExecutive толжен законектится к серваку и отработать джоб
он то коонектится... почему обычные юзеры не могут?
...
Рейтинг: 0 / 0
08.10.2001, 12:18
    #32015064
Daymon
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Срочно!! Помогите решить проблемму с 6.5
А ты мосмотри может какая база после бекапа остается открытой -как раз за 2-3 дня и накопится 20 открытых (чуствует моя пятая точка что где то сдесь зарыта собака и еще посмотри в серверный лог -иногда там бывает оч интересная информация )
...
Рейтинг: 0 / 0
08.10.2001, 12:41
    #32015068
Hermitap
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Срочно!! Помогите решить проблемму с 6.5
А как посмотреть сколько баз открыто?


P.S.
Этот очередь бекапов у меня работает уже 2 года каждый день через час
и такого небыло, но все может быть
...
Рейтинг: 0 / 0
Форумы / Microsoft SQL Server [игнор отключен] [закрыт для гостей] / Срочно!! Помогите решить проблемму с 6.5 / 7 сообщений из 7, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]