Has anyone come across SQL server terminating unexpectably and then proceeding to restart itself. There is no alerts set to restart the process, there are no errors in SQL errorlog, in NT Event log there is a error that SQL terminated unexpectably , and then 1 second later a message that it is restarting as normal. Any clues or encounters of this behaivour before and fixes would be appreciated
View 3 RepliesWe have an application that runs against SQL Server 6.5 or 7.0. At one location that was recently upgraded from 6.5 to 7.0 we have a problem with the user connections to SQL Server not terminating when the user terminates the application. At some point, after several days, they are forced to bounce the server to eliminate the errant connections becasue SQL Server tells them they have the maximum number of connections. This only happens at one site and it happened under 6.5 as well. At all other sites, the connections terminate when the application terminates. Any ideas????
View 1 Replies View RelatedHiya
Since yesterday the sqlserver service has been falling over, my error logs says the below?
006-04-26 11:28:41.64 spid51 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'.
2006-04-26 11:28:41.92 spid51 Error: 15457, Severity: 0, State: 1
2006-04-26 11:28:41.92 spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2006-04-26 11:28:42.04 spid51 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.
2006-04-26 14:44:08.92 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.
What do I need to do? Is is just a matter of running the reconfigure script? Yesterday night we had some monitoring installed on the server. Can anyone help?
Thanks
Hi,
We're using SQL Server 2005 SP2, and got an error message of:
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
Does anyone know what is the cause of this error and how to fix it.
Thanks in advance, Maxim
Hello
My Server is restarting every time a OLAP process a cube dimension...
The query's are generated by the OLAP engine and are selecting from views that are depended on AS400 linked server.
I' m posting the log and dump
SQL Server Log
/*--------------------------------------------------------------*/
Date,Source,Severity,Message
06/30/2007 19:20:51,spid7s,Unknown,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
06/30/2007 19:20:51,spid70,Unknown,SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception<c/> or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error<c/> restart the server (unless SQLAgent is configured to auto restart).
06/30/2007 19:20:51,spid70,Unknown,Error: 17311<c/> Severity: 16<c/> State: 1.
06/30/2007 19:20:51,spid70,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/30/2007 19:20:49,spid70,Unknown,Stack Signature for the dump is 0x943A0CDA
06/30/2007 19:20:49,spid70,Unknown,78132A36 Module(MSVCR80+00002A36)
06/30/2007 19:20:49,spid70,Unknown,781329AA Module(MSVCR80+000029AA)
06/30/2007 19:20:49,spid70,Unknown,0146753D Module(sqlservr+0046753D)
06/30/2007 19:20:49,spid70,Unknown,01466761 Module(sqlservr+00466761)
06/30/2007 19:20:49,spid70,Unknown,014676D8 Module(sqlservr+004676D8)
06/30/2007 19:20:49,spid70,Unknown,014677E1 Module(sqlservr+004677E1)
06/30/2007 19:20:49,spid70,Unknown,01006F3B Module(sqlservr+00006F3B)
06/30/2007 19:20:49,spid70,Unknown,01006D4C Module(sqlservr+00006D4C)
06/30/2007 19:20:49,spid70,Unknown,01006C26 Module(sqlservr+00006C26)
06/30/2007 19:20:49,spid70,Unknown,0104A331 Module(sqlservr+0004A331)
06/30/2007 19:20:49,spid70,Unknown,0104AB65 Module(sqlservr+0004AB65)
06/30/2007 19:20:49,spid70,Unknown,01028C01 Module(sqlservr+00028C01)
06/30/2007 19:20:49,spid70,Unknown,01029D74 Module(sqlservr+00029D74)
06/30/2007 19:20:49,spid70,Unknown,010297DA Module(sqlservr+000297DA)
06/30/2007 19:20:49,spid70,Unknown,0103D211 Module(sqlservr+0003D211)
06/30/2007 19:20:49,spid70,Unknown,0103CEF9 Module(sqlservr+0003CEF9)
06/30/2007 19:20:49,spid70,Unknown,0103CFBA Module(sqlservr+0003CFBA)
06/30/2007 19:20:49,spid70,Unknown,0109DD66 Module(sqlservr+0009DD66)
06/30/2007 19:20:49,spid70,Unknown,0109FB6C Module(sqlservr+0009FB6C)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0138B3AB Module(sqlservr+0038B3AB)
06/30/2007 19:20:49,spid70,Unknown,010420A3 Module(sqlservr+000420A3)
06/30/2007 19:20:49,spid70,Unknown,01042083 Module(sqlservr+00042083)
06/30/2007 19:20:49,spid70,Unknown,01041E15 Module(sqlservr+00041E15)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E8EC Module(sqlservr+0034E8EC)
06/30/2007 19:20:49,spid70,Unknown,0134E600 Module(sqlservr+0034E600)
06/30/2007 19:20:49,spid70,Unknown,0104019A Module(sqlservr+0004019A)
06/30/2007 19:20:49,spid70,Unknown,0104E95A Module(sqlservr+0004E95A)
06/30/2007 19:20:49,spid70,Unknown,014E7287 Module(sqlservr+004E7287)
06/30/2007 19:20:49,spid70,Unknown,01E53EEB Module(sqlservr+00E53EEB)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134EE0E Module(sqlservr+0034EE0E)
06/30/2007 19:20:49,spid70,Unknown,013513CB Module(sqlservr+003513CB)
06/30/2007 19:20:49,spid70,Unknown,0134EEBA Module(sqlservr+0034EEBA)
06/30/2007 19:20:49,spid70,Unknown,0134FB31 Module(sqlservr+0034FB31)
06/30/2007 19:20:49,spid70,Unknown,0134E7DE Module(sqlservr+0034E7DE)
06/30/2007 19:20:49,spid70,Unknown,0138B3AB Module(sqlservr+0038B3AB)
06/30/2007 19:20:49,spid70,Unknown,010420A3 Module(sqlservr+000420A3)
06/30/2007 19:20:49,spid70,Unknown,01042083 Module(sqlservr+00042083)
06/30/2007 19:20:49,spid70,Unknown,01041E15 Module(sqlservr+00041E15)
06/30/2007 19:20:49,spid70,Unknown,01E4E7C6 Module(sqlservr+00E4E7C6)
06/30/2007 19:20:49,spid70,Unknown,01E4F63E Module(sqlservr+00E4F63E)
06/30/2007 19:20:49,spid70,Unknown,0171A1E6 Module(sqlservr+0071A1E6)
06/30/2007 19:20:49,spid70,Unknown,01718FE0 Module(sqlservr+00718FE0)
06/30/2007 19:20:49,spid70,Unknown,017033EB Module(sqlservr+007033EB)
06/30/2007 19:20:49,spid70,Unknown,017031E2 Module(sqlservr+007031E2)
06/30/2007 19:20:49,spid70,Unknown,88000000 Module(UNKNOWN+00000000)
06/30/2007 19:20:49,spid70,Unknown,* Short Stack Dump
06/30/2007 19:20:49,spid70,Unknown,* -------------------------------------------------------------------------------
06/30/2007 19:20:49,spid70,Unknown,* *******************************************************************************
06/30/2007 19:20:49,spid70,Unknown,* SegSs: 00000023:
06/30/2007 19:20:49,spid70,Unknown,* Esp: 075FEE1C: 017031E2 65006900 015C37F8 075FEE3C 075F8169 00000000
06/30/2007 19:20:49,spid70,Unknown,* EFlags: 00010246: 004E005F 00000054 00610050 00680074 0043003D 005C003A
06/30/2007 19:20:49,spid70,Unknown,* SegCs: 0000001B:
06/30/2007 19:20:49,spid70,Unknown,* Ebp: 075FEEA4: 075FEFB8 017033EB 015C37F8 65006900 0109CFA4 00000001
06/30/2007 19:20:49,spid70,Unknown,* Eip: 88000000: 00040101 00010000 00001D15 00550001 00001D30 00190001
06/30/2007 19:20:49,spid70,Unknown,* Edx: 015C37F8: 0C733A1D 11CE2A1C AA00E5AD 3D774400 0C733A5D 11CE2A1C
06/30/2007 19:20:49,spid70,Unknown,* Ecx: 075FEE3C: 00000000 00936188 00000000 5E2200E8 00000000 00000000
06/30/2007 19:20:49,spid70,Unknown,* Ebx: 65006900: 00140001 0000A80D 00671B36 000AEC00 00000300 00140001
06/30/2007 19:20:49,spid70,Unknown,* Eax: 88000000: 00040101 00010000 00001D15 00550001 00001D30 00190001
06/30/2007 19:20:49,spid70,Unknown,* Esi: 6F179D58: 6F179DC8 2DA5069E 11D656C4 20005B92 3997AE35 00000000
06/30/2007 19:20:49,spid70,Unknown,* Edi: 00000000:
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* dbghelp 09660000 09774FFF 00115000
06/30/2007 19:20:49,spid70,Unknown,* sqlvdi 072B0000 072D1FFF 00022000
06/30/2007 19:20:49,spid70,Unknown,* SXS 75DA0000 75E5BFFF 000bc000
06/30/2007 19:20:49,spid70,Unknown,* adsldp 08DE0000 08E0DFFF 0002e000
06/30/2007 19:20:49,spid70,Unknown,* ATL 76A80000 76A97FFF 00018000
06/30/2007 19:20:49,spid70,Unknown,* credui 76B80000 76BADFFF 0002e000
06/30/2007 19:20:49,spid70,Unknown,* adsldpc 76DC0000 76DE6FFF 00027000
06/30/2007 19:20:49,spid70,Unknown,* activeds 76DF0000 76E22FFF 00033000
06/30/2007 19:20:49,spid70,Unknown,* cwbcomsg 08DD0000 08DDEFFF 0000f000
06/30/2007 19:20:49,spid70,Unknown,* comsvcs 75B70000 75CA8FFF 00139000
06/30/2007 19:20:49,spid70,Unknown,* CWBZMODB 08CC0000 08CC3FFF 00004000
06/30/2007 19:20:49,spid70,Unknown,* CWBSOMRI 08CA0000 08CADFFF 0000e000
06/30/2007 19:20:49,spid70,Unknown,* cwbdt 08AF0000 08AF7FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* cwbdq 08AD0000 08AEDFFF 0001e000
06/30/2007 19:20:49,spid70,Unknown,* cwbbspc 08AB0000 08AC3FFF 00014000
06/30/2007 19:20:49,spid70,Unknown,* cwbbsspi 08AA0000 08AAFFFF 00010000
06/30/2007 19:20:49,spid70,Unknown,* cwbnl 08A90000 08A94FFF 00005000
06/30/2007 19:20:49,spid70,Unknown,* cwbad 08A80000 08A83FFF 00004000
06/30/2007 19:20:49,spid70,Unknown,* cwbco 08A70000 08A74FFF 00005000
06/30/2007 19:20:49,spid70,Unknown,* cwbsv 08A60000 08A65FFF 00006000
06/30/2007 19:20:49,spid70,Unknown,* cwbunssl 08A40000 08A51FFF 00012000
06/30/2007 19:20:49,spid70,Unknown,* cwbrc 08A30000 08A3EFFF 0000f000
06/30/2007 19:20:49,spid70,Unknown,* cwbsof 08A00000 08A2EFFF 0002f000
06/30/2007 19:20:49,spid70,Unknown,* CWBUNPLA 089B0000 089F2FFF 00043000
06/30/2007 19:20:49,spid70,Unknown,* cwbad1 089A0000 089A7FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* SHFOLDER 766D0000 766D8FFF 00009000
06/30/2007 19:20:49,spid70,Unknown,* MSVCIRT 08990000 0899FFFF 00010000
06/30/2007 19:20:49,spid70,Unknown,* cwbrw 08960000 08989FFF 0002a000
06/30/2007 19:20:49,spid70,Unknown,* iertutil 08910000 08954FFF 00045000
06/30/2007 19:20:49,spid70,Unknown,* Normaliz 08900000 08908FFF 00009000
06/30/2007 19:20:49,spid70,Unknown,* WININET 08830000 088FEFFF 000cf000
06/30/2007 19:20:49,spid70,Unknown,* MFC42u 08700000 08823FFF 00124000
06/30/2007 19:20:49,spid70,Unknown,* cwbunpls 068E0000 068EBFFF 0000c000
06/30/2007 19:20:49,spid70,Unknown,* cwbcore 08610000 086F6FFF 000e7000
06/30/2007 19:20:49,spid70,Unknown,* cwbdc 085E0000 08606FFF 00027000
06/30/2007 19:20:49,spid70,Unknown,* cwbzzodb 084E0000 085DDFFF 000fe000
06/30/2007 19:20:49,spid70,Unknown,* OLEDB32R 068C0000 068D0FFF 00011000
06/30/2007 19:20:49,spid70,Unknown,* MSDART 74A50000 74A69FFF 0001a000
06/30/2007 19:20:49,spid70,Unknown,* oledb32 070B0000 07128FFF 00079000
06/30/2007 19:20:49,spid70,Unknown,* xplog70 08070000 08072FFF 00003000
06/30/2007 19:20:49,spid70,Unknown,* xplog70 08050000 0805BFFF 0000c000
06/30/2007 19:20:49,spid70,Unknown,* xpstar90 08020000 08045FFF 00026000
06/30/2007 19:20:49,spid70,Unknown,* odbcint 08000000 08016FFF 00017000
06/30/2007 19:20:49,spid70,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
06/30/2007 19:20:49,spid70,Unknown,* BatchParser90 07E90000 07EAEFFF 0001f000
06/30/2007 19:20:49,spid70,Unknown,* ODBC32 07E50000 07E8CFFF 0003d000
06/30/2007 19:20:49,spid70,Unknown,* SQLSCM90 07E30000 07E38FFF 00009000
06/30/2007 19:20:49,spid70,Unknown,* xpstar90 07DD0000 07E18FFF 00049000
06/30/2007 19:20:49,spid70,Unknown,* xpsqlbot 07DB0000 07DB5FFF 00006000
06/30/2007 19:20:49,spid70,Unknown,* msftepxy 07130000 07144FFF 00015000
06/30/2007 19:20:49,spid70,Unknown,* SQLNCLIR 007A0000 007D2FFF 00033000
06/30/2007 19:20:49,spid70,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
06/30/2007 19:20:49,spid70,Unknown,* COMCTL32 77530000 775C6FFF 00097000
06/30/2007 19:20:49,spid70,Unknown,* sqlncli 337A0000 339C3FFF 00224000
06/30/2007 19:20:49,spid70,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
06/30/2007 19:20:49,spid70,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
06/30/2007 19:20:49,spid70,Unknown,* ntdsapi 766F0000 76704FFF 00015000
06/30/2007 19:20:49,spid70,Unknown,* SAMLIB 06F70000 06F7EFFF 0000f000
06/30/2007 19:20:49,spid70,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
06/30/2007 19:20:49,spid70,Unknown,* dssenh 06F80000 06FA3FFF 00024000
06/30/2007 19:20:49,spid70,Unknown,* imagehlp 76C10000 76C38FFF 00029000
06/30/2007 19:20:49,spid70,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
06/30/2007 19:20:49,spid70,Unknown,* dbghelp 06C10000 06D24FFF 00115000
06/30/2007 19:20:49,spid70,Unknown,* msfte 069B0000 06C08FFF 00259000
06/30/2007 19:20:49,spid70,Unknown,* security 06190000 06193FFF 00004000
06/30/2007 19:20:49,spid70,Unknown,* wshtcpip 05CC0000 05CC7FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* hnetcfg 05C20000 05C78FFF 00059000
06/30/2007 19:20:49,spid70,Unknown,* rasadhlp 76F80000 76F87FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
06/30/2007 19:20:49,spid70,Unknown,* winrnr 76F70000 76F76FFF 00007000
06/30/2007 19:20:49,spid70,Unknown,* DNSAPI 76ED0000 76EFEFFF 0002f000
06/30/2007 19:20:49,spid70,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
06/30/2007 19:20:49,spid70,Unknown,* VERSION 77B90000 77B97FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* MTXCLU 74F40000 74F58FFF 00019000
06/30/2007 19:20:49,spid70,Unknown,* msvcp60 780C0000 78120FFF 00061000
06/30/2007 19:20:49,spid70,Unknown,* MSDTCPRX 05B30000 05BA7FFF 00078000
06/30/2007 19:20:49,spid70,Unknown,* XOLEHLP 05B20000 05B25FFF 00006000
06/30/2007 19:20:49,spid70,Unknown,* COMRES 77010000 770D5FFF 000c6000
06/30/2007 19:20:49,spid70,Unknown,* schannel 76750000 76776FFF 00027000
06/30/2007 19:20:49,spid70,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
06/30/2007 19:20:49,spid70,Unknown,* kerberos 05A70000 05AC7FFF 00058000
06/30/2007 19:20:49,spid70,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
06/30/2007 19:20:49,spid70,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
06/30/2007 19:20:49,spid70,Unknown,* MSCOREE 05800000 05844FFF 00045000
06/30/2007 19:20:49,spid70,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
06/30/2007 19:20:49,spid70,Unknown,* rsaenh 04D20000 04D4EFFF 0002f000
06/30/2007 19:20:49,spid70,Unknown,* SQLOS 344D0000 344D4FFF 00005000
06/30/2007 19:20:49,spid70,Unknown,* sqlevn70 4F610000 4F7B8FFF 001a9000
06/30/2007 19:20:49,spid70,Unknown,* RESUTILS 74EF0000 74F02FFF 00013000
06/30/2007 19:20:49,spid70,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
06/30/2007 19:20:49,spid70,Unknown,* ole32 77670000 777A3FFF 00134000
06/30/2007 19:20:49,spid70,Unknown,* CLUSAPI 74DE0000 74DF1FFF 00012000
06/30/2007 19:20:49,spid70,Unknown,* instapi 48060000 48069FFF 0000a000
06/30/2007 19:20:49,spid70,Unknown,* psapi 76B70000 76B7AFFF 0000b000
06/30/2007 19:20:49,spid70,Unknown,* comctl32 77420000 77522FFF 00103000
06/30/2007 19:20:49,spid70,Unknown,* IMM32 76290000 762ACFFF 0001d000
06/30/2007 19:20:49,spid70,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
06/30/2007 19:20:49,spid70,Unknown,* SHELL32 7C8D0000 7D0D3FFF 00804000
06/30/2007 19:20:49,spid70,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
06/30/2007 19:20:49,spid70,Unknown,* opends60 333E0000 333E6FFF 00007000
06/30/2007 19:20:49,spid70,Unknown,* USERENV 76920000 769E3FFF 000c4000
06/30/2007 19:20:49,spid70,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
06/30/2007 19:20:49,spid70,Unknown,* WS2_32 71C00000 71C16FFF 00017000
06/30/2007 19:20:49,spid70,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
06/30/2007 19:20:49,spid70,Unknown,* Secur32 76F50000 76F62FFF 00013000
06/30/2007 19:20:49,spid70,Unknown,* MSASN1 76190000 761A1FFF 00012000
06/30/2007 19:20:49,spid70,Unknown,* CRYPT32 761B0000 76242FFF 00093000
06/30/2007 19:20:49,spid70,Unknown,* GDI32 77C00000 77C48FFF 00049000
06/30/2007 19:20:49,spid70,Unknown,* USER32 77380000 77411FFF 00092000
06/30/2007 19:20:49,spid70,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
06/30/2007 19:20:49,spid70,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
06/30/2007 19:20:49,spid70,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
06/30/2007 19:20:49,spid70,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
06/30/2007 19:20:49,spid70,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
06/30/2007 19:20:49,spid70,Unknown,* kernel32 77E40000 77F41FFF 00102000
06/30/2007 19:20:49,spid70,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
06/30/2007 19:20:49,spid70,Unknown,* sqlservr 01000000 02C0AFFF 01c0b000
06/30/2007 19:20:49,spid70,Unknown,* MODULE BASE END SIZE
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* _ccost].[dbo_dim_ccostCOST_ID2_1] ) )
06/30/2007 19:20:49,spid70,Unknown,* OST_ID] ) AND ( [dimUserNameCCost].[COST_ID] = [dbo_dim
06/30/2007 19:20:49,spid70,Unknown,* ( [dbo_dim_ccost].[dbo_dim_ccostCOST_ID2_1] = [dbo_dim_ccost1].[C
06/30/2007 19:20:49,spid70,Unknown,* dimDIV_CCOST_USERNAME] ) AS [dbo_dim_ccost] WHERE (
06/30/2007 19:20:49,spid70,Unknown,* o_dim_ccostdiv2_0]<c/>[COST_ID] AS [dbo_dim_ccostCOST_ID2_1] FROM [dbo].[
06/30/2007 19:20:49,spid70,Unknown,* t] AS [dbo_dim_ccost1]<c/> ( SELECT DISTINCT [div] AS [db
06/30/2007 19:20:49,spid70,Unknown,* M dimUserNameCCost ) AS [dimUserNameCCost]<c/>[dbo].[dim_ccos
06/30/2007 19:20:49,spid70,Unknown,* SAMACCOUNTNAME + 'MEGATV' AS USR<c/> USERNAME<c/> COST_ID<c/> displayname FRO
06/30/2007 19:20:49,spid70,Unknown,* .[dbo_dim_ccostdiv2_0] AS [dbo_dim_ccostdiv2_0] FROM ( SELECT
06/30/2007 19:20:49,spid70,Unknown,* im_ccost1].[COST_DESCR] AS [dbo_dim_ccost1COST_DESCR1_0]<c/>[dbo_dim_ccost]
06/30/2007 19:20:49,spid70,Unknown,* 0_2]<c/>[dimUserNameCCost].[COST_ID] AS [dimUserNameCCostCOST_ID0_3]<c/>[dbo_d
06/30/2007 19:20:49,spid70,Unknown,* AME0_1]<c/>[dimUserNameCCost].[displayname] AS [dimUserNameCCostdisplayname
06/30/2007 19:20:49,spid70,Unknown,* NameCCostUSR0_0]<c/>[dimUserNameCCost].[USERNAME] AS [dimUserNameCCostUSERN
06/30/2007 19:20:49,spid70,Unknown,* SELECT DISTINCT [dimUserNameCCost].[USR] AS [dimUser
06/30/2007 19:20:49,spid70,Unknown,* Input Buffer 510 bytes -
06/30/2007 19:20:49,spid70,Unknown,* Access Violation occurred writing address 88000000
06/30/2007 19:20:49,spid70,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
06/30/2007 19:20:49,spid70,Unknown,* Exception Address = 88000000 Module(UNKNOWN+00000000)
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* 06/30/07 19:20:49 spid 70
06/30/2007 19:20:49,spid70,Unknown,* BEGIN STACK DUMP:
06/30/2007 19:20:49,spid70,Unknown,*
06/30/2007 19:20:49,spid70,Unknown,* *******************************************************************************
06/30/2007 19:20:49,spid70,Unknown,SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
06/30/2007 19:20:49,spid70,Unknown,***Stack Dump being sent to S:MSSQLMSSQL.1MSSQLLOGSQLDump0008.txt
06/30/2007 19:20:49,spid70,Unknown,Using 'dbghelp.dll' version '4.0.5'
06/30/2007 04:07:01,Backup,Unknown,Database backed up. Database: tvmar<c/> creation date(time): 2007/04/18(20:36:58)<c/> pages dumped: 1126<c/> first LSN: 185:4607:48<c/> last LSN: 185:4627:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#625feb9b-cc56-49ad-8b8f-24471cc2d889'}). This is an informational message only. No user action is required.
06/30/2007 04:06:59,Backup,Unknown,Database backed up. Database: msdb<c/> creation date(time): 2005/10/14(01:54:05)<c/> pages dumped: 1579<c/> first LSN: 741:216:261<c/> last LSN: 741:328:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#af5c48e2-5b0b-4042-868d-6b28f7f5d657'}). This is an informational message only. No user action is required.
06/30/2007 04:06:55,Backup,Unknown,Database backed up. Database: model<c/> creation date(time): 2003/04/08(09:13:36)<c/> pages dumped: 189<c/> first LSN: 37:416:37<c/> last LSN: 37:440:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c79803b2-6fad-4187-b658-66d71ceb315e'}). This is an informational message only. No user action is required.
06/30/2007 04:06:53,Backup,Unknown,Database backed up. Database: master<c/> creation date(time): 2007/06/28(13:34:15)<c/> pages dumped: 387<c/> first LSN: 1076:400:37<c/> last LSN: 1076:424:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c4a63fb1-ad81-44c0-8625-a2e18e1ac6ec'}). This is an informational message only. No user action is required.
06/30/2007 04:06:50,Backup,Unknown,Database backed up. Database: intranet<c/> creation date(time): 2007/03/21(14:33:52)<c/> pages dumped: 219<c/> first LSN: 27:659:37<c/> last LSN: 27:675:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#46625684-d128-4a77-8d48-bd55a043773a'}). This is an informational message only. No user action is required.
06/30/2007 04:06:48,Backup,Unknown,Database backed up. Database: facilityTest<c/> creation date(time): 2007/03/30(19:23:59)<c/> pages dumped: 7600<c/> first LSN: 242:20105:207<c/> last LSN: 242:20187:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#717e4863-92f3-4060-9a96-cfbdaf7574ca'}). This is an informational message only. No user action is required.
06/30/2007 04:06:44,Backup,Unknown,Database backed up. Database: as400<c/> creation date(time): 2007/03/29(16:40:01)<c/> pages dumped: 187<c/> first LSN: 31:81:37<c/> last LSN: 31:97:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#94c2f4db-37ad-42a0-842a-4ee151868f39'}). This is an informational message only. No user action is required.
06/30/2007 04:06:41,Backup,Unknown,Database backed up. Database: RCREW_EURO<c/> creation date(time): 2007/03/20(15:04:19)<c/> pages dumped: 787<c/> first LSN: 26:4189:37<c/> last LSN: 26:4205:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#45e46e0c-dc9e-4895-8fd6-b96ac9717094'}). This is an informational message only. No user action is required.
06/30/2007 04:06:38,Backup,Unknown,Database backed up. Database: RCREW<c/> creation date(time): 2007/03/20(14:54:00)<c/> pages dumped: 683<c/> first LSN: 27:3697:37<c/> last LSN: 27:3713:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#353bb158-7e11-45c4-8eef-c04721a42df8'}). This is an informational message only. No user action is required.
06/30/2007 04:06:36,Backup,Unknown,Database backed up. Database: ORIGINTICKER<c/> creation date(time): 2007/03/21(17:50:58)<c/> pages dumped: 1015885<c/> first LSN: 3543267:95:104<c/> last LSN: 3543267:1129:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2b249260-808e-4abf-9a46-6117c58788b6'}). This is an informational message only. No user action is required.
06/30/2007 04:04:17,Backup,Unknown,Database backed up. Database: OCCUPATION<c/> creation date(time): 2007/03/30(19:19:29)<c/> pages dumped: 10315<c/> first LSN: 29:66521:69<c/> last LSN: 29:66549:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#ff36832c-71d7-4e58-b3b6-1c2e44afcae4'}). This is an informational message only. No user action is required.
06/30/2007 04:04:13,Backup,Unknown,Database backed up. Database: NEWSLINE<c/> creation date(time): 2007/03/23(15:14:29)<c/> pages dumped: 539<c/> first LSN: 27:2842:37<c/> last LSN: 27:2858:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#953b7822-79c0-4e47-8806-2cdc01633de0'}). This is an informational message only. No user action is required.
06/30/2007 04:04:10,Backup,Unknown,Database backed up. Database: NEWSFILE<c/> creation date(time): 2007/03/23(11:49:44)<c/> pages dumped: 223872<c/> first LSN: 5679:18451:91<c/> last LSN: 5679:18498:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e90a643f-0ab4-43af-82ed-50b85835ac65'}). This is an informational message only. No user action is required.
06/30/2007 04:03:28,Backup,Unknown,Database backed up. Database: MegaLIB<c/> creation date(time): 2007/05/17(16:20:40)<c/> pages dumped: 187<c/> first LSN: 34:1747:37<c/> last LSN: 34:1763:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c3d1693b-cc9c-4556-a5bf-f98a3e303755'}). This is an informational message only. No user action is required.
06/30/2007 04:03:25,Backup,Unknown,Database backed up. Database: INVENTORY<c/> creation date(time): 2007/03/23(12:17:43)<c/> pages dumped: 11966<c/> first LSN: 412:1404:95<c/> last LSN: 412:1443:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#901722b7-e555-46f1-8e11-f84994ef133e'}). This is an informational message only. No user action is required.
06/30/2007 04:03:19,Backup,Unknown,Database backed up. Database: INEWS<c/> creation date(time): 2007/03/23(14:23:54)<c/> pages dumped: 15643<c/> first LSN: 95:24345:79<c/> last LSN: 95:24378:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2e399870-8002-4b6c-bdad-906245fcc331'}). This is an informational message only. No user action is required.
06/30/2007 04:03:15,Backup,Unknown,Database backed up. Database: HyperionSS<c/> creation date(time): 2007/03/19(17:55:10)<c/> pages dumped: 349<c/> first LSN: 124:2015:74<c/> last LSN: 124:2045:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#5138e34c-9a19-4ff7-92e2-42a0e1af7a6a'}). This is an informational message only. No user action is required.
06/30/2007 04:03:12,Backup,Unknown,Database backed up. Database: HyperionBI<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 1099<c/> first LSN: 48:1336:37<c/> last LSN: 48:1352:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#ceeecf9e-6d4b-4ec4-b541-635cfa1a7012'}). This is an informational message only. No user action is required.
06/30/2007 04:03:09,Backup,Unknown,Database backed up. Database: HyperionAIS<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 195<c/> first LSN: 44:704:37<c/> last LSN: 44:720:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#798e76c1-c6bb-45a1-ac7c-73a7c386b090'}). This is an informational message only. No user action is required.
06/30/2007 04:03:07,Backup,Unknown,Database backed up. Database: HyperionAAS<c/> creation date(time): 2007/03/19(17:53:48)<c/> pages dumped: 491<c/> first LSN: 45:2848:37<c/> last LSN: 45:2864:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#f7d829ef-a850-43ba-a576-d7293254ccf4'}). This is an informational message only. No user action is required.
06/30/2007 04:03:04,Backup,Unknown,Database backed up. Database: HOTLINE<c/> creation date(time): 2007/03/20(10:54:42)<c/> pages dumped: 267<c/> first LSN: 25:4137:37<c/> last LSN: 25:4153:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#92a1de2a-936d-4048-8c5e-05b6ab2434d2'}). This is an informational message only. No user action is required.
06/30/2007 04:03:02,Backup,Unknown,Database backed up. Database: EMEDIA<c/> creation date(time): 2007/03/26(12:27:39)<c/> pages dumped: 235<c/> first LSN: 59:1198:58<c/> last LSN: 59:1222:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#7e28ff07-08e6-4eed-bf80-38ba1e4627ea'}). This is an informational message only. No user action is required.
06/30/2007 04:02:59,Backup,Unknown,Database backed up. Database: EKLOGES_OLD<c/> creation date(time): 2007/03/19(15:17:03)<c/> pages dumped: 291<c/> first LSN: 26:439:37<c/> last LSN: 26:455:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#dc8d9b3e-7928-42b9-9e61-32ae03d68a56'}). This is an informational message only. No user action is required.
06/30/2007 04:02:56,Backup,Unknown,Database backed up. Database: EKLOGES_2006w1<c/> creation date(time): 2007/03/19(15:13:58)<c/> pages dumped: 2475<c/> first LSN: 26:19205:37<c/> last LSN: 26:19221:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#67613979-2561-4519-a919-ce7ee21d01e5'}). This is an informational message only. No user action is required.
06/30/2007 04:02:49,Backup,Unknown,Database backed up. Database: EKLOGES_2004v<c/> creation date(time): 2007/03/19(14:59:27)<c/> pages dumped: 3143<c/> first LSN: 60:982:37<c/> last LSN: 60:998:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a19662a8-4397-4ee3-bd06-d58f2e010203'}). This is an informational message only. No user action is required.
06/30/2007 04:02:46,Backup,Unknown,Database backed up. Database: EKLOGES_2002w2<c/> creation date(time): 2007/03/19(14:52:44)<c/> pages dumped: 3555<c/> first LSN: 26:13056:37<c/> last LSN: 26:13072:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#8f1f1d10-b189-43fc-aed8-0c92ece14d41'}). This is an informational message only. No user action is required.
06/30/2007 04:02:43,Backup,Unknown,Database backed up. Database: EKLOGES_2002w1<c/> creation date(time): 2007/03/19(14:50:21)<c/> pages dumped: 2579<c/> first LSN: 25:16928:37<c/> last LSN: 25:16944:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c2c3f2e9-1ccf-4721-982b-4d17f38457a9'}). This is an informational message only. No user action is required.
06/30/2007 04:02:40,Backup,Unknown,Database backed up. Database: EKLOGES<c/> creation date(time): 2007/03/19(14:45:35)<c/> pages dumped: 6667<c/> first LSN: 40:2427:37<c/> last LSN: 40:2443:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9cc652ff-96da-48bf-bc4c-ebc5ca53d010'}). This is an informational message only. No user action is required.
06/30/2007 04:02:35,Backup,Unknown,Database backed up. Database: EDUCATION<c/> creation date(time): 2007/03/19(15:24:25)<c/> pages dumped: 515<c/> first LSN: 25:9018:37<c/> last LSN: 25:9034:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#dbe7459f-c466-456f-ad68-4cef5d73f21f'}). This is an informational message only. No user action is required.
06/30/2007 04:02:33,Backup,Unknown,Database backed up. Database: CitrixDS<c/> creation date(time): 2007/03/26(17:43:57)<c/> pages dumped: 539<c/> first LSN: 27:7897:37<c/> last LSN: 27:7913:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#3b027d4d-4e2f-4c0e-b555-b7a4f8a25c66'}). This is an informational message only. No user action is required.
06/30/2007 04:02:29,Backup,Unknown,Database backed up. Database: CSDB7<c/> creation date(time): 2007/04/19(13:27:08)<c/> pages dumped: 2865<c/> first LSN: 198:413:37<c/> last LSN: 198:429:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#247141fd-14a3-4fdf-9de0-97688403c6fa'}). This is an informational message only. No user action is required.
06/30/2007 04:02:26,Backup,Unknown,Database backed up. Database: CSDB<c/> creation date(time): 2007/03/26(16:18:53)<c/> pages dumped: 2354<c/> first LSN: 158:464:37<c/> last LSN: 158:480:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#449a6f8a-be30-4c65-a590-8fd67a5b000f'}). This is an informational message only. No user action is required.
06/30/2007 04:02:23,Backup,Unknown,Database backed up. Database: ANALYZ72<c/> creation date(time): 2007/03/20(11:51:27)<c/> pages dumped: 307<c/> first LSN: 25:4012:37<c/> last LSN: 25:4028:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d9869b3-cce4-4c71-8747-19e955367fec'}). This is an informational message only. No user action is required.
06/30/2007 04:02:20,Backup,Unknown,Database backed up. Database: AEPI<c/> creation date(time): 2007/03/21(16:08:39)<c/> pages dumped: 7843<c/> first LSN: 29:15235:81<c/> last LSN: 29:15268:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#4dbe1fa4-0089-48a0-8b46-54ff5679d3e5'}). This is an informational message only. No user action is required.
06/30/2007 00:00:04,spid17s,Unknown,This instance of SQL Server has been using a process ID of 4788 since 28/6/2007 1:34:28 μμ (local) 28/6/2007 10:34:28 πμ (UTC). This is an informational message only; no user action is required.
06/29/2007 23:22:15,Logon,Unknown,Login failed for user 'MEGATVsuper1'. [CLIENT: 10.1.0.90]
06/29/2007 23:22:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/29/2007 15:42:34,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:34,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:32,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:32,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:20,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:20,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:16,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:16,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:13,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:13,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:11,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:11,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:09,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:06,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:06,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:01,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:01,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:42:00,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:42:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:58,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:58,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:50,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:50,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:41:10,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:41:10,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:58,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:58,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:40,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:40,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:21,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:21,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:15,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:40:12,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:40:12,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:39:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:39:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:39:24,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:39:24,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:35,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:38:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:38:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:37:59,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:37:59,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:37:54,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:37:54,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:35,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:30,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:30,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:20,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:20,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:19,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:19,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:17,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:17,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:15,Logon,Unknown,Login failed for user 'gavogiac'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:15,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/29/2007 15:36:09,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:05,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:05,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:36:00,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:36:00,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:54,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:54,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:49,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:49,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:44,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:38,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:38,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:29,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:29,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:35:25,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:35:25,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:36,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:36,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:31,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:34:31,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:34:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:33:55,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:33:55,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:33:43,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:33:43,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:32:56,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:32:56,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:30:23,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:30:23,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:30:02,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:30:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:28:08,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:28:08,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 15:27:55,Logon,Unknown,Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 10.1.0.90]
06/29/2007 15:27:55,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.
06/29/2007 04:07:52,Backup,Unknown,Database backed up. Database: tvmar<c/> creation date(time): 2007/04/18(20:36:58)<c/> pages dumped: 1126<c/> first LSN: 185:4003:48<c/> last LSN: 185:4023:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#5687baaa-002a-4f65-8bb7-2f2ba5d735df'}). This is an informational message only. No user action is required.
06/29/2007 04:07:49,Backup,Unknown,Database backed up. Database: msdb<c/> creation date(time): 2005/10/14(01:54:05)<c/> pages dumped: 1579<c/> first LSN: 732:176:173<c/> last LSN: 732:256:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e05a8e22-2f32-492e-8412-145e9b9b9b09'}). This is an informational message only. No user action is required.
06/29/2007 04:07:45,Backup,Unknown,Database backed up. Database: model<c/> creation date(time): 2003/04/08(09:13:36)<c/> pages dumped: 189<c/> first LSN: 37:352:37<c/> last LSN: 37:376:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d2c5054-e7c1-4bdf-9799-b22b2c050f9d'}). This is an informational message only. No user action is required.
06/29/2007 04:07:43,Backup,Unknown,Database backed up. Database: master<c/> creation date(time): 2007/06/28(13:34:15)<c/> pages dumped: 387<c/> first LSN: 1063:488:37<c/> last LSN: 1064:16:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b18252f8-58b9-4997-9c24-f18f49a92f19'}). This is an informational message only. No user action is required.
06/29/2007 04:07:40,Backup,Unknown,Database backed up. Database: intranet<c/> creation date(time): 2007/03/21(14:33:52)<c/> pages dumped: 219<c/> first LSN: 27:635:37<c/> last LSN: 27:651:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#f16b3299-bedc-4c50-b223-b49a59247f72'}). This is an informational message only. No user action is required.
06/29/2007 04:07:37,Backup,Unknown,Database backed up. Database: facilityTest<c/> creation date(time): 2007/03/30(19:23:59)<c/> pages dumped: 7592<c/> first LSN: 242:16437:260<c/> last LSN: 242:16540:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#40b0b72f-e411-47ab-be0e-873148db25ad'}). This is an informational message only. No user action is required.
06/29/2007 04:07:32,Backup,Unknown,Database backed up. Database: as400<c/> creation date(time): 2007/03/29(16:40:01)<c/> pages dumped: 187<c/> first LSN: 31:57:37<c/> last LSN: 31:73:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#666a5305-593a-4079-8b5f-1d3b32198312'}). This is an informational message only. No user action is required.
06/29/2007 04:07:29,Backup,Unknown,Database backed up. Database: RCREW_EURO<c/> creation date(time): 2007/03/20(15:04:19)<c/> pages dumped: 787<c/> first LSN: 26:4165:37<c/> last LSN: 26:4181:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2666bdfc-27c7-4131-a923-cfafd2843977'}). This is an informational message only. No user action is required.
06/29/2007 04:07:27,Backup,Unknown,Database backed up. Database: RCREW<c/> creation date(time): 2007/03/20(14:54:00)<c/> pages dumped: 683<c/> first LSN: 27:3673:37<c/> last LSN: 27:3689:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9230e56f-cf09-47b1-9655-f854eda23636'}). This is an informational message only. No user action is required.
06/29/2007 04:07:24,Backup,Unknown,Database backed up. Database: ORIGINTICKER<c/> creation date(time): 2007/03/21(17:50:58)<c/> pages dumped: 1013805<c/> first LSN: 3537241:231:143<c/> last LSN: 3537249:1119:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#306bb758-9bc1-48fd-88bc-68b38e83e30b'}). This is an informational message only. No user action is required.
06/29/2007 04:05:07,Backup,Unknown,Database backed up. Database: OCCUPATION<c/> creation date(time): 2007/03/30(19:19:29)<c/> pages dumped: 10315<c/> first LSN: 29:66381:78<c/> last LSN: 29:66413:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a10445fe-fb7c-4721-891a-2a588c17f8e1'}). This is an informational message only. No user action is required.
06/29/2007 04:05:02,Backup,Unknown,Database backed up. Database: NEWSLINE<c/> creation date(time): 2007/03/23(15:14:29)<c/> pages dumped: 539<c/> first LSN: 27:2818:37<c/> last LSN: 27:2834:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#43f574a6-d674-4779-b661-4ceb3659e29b'}). This is an informational message only. No user action is required.
06/29/2007 04:04:59,Backup,Unknown,Database backed up. Database: NEWSFILE<c/> creation date(time): 2007/03/23(11:49:44)<c/> pages dumped: 223800<c/> first LSN: 5678:38062:91<c/> last LSN: 5678:38108:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#e0b6624f-f9e9-4f3e-960c-abf307b31e49'}). This is an informational message only. No user action is required.
06/29/2007 04:04:11,Backup,Unknown,Database backed up. Database: MegaLIB<c/> creation date(time): 2007/05/17(16:20:40)<c/> pages dumped: 187<c/> first LSN: 34:1723:37<c/> last LSN: 34:1739:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2a63636e-9639-492e-bf69-e42085d19a47'}). This is an informational message only. No user action is required.
06/29/2007 04:04:09,Backup,Unknown,Database backed up. Database: INVENTORY<c/> creation date(time): 2007/03/23(12:17:43)<c/> pages dumped: 11798<c/> first LSN: 411:2409:65<c/> last LSN: 411:2435:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#706d845f-e3d7-4a7b-8521-629f89be2a73'}). This is an informational message only. No user action is required.
06/29/2007 04:04:04,Backup,Unknown,Database backed up. Database: INEWS<c/> creation date(time): 2007/03/23(14:23:54)<c/> pages dumped: 15627<c/> first LSN: 94:16404:72<c/> last LSN: 94:16434:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#eb05358a-f960-4c53-9eb2-6fb542b640a4'}). This is an informational message only. No user action is required.
06/29/2007 04:03:58,Backup,Unknown,Database backed up. Database: HyperionSS<c/> creation date(time): 2007/03/19(17:55:10)<c/> pages dumped: 349<c/> first LSN: 124:1380:74<c/> last LSN: 124:1410:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#3c61f90d-c761-400b-9918-3cd100842ad4'}). This is an informational message only. No user action is required.
06/29/2007 04:03:55,Backup,Unknown,Database backed up. Database: HyperionBI<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 1099<c/> first LSN: 48:1312:37<c/> last LSN: 48:1328:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#d48daf21-497e-4397-924b-3811a7260cc8'}). This is an informational message only. No user action is required.
06/29/2007 04:03:52,Backup,Unknown,Database backed up. Database: HyperionAIS<c/> creation date(time): 2007/03/19(17:55:09)<c/> pages dumped: 195<c/> first LSN: 44:680:37<c/> last LSN: 44:696:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b2194d80-1c8d-4d6c-aad5-161e090814d3'}). This is an informational message only. No user action is required.
06/29/2007 04:03:49,Backup,Unknown,Database backed up. Database: HyperionAAS<c/> creation date(time): 2007/03/19(17:53:48)<c/> pages dumped: 491<c/> first LSN: 45:2824:37<c/> last LSN: 45:2840:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b25941f5-f32e-43fb-a6c5-74d121fb3f90'}). This is an informational message only. No user action is required.
06/29/2007 04:03:47,Backup,Unknown,Database backed up. Database: HOTLINE<c/> creation date(time): 2007/03/20(10:54:42)<c/> pages dumped: 267<c/> first LSN: 25:4113:37<c/> last LSN: 25:4129:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#18c5054e-490b-473b-9e0b-5bab4593272e'}). This is an informational message only. No user action is required.
06/29/2007 04:03:44,Backup,Unknown,Database backed up. Database: EMEDIA<c/> creation date(time): 2007/03/26(12:27:39)<c/> pages dumped: 235<c/> first LSN: 58:3684:58<c/> last LSN: 58:3708:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1c62a71b-f0e6-43a5-a96c-ecd342022daf'}). This is an informational message only. No user action is required.
06/29/2007 04:03:41,Backup,Unknown,Database backed up. Database: EKLOGES_OLD<c/> creation date(time): 2007/03/19(15:17:03)<c/> pages dumped: 291<c/> first LSN: 26:416:37<c/> last LSN: 26:432:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a9b40e52-6465-4744-a401-406901789e0c'}). This is an informational message only. No user action is required.
06/29/2007 04:03:37,Backup,Unknown,Database backed up. Database: EKLOGES_2006w1<c/> creation date(time): 2007/03/19(15:13:58)<c/> pages dumped: 2475<c/> first LSN: 26:19181:37<c/> last LSN: 26:19197:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#da624ff6-6c35-4c97-9665-e6fa6c5c5765'}). This is an informational message only. No user action is required.
06/29/2007 04:03:34,Backup,Unknown,Database backed up. Database: EKLOGES_2004v<c/> creation date(time): 2007/03/19(14:59:27)<c/> pages dumped: 3143<c/> first LSN: 60:958:37<c/> last LSN: 60:974:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#a52b3691-b199-4efe-ab95-792d79013466'}). This is an informational message only. No user action is required.
06/29/2007 04:03:30,Backup,Unknown,Database backed up. Database: EKLOGES_2002w2<c/> creation date(time): 2007/03/19(14:52:44)<c/> pages dumped: 3555<c/> first LSN: 26:13032:37<c/> last LSN: 26:13048:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1132c8d3-a0cb-49f8-aee0-9169489d9535'}). This is an informational message only. No user action is required.
06/29/2007 04:02:59,Backup,Unknown,Database backed up. Database: EKLOGES_2002w1<c/> creation date(time): 2007/03/19(14:50:21)<c/> pages dumped: 2579<c/> first LSN: 25:16904:37<c/> last LSN: 25:16920:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#2c22053b-4415-4206-9b1e-16a19ca00293'}). This is an informational message only. No user action is required.
06/29/2007 04:02:54,Backup,Unknown,Database backed up. Database: EKLOGES<c/> creation date(time): 2007/03/19(14:45:35)<c/> pages dumped: 6667<c/> first LSN: 40:2403:37<c/> last LSN: 40:2419:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#977ee3c9-f843-42ab-830e-4c42da263a9f'}). This is an informational message only. No user action is required.
06/29/2007 04:02:50,Backup,Unknown,Database backed up. Database: EDUCATION<c/> creation date(time): 2007/03/19(15:24:25)<c/> pages dumped: 515<c/> first LSN: 25:8994:37<c/> last LSN: 25:9010:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#1d554fee-ea6f-4fdc-9106-072cc02dbd1c'}). This is an informational message only. No user action is required.
06/29/2007 04:02:47,Backup,Unknown,Database backed up. Database: CitrixDS<c/> creation date(time): 2007/03/26(17:43:57)<c/> pages dumped: 539<c/> first LSN: 27:7873:37<c/> last LSN: 27:7889:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#b7613cbf-8d0b-46e4-96ee-ae4641da731f'}). This is an informational message only. No user action is required.
06/29/2007 04:02:44,Backup,Unknown,Database backed up. Database: CSDB7<c/> creation date(time): 2007/04/19(13:27:08)<c/> pages dumped: 2865<c/> first LSN: 198:389:37<c/> last LSN: 198:405:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#9ab05cf5-7b40-46cc-a0ad-8beeb5ae3b9d'}). This is an informational message only. No user action is required.
06/29/2007 04:02:39,Backup,Unknown,Database backed up. Database: CSDB<c/> creation date(time): 2007/03/26(16:18:53)<c/> pages dumped: 2354<c/> first LSN: 158:440:37<c/> last LSN: 158:456:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#d37e1310-fb07-403e-a70d-1c0931a2257d'}). This is an informational message only. No user action is required.
06/29/2007 04:02:35,Backup,Unknown,Database backed up. Database: ANALYZ72<c/> creation date(time): 2007/03/20(11:51:27)<c/> pages dumped: 307<c/> first LSN: 25:3988:37<c/> last LSN: 25:4004:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#02b53ae8-417e-48f0-a73c-a22ea9e7a604'}). This is an informational message only. No user action is required.
06/29/2007 04:02:31,Backup,Unknown,Database backed up. Database: AEPI<c/> creation date(time): 2007/03/21(16:08:39)<c/> pages dumped: 7835<c/> first LSN: 29:13524:37<c/> last LSN: 29:13540:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c7479e38-213b-4a41-a7bf-6c82b12f25d1'}). This is an informational message only. No user action is required.
06/29/2007 00:00:19,spid18s,Unknown,This instance of SQL Server has been using a process ID of 4788 since 28/6/2007 1:34:28 μμ (local) 28/6/2007 10:34:28 πμ (UTC). This is an informational message only; no user action is required.
06/28/2007 19:54:57,Logon,Unknown,Login failed for user 'MEGATVpaternag'. [CLIENT: 10.1.1.43]
06/28/2007 19:54:57,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/28/2007 19:53:23,Logon,Unknown,Login failed for user 'MEGATVpaternag'. [CLIENT: 10.1.1.43]
06/28/2007 19:53:23,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 16.
06/28/2007 19:53:05,Logon,Unknown,Login failed for user 'pilot'. [CLIENT: 10.1.1.43]
06/28/2007 19:53:05,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 19:51:30,Logon,Unknown,Login failed for user 'pilot'. [CLIENT: 10.1.1.43]
06/28/2007 19:51:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 19:50:47,Logon,Unknown,Login failed for user 'pilotusr'. [CLIENT: 10.1.1.43]
06/28/2007 19:50:47,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
06/28/2007 16:48:01,Server,Unknown,A user request from the session with SPID 75 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
06/28/2007 16:48:01,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
06/28/2007 16:48:01,spid75,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
06/28/2007 16:48:01,spid75,Unknown,Stack Signature for the dump is 0x975B0CDA
06/28/2007 16:48:01,spid75,Unknown,78132A36 Module(MSVCR80+00002A36)
06/28/2007 16:48:01,spid75,Unknown,781329AA Module(MSVCR80+000029AA)
06/28/2007 16:48:01,spid75,Unknown,0146753D Module(sqlservr+0046753D)
06/28/2007 16:48:01,spid75,Unknown,01466761 Module(sqlservr+00466761)
06/28/2007 16:48:01,spid75,Unknown,014676D8 Module(sqlservr+004676D8)
06/28/2007 16:48:01,spid75,Unknown,014677E1 Module(sqlservr+004677E1)
06/28/2007 16:48:01,spid75,Unknown,01006F3B Module(sqlservr+00006F3B)
06/28/2007 16:48:01,spid75,Unknown,01006D4C Module(sqlservr+00006D4C)
06/28/2007 16:48:01,spid75,Unknown,01006C26 Module(sqlservr+00006C26)
06/28/2007 16:48:01,spid75,Unknown,0104A331 Module(sqlservr+0004A331)
06/28/2007 16:48:01,spid75,Unknown,0104AB65 Module(sqlservr+0004AB65)
06/28/2007 16:48:01,spid75,Unk
Hi
I have been getting this message in the event viwer and my SQL server goes down. I have to go and start the service once again. Can somebody throw some light as how to solve this problem?
Please respond.
Tks.
Zolla
Installing MSDE (SP3) on a clean updated Win-XP system with all the latest fixes installed unsuccesfully. A clean systems means a fresh installed Win-XP, updated all using webupdate. And Excel 2003 installed. Thats all (not even AntiVirus (yet))
View 19 Replies View Relateddear friends/collegs:
for the past couple of weeks, we've been seeing:
SQL Server Error:
"kernel RA_Setup_IO [Bucket: 0] [slot: 0]: Process 4 generated access violation; SQL Server is terminating this process"
we're running SQL Server 6.5 sp4. on NT 4. sp3
Hi Guys,
How are you. i hope you all are having fun.
well i have an issue on one of the production box.
Version of the box: Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
As per SQL serve logs which i received couple of times.
step 1) Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0173.txt
2) SqlDumpExceptionHandler: Process 3920 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
3) Stack Signature for the dump is 0xC578316D
when i searched in google and msdn i could not found the exact solution.
if you guys have the knowledge and also got experianced about this issue.
kindly please help me in this regards and one more thing i just want to inform you all this is our production server.
I think you would understantd how criticality is this.
I really appreciate for your feedback. thank you so much,
Raghu
for the 2nd step it is haing a very huge message.
so here i have pasted some part of the message. i think this is more then enough for you all.
SqlDumpExceptionHandler: Process 3920 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 01/17/08 15:30:57 spid 97
*
* Exception Address = 0041656B
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00380008
* Input Buffer 124 bytes -
* EXEC MIS..law_ac_totals "G&A", 2008, 3, 100, 204, "emferrario"
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBEFFF 008bf000
* Invalid Address 77F80000 77FFBFFF 0007c000
* ADVAPI32 7C2D0000 7C334FFF 00065000
* KERNEL32 7C570000 7C623FFF 000b4000
* Invalid Address 77D30000 77D9EFFF 0006f000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7CF30000 7D175FFF 00246000
* GDI32 77F40000 77F7BFFF 0003c000
* USER32 77E10000 77E6EFFF 0005f000
* SHLWAPI 70A70000 70AD5FFF 00066000
* msvcrt 78000000 78044FFF 00045000
* COMCTL32 71710000 71793FFF 00084000
* sqlsort 42AE0000 42B6FFFF
Hi,
This is the problem which we face now and then. There is an automated job that run everyday night to restore the Database for reporting purposes. Before running that job an NT Task Schedular stop starts the sql server. This is to make sure that all the connections are closed. Nobody uses it at Night. But some times the job fails with bellow error message...
"Database in use. The system administrator must have exclusive use of the database to run the restore operation. [SQLSTATE 42000] (Error 3101) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013) Associated statement is not prepared [SQLSTATE HY007] (Error 0). The step failed."
Should I make the DB option set to single user mode. I don't think that is the problem.. because it runs fine most of the time..but sometime it fails.
Please help.. Thanks in advance :-)
Shyam.
Hi! I have a db with Full recovery model, when i try to run Transaction Log Backup, i get this error- sometimes sooner than reaching 90 percent, in spite of friendly working that i had before.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Msg 3202, Level 16, State 2, Line 1
Write on "D:Simaap_BackupSimaapFullBackup_870218" failed: 112(error not found)
Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
Any solution would be appreciated!!
Thanks!
'm a noob, using MS SQL 2005. Trying to use a stored procedure I got from SQL 2000 DB integrity to work with 2005. Receiving:
Message
Executed as user: MMCRSDOM eletracksql. Insert Error: Column name or number of supplied values does not match table definition. [SQLSTATE 21S01] (Error 213) RESTORE FILELIST is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Please help.
Hello,I am getting the rather odd error below; hope you can help.RESTORE DATABASE is terminating abnormally. File 'C:Program FilesMicrosoftSQL ServerMSSQL.1MSSQLData rial_44testingc' is claimed by'sysft_KB_SearchAssetsCatalog'(65540) and 'sysft_KB_SearchCatalog'(65537).The WITH MOVE clause can be used to relocate one or more files.I get this from an app our company uses to programatically restoredatabases. Below are the queries we are using:Create database trial_44testingcselect COUNT(*) as TOTAL from sysdatabases where name = 'trial_44testingc'RESTORE FILELISTONLY FROM disk ='C:HostedTrialManagementAppSourcedb43_trialmas ter'RESTORE DATABASE trial_44testingc FROM disk ='C:HostedTrialManagementAppSourcedb43_trialmas ter' WITH RECOVERY , MOVE'43_trialmaster' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc.mdf', MOVE '43_trialmaster_log'TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc.ldf', MOVE'sysft_KB_SearchCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchTicketsCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchTicketsCatalog2' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc', MOVE'sysft_KB_SearchAssetsCatalog' TO 'C:Program FilesMicrosoft SQLServerMSSQL.1MSSQLData rial_44testingc'This had been working great until I made some updates to the table structureof the db and created a new backup.Any ideas?TIAJake
View 1 Replies View RelatedI am receiving an error
"Database 'MyDatabase' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. BACKUP DATABASE is terminating abnormally."
each time I click on the button code below.
Code Snippet
Private Sub BACK_UP_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BACK_UP.Click
cmd = New SqlCommand("BACKUP DATABASE" & Me.cbdatabase.Text & "TO DISK = 'Documents and SettingsMy DocumentsPERSONAL DOCUMENTSfilename.bak' ", conn);
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
End Sub
The VB application is running from an Open SQL Server 2005 user account - ie No user account has been created for it. Do anyone know how I can resolve this issue from VB 2005 Express.
I am getting the ubiquitous error....
"The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I have a stored procedure that performs a task on a loop. Sometime it fails, somtimes it succeeds and that's just fine, the errors are handled within the stored procedure and I return counts of success and failures.
The trouble is that the package execution terminates when even one of the task fails. I don't want it to, I just want it to continue as the pakage should then go on to extract the source of the failues and post them back where they came from.
Any ideas how I can achieve this?
I have tinkered with the MaximumErrorCount setting, but I get the same result regardless of whether this is set to 0, 1, or 99999.
I also have a 'failure' path leading from the SQL task, but the package does not follow it.
I'm using an OLE DB connection and when none of the tasks fail, the process works perfectly.
Any ideas, most appreciated.
Hi,
We have SQLSERVER 7.0 in one of the production.
The clients r connected thru ODBC.
The clients doesn't gets disconnected after a task result in
increase in sqlserver log.
Can anyone advice me .
Thanks in advance
Anu
Hi.
I have an update statement that accepts
a user's text input. problem is that the string
terminates the sql update statement if there is
an apostrophe in it. so, headline='i like my brother's car"
willl terminate after "brother". "s car" is read as sql.
how is this resolved?
Code:
Dim MyCmd2 As New Data.SqlClient.SqlCommand("SET ANSI_WARNINGS OFF " & _
"UPDATE EditProfile " & _
"SET headline='"+ Me.tb_headline.Value+"', about_me='"+ Me.ta_aboutme.Value+"', edit_date='"+System.DateTime.Now.ToString+"' WHERE email_address='"+Context.User.Identity.Name.ToString+"' " & _
"SET ANSI_WARNINGS ON ", MyConn)
If a stored procedure creates a temporary table and then has a batch-terminating error -- either a fatal error or a non-fatal error in "xact_abort on" mode -- the temp table does not get dropped even though it goes out of scope:
create proc px as
create table #z(z1 int primary key)
insert #z values ('x')
go
exec px
go
select * from tempdb.sys.tables where name like '#z%' --returns row for #z
drop table #z --fails because #z out of scope
or:
create proc px as
set xact_abort on
create table #z(z1 int primary key)
insert #z values (0)
insert #z values (0)
go
exec px
go
select * from tempdb.sys.tables where name like '#z%' --returns row for #z
drop table #z --fails because #z out of scope
Is this behavior by design? It does not appear to be documented properly if so, since BOL states that "Temporary tables are automatically dropped when they go out of scope".
In any case, is there a way to delete leftover temp tables from tempdb without restarting SQL Server?
Thanks,
Ron
Hi folks,
I have come across a situation where there 10 tasks. The second task on the flow is a script task which disables all further tasks based on a condition. I thought that the logic would be better if we force terminate the package successfully at this stage itself. How can this be done.
Thanks
Subhash Subramanyam
Currently I receive the following error when executing script within a DTS package in SQL 2005 (it seems to be working in SQL 2000):
Processed 27008 pages for database 'Marketing', file 'Marketing_Data' on file 5.
Processed 1 pages for database 'Marketing', file 'Marketing_Log' on file 5.
BACKUP DATABASE successfully processed 27009 pages in 15.043 seconds (14.708 MB/sec).
(5 row(s) affected)
Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
The code I am using is:
-- the original database (use 'SET @DB = NULL' to disable backup)
DECLARE @DB varchar(200)
SET @DB = 'Marketing'
-- the backup filename
DECLARE @BackupFile varchar(2000)
SET @BackupFile = 'C:SQL2005 dbsMarketing.dat'
-- the new database name
DECLARE @TestDB2 varchar(200)
SET @TestDB2 = datename(month, dateadd(month, -1, getdate())) + convert(varchar(20), year(getdate())) + 'Inst1'
-- the new database files without .mdf/.ldf
DECLARE @RestoreFile varchar(2000)
SET @RestoreFile = 'C:SQL2005 dbs' + @TestDB2
DECLARE @RestoreLog varchar (2000)
SET @RestoreLog = 'C:SQL2005 dbs' + @TestDB2
-- ****************************************************************
-- no change below this line
-- ****************************************************************
DECLARE @query varchar(2000)
DECLARE @DataFile varchar(2000)
SET @DataFile = @RestoreFile + '.mdf'
DECLARE @LogFile varchar(2000)
SET @LogFile = @RestoreLog + '.ldf'
IF @DB IS NOT NULL
BEGIN
SET @query = 'BACKUP DATABASE ' + @DB + ' TO DISK = ' + QUOTENAME(@BackupFile, '''')
EXEC (@query)
END
-- RESTORE FILELISTONLY FROM DISK = 'C: empackup.dat'
-- RESTORE HEADERONLY FROM DISK = 'C: empackup.dat'
-- RESTORE LABELONLY FROM DISK = 'C: empackup.dat'
-- RESTORE VERIFYONLY FROM DISK = 'C: empackup.dat'
IF EXISTS(SELECT * FROM sysdatabases WHERE name = @TestDB2)
BEGIN
SET @query = 'DROP DATABASE ' + @TestDB2
EXEC (@query)
END
RESTORE HEADERONLY FROM DISK = @BackupFile
DECLARE @File int
SET @File = @@ROWCOUNT
DECLARE @Data varchar(500)
DECLARE @Log varchar(500)
SET @query = 'RESTORE FILELISTONLY FROM DISK = ' + QUOTENAME(@BackupFile , '''')
CREATE TABLE #restoretemp
(
LogicalName varchar(500),
PhysicalName varchar(500),
type varchar(10),
FilegroupName varchar(200),
size int,
maxsize bigint
)
INSERT #restoretemp EXEC (@query)
SELECT @Data = LogicalName FROM #restoretemp WHERE type = 'D'
SELECT @Log = LogicalName FROM #restoretemp WHERE type = 'L'
PRINT @Data
PRINT @Log
TRUNCATE TABLE #restoretemp
DROP TABLE #restoretemp
IF @File > 0
BEGIN
SET @query = 'RESTORE DATABASE ' + @TestDB2 + ' FROM DISK = ' + QUOTENAME(@BackupFile, '''') +
' WITH MOVE ' + QUOTENAME(@Data, '''') + ' TO ' + QUOTENAME(@DataFile, '''') + ', MOVE ' +
QUOTENAME(@Log, '''') + ' TO ' + QUOTENAME(@LogFile, '''') + ', FILE = ' + CONVERT(varchar, @File)
EXEC (@query)
END
Hi there
I'm getting this message on my third automated backup of the transaction logs of the day. Both databases are in full recovery mode, both successfully backed up at 01.00. The transaction logs backed up perfectly happily at 01:30 and 05:30, but failed at 09:30.
The only difference between 05:30 and 09:30's backups is that the log files were shrunk at 08:15 (the databases in question are the ones that sit under ILM2007, and keeping the log files small keeps the system running better).
Is it possible that shrinking the log files causes the database to think that there hasn't been a full database backup?
Thanks
Jane
I have a problem when i restore my .DAT_BAK file. I am getting error like "The backup set holds a backup of a database other than existing database. Restore Database is terminating abnormally".
I tried by using
RESTORE DATABASE <DATABASENAME>
FROM DISK = 'D:DATAMYTEST.DAT_BAK'
WITH MOVE 'VZAI_DATA' TO D:PROGRAM FILES..MSSQLTEST.MDF',
MOVE 'VZAI_LOG' TO D:PROGRAM FILES..MSSQLTEST.LDF',
REPLACE
And also i tried like
RESTORE DATABASE <DATABASENAME>
FROM DISK = 'D:DATAMYTEST.DAT_BAK'
WITH REPLACE
When i use like this,
RESTORE FILELISTONLY FROM DISK = 'D:DATAMYTEST.DAT_BAK'. I am able to get the output as LogicalName, PhysicalName, Type, FileGroupName, Size, etc.
Can i anyone please help me out?
Thanks in Advance,
Anand Rajagopal
My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.
I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?
Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
Hi,
When I am trying to access SQL Server 2000 database from another machine i got this error
Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied
but I could access the database on same server and in that server i could access other databases in different server.
Hi All,
View 14 Replies View RelatedHi,
View 36 Replies View RelatedWhen I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.
Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected
problems when running both 2000 and 2005 SQL Server at the same database server?
3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade?
TIA,
Jeffrey
I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist
Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
if you can restore a database to Server B using Server A as the service. Meaning we would issue the command on Server A but somehow point to Server B as where we want the restore to happen.
The backup file would be in a location independent of both servers.
Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy
View 10 Replies View Related