Этот баннер — требование Роскомнадзора для исполнения 152 ФЗ.
«На сайте осуществляется обработка файлов cookie, необходимых для работы сайта, а также для анализа использования сайта и улучшения предоставляемых сервисов с использованием метрической программы Яндекс.Метрика. Продолжая использовать сайт, вы даёте согласие с использованием данных технологий».
Политика конфиденциальности
|
|
|
Срочно!! Помогите решить проблемму с 6.5
|
|||
|---|---|---|---|
|
#18+
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, ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.10.2001, 06:31 |
|
||
|
Срочно!! Помогите решить проблемму с 6.5
|
|||
|---|---|---|---|
|
#18+
Обратите внимание на эту строку: Maximum number of used databases for each query has been exceeded. The maximum allowed is 8 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 08.10.2001, 07:01 |
|
||
|
Срочно!! Помогите решить проблемму с 6.5
|
|||
|---|---|---|---|
|
#18+
Обратил Но Ошибка эта появилась первый раз. В опциях сервера стаит Open DataBAses у меня 20 тоесть можно открыть 20 баз а их у меня включая системные (Master,TempDb,msdb) 17 штук. причем 3 изних уже не работают и на них стоит Dbo Use only 4 из 17 служебные и используются крайне редко. а подвисоны были и в воскресенье когда работали 2 человека все эти базы у меня независимые и не соеденены друг с другом. исключая 3 штуки которые самые активные и юзаются постоянно. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 08.10.2001, 10:58 |
|
||
|
Срочно!! Помогите решить проблемму с 6.5
|
|||
|---|---|---|---|
|
#18+
я конечно не спец в 6,5 но такое ощущение что идут бекапы и они занимают либо все ресурсы либо одновренно открытые базы и юзера не могут подключится попробуй запускать бекапы по одному (после того как предыдущий отработал) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 08.10.2001, 11:46 |
|
||
|
Срочно!! Помогите решить проблемму с 6.5
|
|||
|---|---|---|---|
|
#18+
А они и запускаются по одному... Они выполняются каждый час. а зависоны происходят раз в 2-3 дня примерно... прияем если подвисло... бекапы всеравно отрабатываются корректно причем раз зависло вечером... и всю ночь висело но бекапы отработались все нормально.. а ведь чтобы они отработались, MSExecutive толжен законектится к серваку и отработать джоб он то коонектится... почему обычные юзеры не могут? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 08.10.2001, 11:58 |
|
||
|
Срочно!! Помогите решить проблемму с 6.5
|
|||
|---|---|---|---|
|
#18+
А ты мосмотри может какая база после бекапа остается открытой -как раз за 2-3 дня и накопится 20 открытых (чуствует моя пятая точка что где то сдесь зарыта собака и еще посмотри в серверный лог -иногда там бывает оч интересная информация ) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 08.10.2001, 12:18 |
|
||
|
|

start [/forum/topic.php?desktop=1&fid=46&tid=1825359]: |
0ms |
get settings: |
10ms |
get forum list: |
19ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
35ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
54ms |
get tp. blocked users: |
2ms |
| others: | 274ms |
| total: | 417ms |

| 0 / 0 |
