Ошибка SQL Server #273562


#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.. что покупать жаба давит?
#2 by masky
дай ка содержимое SQL Server and SQL Server Agent errorlogs..
#3 by zenik
Не душит... Уже купленный лежит... Лицензироваться руки не доходят :(
#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)
#7 by zenik
UP.
Тэги:
Ответить:
Комментарии доступны только авторизированным пользователям