#0
by zenik
В последнее время стала появлятся ошибка: (17.6 кб). Самое смешное, что этот скрин сделан на самом SQL сервере. Периодичность появления нестабильная (2 раза в неделю, раз в неделю, раз в две недели). Т.е. когда случится - неизвестно. Иногда бывали ситуации, что кто то при этом вполне успешно работает, а кто то пытается подключится и получает такую же ошибку, все кто работал, продолжают успешно работать. Помогает перезагрузка сервера, после нее восстанавливается нормальная работа до следующего проявления ошибки. Очень часто эта ошибка происходит тогда, когда собсно никто и не работает (ночью). Вот сегодня, в 0:00:29 запись в событиях: Компьютер: SERVER Описание: This instance of SQL Server has been using a process id of 1468 since 19.05.2007 8:26:04 (local) 19.05.2007 4:26:04 (UTC). Дополнительные сведения можно найти в центре справки и поддержки, в "http://go.microsoft.com/fwlink/events.asp". Данные: 0000: 19 43 00 00 0a 00 00 00 .C...... 0008: 07 00 00 00 53 00 45 00 ....S.E. 0010: 52 00 56 00 45 00 52 00 R.V.E.R. 0018: 00 00 00 00 00 00 ...... Т.е. все еще нормально, а вот чуть позже: Источник события: SQLSERVERAGENT Категория события: Job Engine Код события: 208 Компьютер: SERVER Описание: SQL Server Scheduled Job 'Shrink Database - ocean_2006' (0xE027F29E12763C4EBD28B70B718316FF) - Status: Failed - Invoked on: 2007-05-22 03:00:00 - Message: The job failed. Unable to determine if the owner (SERVERzenik) of job Shrink Database - ocean_2006 has server access (reason: Unable to connect to server - check SQL Server and SQL Server Agent errorlogs). Дополнительные сведения можно найти в центре справки и поддержки, в "http://go.microsoft.com/fwlink/events.asp". Бекап уже не сделан... Хотя в 20:00 люди перестают работать. к 23:00 отрабатывают служебные обработки. т.е. фактически нагрузка между этими событиями близка к 0. В какую сторону ковырять я уже и не знаю. SQL developer edition SP4. Win 2003 Server Ent 1С v7.7.025
#1
by masky
в сторону Unable to determine if the owner (SERVERzenik) of job >SQL developer edition SP4 LOL.. что покупать жаба давит?
#4
by zenik
2007-05-22 07:22:04.00 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: ) 2007-05-22 07:22:04.06 server Copyright (C) 1988-2002 Microsoft Corporation. 2007-05-22 07:22:04.06 server All rights reserved. 2007-05-22 07:22:04.06 server Server Process ID is 1480. 2007-05-22 07:22:04.06 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'. 2007-05-22 07:22:04.07 server SQL Server is starting at priority class 'normal'(4 CPUs detected). 2007-05-22 07:22:04.14 server Address Windowing Extensions enabled. 2007-05-22 07:22:05.95 server Working Set size set to 2097152 kilobytes. 2007-05-22 07:22:05.96 server SQL Server configured for fiber mode processing. 2007-05-22 07:22:05.98 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks. 2007-05-22 07:22:06.06 server Attempting to initialize Distributed Transaction Coordinator. 2007-05-22 07:22:07.04 server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE 2007-05-22 07:22:07.04 spid1 Starting up database 'master'. 2007-05-22 07:22:07.54 spid1 Server name is 'SERVER'. 2007-05-22 07:22:07.54 spid5 Starting up database 'msdb'. 2007-05-22 07:22:07.54 spid6 Starting up database 'pubs'. 2007-05-22 07:22:07.54 spid7 Starting up database 'Northwind'. 2007-05-22 07:22:07.54 spid8 Starting up database 'model'. 2007-05-22 07:22:07.54 spid10 Starting up database 'ocean'. 2007-05-22 07:22:07.54 server Using 'SSNETLIB.DLL' version '8.0.2039'. 2007-05-22 07:22:07.54 spid11 Starting up database 'ocean_copy'. 2007-05-22 07:22:07.54 spid12 Starting up database 'popovich'. 2007-05-22 07:22:07.54 spid14 Starting up database 'sms'. 2007-05-22 07:22:07.60 server SQL server listening on 192.168.0.100: 1433. 2007-05-22 07:22:07.60 server SQL server listening on 127.0.0.1: 1433. 2007-05-22 07:22:07.65 spid15 Starting up database 'EGAIS'. 2007-05-22 07:22:07.67 spid16 Starting up database 'ocean_2006'. 2007-05-22 07:22:07.70 spid17 Starting up database 'test'. 2007-05-22 07:22:08.60 spid8 Clearing tempdb database. 2007-05-22 07:22:09.87 server SQL server listening on TCP, Shared Memory. 2007-05-22 07:22:09.87 server SQL Server is ready for client connections 2007-05-22 07:22:10.73 spid8 Starting up database 'tempdb'. 2007-05-22 07:22:11.34 spid1 Recovery complete. 2007-05-22 07:22:11.34 spid1 SQL global counter collection task is created. 2007-05-22 07:22:12.39 spid51 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'. 2007-05-22 07:22:17.07 spid3 Warning: unable to allocate 'min server memory' of 6144MB. 2007-05-22 09:00:01.01 spid80 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_sqlmaint'. 2007-05-22 09:00:04.43 spid82 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_instance_regread'. 2007-05-22 09:25:41.64 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 639509, first LSN: 135962:300:1, last LSN: 135974:354:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705220900.BAK'}). 2007-05-22 09:36:04.71 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105235, first LSN: 43328:279:1, last LSN: 43328:284:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705220929.BAK'}). 2007-05-22 10:03:16.46 spid85 Error: 15457, Severity: 0, State: 1 2007-05-22 10:03:16.46 spid85 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.. 2007-05-22 10:03:16.53 spid85 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
#5
by zenik
2007-05-19 08:25:56.50 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: ) 2007-05-19 08:25:56.51 server Copyright (C) 1988-2002 Microsoft Corporation. 2007-05-19 08:25:56.51 server All rights reserved. 2007-05-19 08:25:56.51 server Server Process ID is 1468. 2007-05-19 08:25:56.51 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'. 2007-05-19 08:25:56.56 server SQL Server is starting at priority class 'normal'(4 CPUs detected). 2007-05-19 08:25:56.64 server Address Windowing Extensions enabled. 2007-05-19 08:25:58.62 server Working Set size set to 2097152 kilobytes. 2007-05-19 08:25:58.64 server SQL Server configured for fiber mode processing. 2007-05-19 08:25:58.65 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks. 2007-05-19 08:25:58.73 server Attempting to initialize Distributed Transaction Coordinator. 2007-05-19 08:25:59.56 server Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE 2007-05-19 08:25:59.56 spid1 Starting up database 'master'. 2007-05-19 08:25:59.90 spid1 Server name is 'SERVER'. 2007-05-19 08:25:59.90 spid6 Starting up database 'pubs'. 2007-05-19 08:25:59.90 spid5 Starting up database 'msdb'. 2007-05-19 08:25:59.90 spid8 Starting up database 'Northwind'. 2007-05-19 08:25:59.90 server Using 'SSNETLIB.DLL' version '8.0.2039'. 2007-05-19 08:25:59.90 spid11 Starting up database 'ocean_copy'. 2007-05-19 08:25:59.90 spid7 Starting up database 'ocean'. 2007-05-19 08:25:59.90 spid13 Starting up database 'popovich'. 2007-05-19 08:25:59.90 spid9 Starting up database 'model'. 2007-05-19 08:25:59.90 spid14 Starting up database 'sms'. 2007-05-19 08:25:59.98 server SQL server listening on 192.168.0.100: 1433. 2007-05-19 08:25:59.98 server SQL server listening on 127.0.0.1: 1433. 2007-05-19 08:25:59.98 spid15 Starting up database 'EGAIS'. 2007-05-19 08:26:00.03 spid16 Starting up database 'ocean_2006'. 2007-05-19 08:26:00.06 spid17 Starting up database 'test'. 2007-05-19 08:26:01.10 spid9 Clearing tempdb database. 2007-05-19 08:26:02.24 server SQL server listening on TCP, Shared Memory. 2007-05-19 08:26:02.24 server SQL Server is ready for client connections 2007-05-19 08:26:03.37 spid9 Starting up database 'tempdb'. 2007-05-19 08:26:04.06 spid1 Recovery complete. 2007-05-19 08:26:04.06 spid1 SQL global counter collection task is created. 2007-05-19 08:26:04.95 spid51 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'. 2007-05-19 08:26:09.65 spid2 Warning: unable to allocate 'min server memory' of 6144MB. 2007-05-19 09:00:00.54 spid63 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_sqlmaint'. 2007-05-19 09:00:05.23 spid65 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_instance_regread'. 2007-05-19 09:23:36.53 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 634179, first LSN: 135210:203:1, last LSN: 135211:245:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705190900.BAK'}). 2007-05-19 09:32:44.71 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43301:491:1, last LSN: 43301:493:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705190925.BAK'}). 2007-05-19 11:23:34.81 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 634523, first LSN: 135225:87:1, last LSN: 135228:200:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705191100.BAK'}). 2007-05-19 11:29:30.96 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:16:1, last LSN: 43302:18:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705191125.BAK'}). 2007-05-19 13:23:31.65 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 634603, first LSN: 135236:80:1, last LSN: 135238:412:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705191300.BAK'}). 2007-05-19 13:29:27.03 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:21:1, last LSN: 43302:23:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705191325.BAK'}). 2007-05-19 15:23:31.23 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 634627, first LSN: 135248:350:1, last LSN: 135249:445:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705191500.BAK'}). 2007-05-19 15:29:23.89 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:26:1, last LSN: 43302:28:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705191525.BAK'}). 2007-05-19 17:23:44.10 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 634771, first LSN: 135258:104:1, last LSN: 135261:427:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705191700.BAK'}). 2007-05-19 17:29:41.76 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:31:1, last LSN: 43302:33:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705191725.BAK'}). 2007-05-19 19:27:32.53 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 634811, first LSN: 135274:44:1, last LSN: 135276:115:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705191900.BAK'}). 2007-05-19 19:33:35.40 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:36:1, last LSN: 43302:38:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705191929.BAK'}). 2007-05-19 21:27:31.89 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 635052, first LSN: 135281:81:1, last LSN: 135287:179:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705192100.BAK'}). 2007-05-19 21:33:31.28 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:41:1, last LSN: 43302:43:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705192129.BAK'}). 2007-05-19 22:44:46.98 backup Database backed up: Database: ocean, creation date(time): 2005/09/19(14:56:57), pages dumped: 1092923, first LSN: 154897:466:1, last LSN: 154897:468:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:oceanocean_db_200705192200.BAK'}). 2007-05-20 07:23:43.39 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 635524, first LSN: 135365:308:1, last LSN: 135365:326:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705200700.BAK'}). 2007-05-20 07:29:44.68 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:46:1, last LSN: 43302:48:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705200725.BAK'}). 2007-05-20 09:25:30.06 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 635667, first LSN: 135376:284:1, last LSN: 135379:190:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705200900.BAK'}). 2007-05-20 09:31:29.31 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:51:1, last LSN: 43302:53:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705200927.BAK'}). 2007-05-20 11:27:26.20 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 635731, first LSN: 135390:320:1, last LSN: 135393:59:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705201100.BAK'}). 2007-05-20 11:33:23.14 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:56:1, last LSN: 43302:58:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705201129.BAK'}). 2007-05-20 13:27:34.50 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 636125, first LSN: 135426:304:1, last LSN: 135438:259:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705201300.BAK'}). 2007-05-20 13:33:29.23 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:61:1, last LSN: 43302:63:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705201329.BAK'}). 2007-05-20 14:05:30.12 spid61 Autogrow of file 'ocean_2006_Data' in database 'ocean_2006' cancelled or timed out after 10640 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size. 2007-05-20 14:05:42.12 spid62 Autogrow of file 'ocean_2006_Data' in database 'ocean_2006' cancelled or timed out after 10531 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size. 2007-05-20 14:07:05.45 spid61 Autogrow of file 'ocean_2006_Data' in database 'ocean_2006' cancelled or timed out after 10609 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size. 2007-05-20 14:08:24.32 spid60 Autogrow of file 'ocean_2006_Data' in database 'ocean_2006' took 65187 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file. 2007-05-20 15:24:32.84 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 636349, first LSN: 135473:429:1, last LSN: 135481:198:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705201500.BAK'}). 2007-05-20 15:33:50.06 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:66:1, last LSN: 43302:68:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705201528.BAK'}). 2007-05-20 17:23:50.28 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 636372, first LSN: 135505:440:1, last LSN: 135510:207:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705201700.BAK'}). 2007-05-20 17:29:51.04 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:71:1, last LSN: 43302:73:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705201725.BAK'}). 2007-05-20 19:23:42.82 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 636356, first LSN: 135529:226:1, last LSN: 135530:151:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705201900.BAK'}). 2007-05-20 19:29:43.11 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:76:1, last LSN: 43302:78:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705201925.BAK'}). 2007-05-20 21:23:44.18 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 636580, first LSN: 135534:168:1, last LSN: 135540:156:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705202100.BAK'}). 2007-05-20 21:29:45.48 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:81:1, last LSN: 43302:83:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705202125.BAK'}). 2007-05-20 22:40:51.65 backup Database backed up: Database: ocean, creation date(time): 2005/09/19(14:56:57), pages dumped: 1092923, first LSN: 154898:17:1, last LSN: 154898:19:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:oceanocean_db_200705202200.BAK'}). 2007-05-21 07:27:16.18 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 637060, first LSN: 135620:35:1, last LSN: 135621:34:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705210700.BAK'}). 2007-05-21 07:33:31.01 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:86:1, last LSN: 43302:88:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705210729.BAK'}). 2007-05-21 09:25:40.14 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 637485, first LSN: 135653:471:1, last LSN: 135663:450:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705210900.BAK'}). 2007-05-21 09:35:57.98 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:91:1, last LSN: 43302:126:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705210927.BAK'}). 2007-05-21 11:27:59.84 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 637813, first LSN: 135702:228:1, last LSN: 135714:225:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705211100.BAK'}). 2007-05-21 11:34:41.39 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105067, first LSN: 43302:129:1, last LSN: 43302:143:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705211130.BAK'}). 2007-05-21 13:27:35.52 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 637684, first LSN: 135743:97:1, last LSN: 135745:200:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705211300.BAK'}). 2007-05-21 13:34:24.43 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105237, first LSN: 43320:274:1, last LSN: 43320:280:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705211329.BAK'}). 2007-05-21 15:28:52.81 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 638085, first LSN: 135767:533:1, last LSN: 135776:450:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705211500.BAK'}). 2007-05-21 15:35:46.49 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105237, first LSN: 43320:283:1, last LSN: 43320:285:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705211531.BAK'}). 2007-05-21 17:30:32.95 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 638180, first LSN: 135811:510:1, last LSN: 135816:45:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705211700.BAK'}). 2007-05-21 17:37:16.62 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105237, first LSN: 43320:288:1, last LSN: 43320:290:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705211732.BAK'}). 2007-05-21 19:27:58.84 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 638284, first LSN: 135835:247:1, last LSN: 135841:93:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705211900.BAK'}). 2007-05-21 19:33:58.21 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105237, first LSN: 43320:435:1, last LSN: 43320:440:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705211929.BAK'}). 2007-05-21 21:27:51.79 backup Database backed up: Database: ocean_2006, creation date(time): 2006/05/08(17:23:08), pages dumped: 638348, first LSN: 135865:323:1, last LSN: 135869:419:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackupocean_2006ocean_2006_db_200705212100.BAK'}). 2007-05-21 21:33:59.65 backup Database backed up: Database: popovich, creation date(time): 2006/02/09(14:25:01), pages dumped: 105235, first LSN: 43322:42:1, last LSN: 43322:44:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:sql_baseackuppopovichpopovich_db_200705212130.BAK'}). 2007-05-21 22:45:38.29 backup Database backed up: Database: ocean, creation date(time): 2005/09/19(14:56:57), pages dumped: 1092947, first LSN: 154898:421:1, last LSN: 154898:426:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'F:oceanocean_db_200705212200.BAK'}). 2007-05-22 07:20:30.90 server SQL Server terminating because of system shutdown.
#6
by zenik
2007-05-19 08:26:02 - ? [393] Waiting for SQL Server to recover databases... 2007-05-19 08:26:04 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 2007-05-19 08:26:04 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID 1288 2007-05-19 08:26:04 - ? [101] SQL Server SERVER version 8.00.2039 (0 connection limit) 2007-05-19 08:26:04 - ? [102] SQL Server ODBC driver version 3.85.1022 2007-05-19 08:26:04 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is 2007-05-19 08:26:04 - ? [310] 4 processor(s) and 2048 MB RAM detected 2007-05-19 08:26:04 - ? [339] Local computer is SERVER running Windows NT 5.2 (3790) 2007-05-19 08:26:05 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent 2007-05-19 08:26:05 - ? [129] SQLSERVERAGENT starting under Windows NT service control 2007-05-19 08:26:05 - + [260] Unable to start mail session (reason: No mail profile defined) 2007-05-19 08:26:05 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect 2007-05-22 03:00:31 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 03:00:31 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 03:00:31 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 03:01:07 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 03:01:07 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 03:01:07 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 03:01:43 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 03:01:43 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 03:01:43 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 03:02:19 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 03:02:19 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 03:02:19 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 03:02:50 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 03:02:50 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 03:02:50 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp) 2007-05-22 03:03:22 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 03:03:22 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 03:03:22 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp) 2007-05-22 03:06:30 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 03:06:30 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 03:06:30 - ! [382] Logon to server '(local)' failed (SaveAllSchedules) 2007-05-22 06:00:31 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 06:00:31 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 06:00:31 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 06:01:07 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 06:01:07 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 06:01:07 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 06:01:43 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 06:01:43 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 06:01:43 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 06:02:19 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 06:02:19 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 06:02:19 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 06:02:51 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 06:02:51 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 06:02:51 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp) 2007-05-22 06:03:21 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 06:03:21 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 06:03:21 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp) 2007-05-22 06:07:01 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 06:07:01 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 06:07:01 - ! [382] Logon to server '(local)' failed (SaveAllSchedules) 2007-05-22 07:00:31 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:00:31 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:00:31 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 07:00:32 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:00:32 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:00:32 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 07:01:07 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:01:07 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:01:07 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 07:01:08 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:01:08 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:01:08 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 07:01:43 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:01:43 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:01:43 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 07:01:44 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:01:44 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:01:44 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 07:02:20 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:02:20 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:02:20 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 07:02:21 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:02:21 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:02:21 - ! [382] Logon to server '(local)' failed (JobManager) 2007-05-22 07:02:50 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:02:50 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:02:50 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp) 2007-05-22 07:02:51 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:02:51 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:02:51 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp) 2007-05-22 07:03:22 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:03:22 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:03:22 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp) 2007-05-22 07:03:23 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:03:23 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:03:23 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp) 2007-05-22 07:07:32 - ! [298] SQLServer Error: 17, SQL-сервер не существует, или отсутствует доступ. [SQLSTATE 08001] 2007-05-22 07:07:32 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect). [SQLSTATE 01000] 2007-05-22 07:07:32 - ! [382] Logon to server '(local)' failed (SaveAllSchedules) 2007-05-22 07:20:30 - ? [130] SQLSERVERAGENT stopping because of Windows shutdown... 2007-05-22 07:20:32 - ! [298] SQLServer Error: 1115, Не удается генерировать контекст SSPI [SQLSTATE HY000] 2007-05-22 07:20:32 - ! [382] Logon to server '(local)' failed (SaveAllSchedules) 2007-05-22 07:20:34 - ? [098] SQLServerAgent terminated (normally)
Тэги:
Ответить:
Комментарии доступны только авторизированным пользователям
Похожие вопросы 1С
- Ошибка SQL 924 при просмотре процессов SQL 2000 +1C 77
- SQL Server Enterprise Edition VS SQL Server Standard Edition
- Странная ошибка "ошибка формата потока" с вылетом из сеанса
- Ошибка в SQL БД ЗиК 7.7, При загрузке данных выдается ошибка
- Ошибка выполнения запроса "Ошибка при выполнении операции над данными: Ошибка SQL: Де
- v7: Ошибка СУБД.Внутренняя ошибка dbeng 8
- При отправке сообщения произошла ошибка : Общая ошибка MAPI
- Помогите восстановить базу после сбоя. Ошибка СУБД: Ошибка SQL....
- v8: Ошибка СУБД. Внутренняя ошибка компоненты DBENG8 при обмене данными
- Ошибка при попытке выгрузить данные из УТ в БП. интересная необычная ошибка
- v7: Ошибка SQL 08S01 Ошибка связи
- После обн. Windows Server 2008 R2 - ошибка доступа к SQL Server
В этой группе 1С
- Работа с датой
- Работа с матрицами
- vk_TerminalSleep - вопрос. Romix - АУ!
- Как в движении регистра получить привязку к строке документа?
- Вес брутто в счетах-фактурах
- SOAP + 1C 7.7 + Web Service Visual Studio 2005
- 1C+SQL жуткие тормоза
- Есть расшареная папка с базой 1с. Теперь вопрос.
- Перенос печатной формы из Exel
- Как определить док вводится на основании или нет
- Международные стандарты построения отчетов
- Не работает 1С 8.0.15.28 SQL на Vista Business
- Какая версия Управление торговлей ставиться на Платформу 8.1?
- Как в инструкции ВЫРАЗИТЬ указать два документа
- Экспорт Соответствия планов счетов БУ и МСФО
- Как превратить элемент справочника в предопределённый?
- Как получить адрес только то отредактированной ячейки таблицы
- Как выставить пиктограммы в журнале документов
- не читаются правильно тэги xml
- Как найти последний пробел в строке?