InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 23:40:26 GMT20http://www.sqlservercentral.com/Forums/Topic719355-54-1.aspxWhat ever happened to this thread ? no end results , resolutions ? Just curious.Fri, 23 Oct 2009 18:11:24 GMTnpcrwill8http://www.sqlservercentral.com/Forums/Topic719355-54-1.aspxWhat ever happened to thsi thread ? to end results , resolutions ? Just curious.Fri, 23 Oct 2009 18:10:53 GMTnpcrwill8http://www.sqlservercentral.com/Forums/Topic719355-54-1.aspxMy environment: 2 node Active/Active MS Cluster running Windows 2003 Enterprise SP2 and SQL 2000 with SP4I'm currently in a situation where the transaction log on one of my database instances filled up the 20GB log partition and although I see the SQL Server resource is runnning in Cluster Admin I cannnot connect to any database in Enterprise Admin. I tried failing over the node to the second server but no such luck. I also tried manually starting the SQL Server from the command line in single user mode but received an Error: 3449, Severity: 21 State: 1 - An error has occurred that requires SQL Server to shut down so that recovery can be performed on database ID 1.. I was attempting to run SQL Query Analyzer and shrink and truncate the transaction log but again I'm unable to connect to any of the DB's. The database is set to Simple recovery and I have a valid backup I can restore from if necessary.I read that you can drop the db and reattach which will recreate the transaction log with the default size but run out of ideas. I could really use some help on this issue.Below are the events I'm receiving as well as information from the cluster.log and the output when attempting to start the db from command line in single user mode.Events received:Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Native Client]Query timeout expired.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] OnlineThread: QP is not online..Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: ErrorEvent Source: MSSQL$QDB02Event Category: (3)Event ID: 19019Date: 5/18/2009Time: 1:21:44 PMUser: N/AComputer: CNSLI-SQL-01Description:The description for Event ID ( 19019 ) in Source ( MSSQL$QDB02 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure.Data:0000: 4b 4a 00 40 01 00 00 00 KJ.@....0008: 09 00 00 00 56 00 2d 00 ....V.-.0010: 41 00 4d 00 32 00 2d 00 A.M.2.-.0018: 30 00 31 00 00 00 00 00 0.1.....0020: 00 00 .. Event Type: InformationEvent Source: SQLAgent$QDB02Event Category: Service ControlEvent ID: 102Date: 5/18/2009Time: 1:21:47 PMUser: N/AComputer: V-AM2-01Description:SQLServerAgent service successfully stopped.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Cluster.log output:000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB872.tmp, status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB872.tmp, status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1000008c4.000005c8::2009/05/18-17:29:37.626 INFO [CP] CppWriteCheckpoint checkpointing file C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB872.tmp to file Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55\00000004.CPT000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsCreateDirectory Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55, status 183000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB872.tmp => 3, e2c status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsOpenFile Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55\00000004.CPT => 2, 1384 status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] ReadFile e2c (regf) 32768 12288, (0=>0) 0 status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] WriteFile 1384 (regf) 12288, status 0 (0=>0)000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] ReadFile e2c (regf) 32768 0, (0=>0) 0 status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsFlushBuffers 1384, status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB872.tmp, status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [CP] CppRegNotifyThread checkpointing key SOFTWARE\Microsoft\Microsoft SQL Server\QDB05\MSSQLSERVER to id 4 due to timer000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsGetTempFileName C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\, CLS, 47219 => C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp, status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp, status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp, status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1000008c4.0000037c::2009/05/18-17:29:41.501 INFO [CP] CppWriteCheckpoint checkpointing file C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp to file Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430\00000004.CPT000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsCreateDirectory Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430, status 183000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp => 3, 1384 status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsOpenFile Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430\00000004.CPT => 2, e2c status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] ReadFile 1384 (regf) 32768 12288, (0=>0) 0 status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] WriteFile e2c (regf) 12288, status 0 (0=>0)000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] ReadFile 1384 (regf) 32768 0, (0=>0) 0 status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsFlushBuffers e2c, status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp, status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [CP] CppRegNotifyThread checkpointing key Software\Microsoft\Microsoft SQL Server\MSSQL.4\MSSQLSERVER to id 4 due to timer000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsGetTempFileName C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\, CLS, 47220 => C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp, status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp, status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp, status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1000008c4.000005c8::2009/05/18-17:29:42.517 INFO [CP] CppWriteCheckpoint checkpointing file C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp to file Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd\00000004.CPT000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsCreateDirectory Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd, status 183000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp => 3, e2c status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsOpenFile Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd\00000004.CPT => 2, 1384 status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] ReadFile e2c (regf) 32768 16384, (0=>0) 0 status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] WriteFile 1384 (regf) 16384, status 0 (0=>0)000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] ReadFile e2c (regf) 32768 0, (0=>0) 0 status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsFlushBuffers 1384, status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp, status 0000008c4.00002d94::2009/05/18-17:30:05.596 INFO [CP] CppDepositCheckpoint checkpointing data to file Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae\00000002.CPT000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] QfsCreateDirectory Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae, status 183000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] QfsOpenFile Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae\00000002.CPT => 2, 1384 status 0000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] WriteFile 1384 (regf) 3860, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] WriteFile 1384 (....) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] WriteFile 1384 (....) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] WriteFile 1384 (....) 236, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] QfsFlushBuffers 1384, status 0000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [CP] CppRegNotifyThread checkpointing key SOFTWARE\Microsoft\Microsoft SQL Server\QDB04\MSSQLSERVER to id 4 due to timer000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsGetTempFileName C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\, CLS, 47221 => C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp, status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp, status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp, status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1000008c4.0000037c::2009/05/18-17:30:23.253 INFO [CP] CppWriteCheckpoint checkpointing file C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp to file Q:\MSCS\dc8246cc-33b4-4654-9aff-22fdc6889bbe\00000004.CPT000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsCreateDirectory Q:\MSCS\dc8246cc-33b4-4654-9aff-22fdc6889bbe, status 183000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp => 3, 1384 status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsOpenFile Q:\MSCS\dc8246cc-33b4-4654-9aff-22fdc6889bbe\00000004.CPT => 2, e2c status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] ReadFile 1384 (regf) 32768 12288, (0=>0) 0 status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] WriteFile e2c (regf) 12288, status 0 (0=>0)000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] ReadFile 1384 (regf) 32768 0, (0=>0) 0 status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsFlushBuffers e2c, status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp, status 0000008c4.00002d94::2009/05/18-17:30:35.675 INFO [CP] CppDepositCheckpoint checkpointing data to file Q:\MSCS\9e4b58d0-8d24-4f6b-a37d-aad9a170fd8c\00000002.CPT000008c4.00002d94::2009/05/18-17:30:35.675 INFO [Qfs] QfsCreateDirectory Q:\MSCS\9e4b58d0-8d24-4f6b-a37d-aad9a170fd8c, status 183000008c4.00002d94::2009/05/18-17:30:35.675 INFO [Qfs] QfsOpenFile Q:\MSCS\9e4b58d0-8d24-4f6b-a37d-aad9a170fd8c\00000002.CPT => 2, e2c status 0000008c4.00002d94::2009/05/18-17:30:35.675 INFO [Qfs] WriteFile e2c (regf) 3860, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:35.675 INFO [Qfs] WriteFile e2c (....) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:35.675 INFO [Qfs] WriteFile e2c (....) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:35.675 INFO [Qfs] WriteFile e2c (....) 236, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:35.690 INFO [Qfs] QfsFlushBuffers e2c, status 0000008c4.00002d94::2009/05/18-17:30:35.690 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.00002d94::2009/05/18-17:30:37.097 INFO [CP] CppDepositCheckpoint checkpointing data to file Q:\MSCS\b74f4b6e-fc94-43b5-a818-a0a106f39a4c\00000002.CPT000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] QfsCreateDirectory Q:\MSCS\b74f4b6e-fc94-43b5-a818-a0a106f39a4c, status 183000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] QfsOpenFile Q:\MSCS\b74f4b6e-fc94-43b5-a818-a0a106f39a4c\00000002.CPT => 2, e2c status 0000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] WriteFile e2c (regf) 3860, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] WriteFile e2c (....) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] WriteFile e2c (....) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] WriteFile e2c (vk..) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] WriteFile e2c (....) 236, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] QfsFlushBuffers e2c, status 0000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.000005c8::2009/05/18-17:30:37.628 INFO [CP] CppRegNotifyThread checkpointing key SOFTWARE\Microsoft\Microsoft SQL Server\QDB03\MSSQLSERVER to id 4 due to timer000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsGetTempFileName C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\, CLS, 47222 => C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp, status 0000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp, status 0000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp, status 0000008c4.000005c8::2009/05/18-17:30:37.628 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1000008c4.000005c8::2009/05/18-17:30:37.628 INFO [CP] CppWriteCheckpoint checkpointing file C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp to file Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55\00000004.CPT000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsCreateDirectory Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55, status 183000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp => 3, e2c status 0000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsOpenFile Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55\00000004.CPT => 2, 1384 status 0000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] ReadFile e2c (regf) 32768 12288, (0=>0) 0 status 0000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] WriteFile 1384 (regf) 12288, status 0 (0=>0)000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] ReadFile e2c (regf) 32768 0, (0=>0) 0 status 0000008c4.000005c8::2009/05/18-17:30:37.644 INFO [Qfs] QfsFlushBuffers 1384, status 0000008c4.000005c8::2009/05/18-17:30:37.644 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.000005c8::2009/05/18-17:30:37.644 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.000005c8::2009/05/18-17:30:37.644 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp, status 0000008c4.0000037c::2009/05/18-17:30:41.503 INFO [CP] CppRegNotifyThread checkpointing key SOFTWARE\Microsoft\Microsoft SQL Server\QDB05\MSSQLSERVER to id 4 due to timer000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsGetTempFileName C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\, CLS, 47223 => C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp, status 0000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp, status 0000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp, status 0000008c4.0000037c::2009/05/18-17:30:41.503 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1000008c4.0000037c::2009/05/18-17:30:41.503 INFO [CP] CppWriteCheckpoint checkpointing file C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp to file Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430\00000004.CPT000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsCreateDirectory Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430, status 183000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp => 3, 1384 status 0000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsOpenFile Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430\00000004.CPT => 2, e2c status 0000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] ReadFile 1384 (regf) 32768 12288, (0=>0) 0 status 0000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] WriteFile e2c (regf) 12288, status 0 (0=>0)000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] ReadFile 1384 (regf) 32768 0, (0=>0) 0 status 0000008c4.0000037c::2009/05/18-17:30:41.519 INFO [Qfs] QfsFlushBuffers e2c, status 0000008c4.0000037c::2009/05/18-17:30:41.519 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.0000037c::2009/05/18-17:30:41.519 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.0000037c::2009/05/18-17:30:41.519 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp, status 0000008c4.000005c8::2009/05/18-17:30:42.519 INFO [CP] CppRegNotifyThread checkpointing key Software\Microsoft\Microsoft SQL Server\MSSQL.4\MSSQLSERVER to id 4 due to timer000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsGetTempFileName C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\, CLS, 47224 => C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp, status 0000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp, status 0000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp, status 0000008c4.000005c8::2009/05/18-17:30:42.519 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1000008c4.000005c8::2009/05/18-17:30:42.519 INFO [CP] CppWriteCheckpoint checkpointing file C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp to file Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd\00000004.CPT000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsCreateDirectory Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd, status 183000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp => 3, e2c status 0000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsOpenFile Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd\00000004.CPT => 2, 1384 status 0000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] ReadFile e2c (regf) 32768 16384, (0=>0) 0 status 0000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] WriteFile 1384 (regf) 16384, status 0 (0=>0)000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] ReadFile e2c (regf) 32768 0, (0=>0) 0 status 0000008c4.000005c8::2009/05/18-17:30:42.534 INFO [Qfs] QfsFlushBuffers 1384, status 0000008c4.000005c8::2009/05/18-17:30:42.534 INFO [Qfs] QfsCloseHandle e2c, status 0000008c4.000005c8::2009/05/18-17:30:42.534 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.000005c8::2009/05/18-17:30:42.534 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp, status 0000008c4.00002d94::2009/05/18-17:31:05.597 INFO [CP] CppDepositCheckpoint checkpointing data to file Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae\00000002.CPT000008c4.00002d94::2009/05/18-17:31:05.597 INFO [Qfs] QfsCreateDirectory Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae, status 183000008c4.00002d94::2009/05/18-17:31:05.597 INFO [Qfs] QfsOpenFile Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae\00000002.CPT => 2, 1384 status 0000008c4.00002d94::2009/05/18-17:31:05.597 INFO [Qfs] WriteFile 1384 (regf) 3860, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:31:05.597 INFO [Qfs] WriteFile 1384 (....) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:31:05.597 INFO [Qfs] WriteFile 1384 (....) 4096, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:31:05.597 INFO [Qfs] WriteFile 1384 (....) 236, status 0 (0=>0)000008c4.00002d94::2009/05/18-17:31:05.613 INFO [Qfs] QfsFlushBuffers 1384, status 0000008c4.00002d94::2009/05/18-17:31:05.613 INFO [Qfs] QfsCloseHandle 1384, status 0000008c4.00000ddc::2009/05/18-17:31:09.894 INFO [Qfs] GetDiskFreeSpaceEx Q:\MSCS\, status 0Output when manually starting the SQL Server from command line in single user mode:single user mode output C:\Program Files\Microsoft SQL Server\MSSQL$QDB02\Binn>sqlservr -m -c -s QDB022009-05-18 12:23:55.86 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)2009-05-18 12:23:55.86 server Copyright (C) 1988-2002 Microsoft Corporation.2009-05-18 12:23:55.86 server All rights reserved.2009-05-18 12:23:55.86 server Server Process ID is 11480.2009-05-18 12:23:55.86 server Logging SQL Server messages in file 'u:\data\MSSQL$QDB02\log\ERRORLOG'.2009-05-18 12:23:55.87 server SQL Server is starting at priority class 'normal'(8 CPUs detected).2009-05-18 12:23:55.95 server SQL Server configured for thread mode processing.2009-05-18 12:23:55.97 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.2009-05-18 12:23:56.09 server Attempting to initialize Distributed Transaction Coordinator.2009-05-18 12:23:57.56 spid3 Warning ******************2009-05-18 12:23:57.56 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.2009-05-18 12:23:57.56 spid3 Starting up database 'master'.2009-05-18 12:23:57.67 spid3 0 transactions rolled back in database 'master' (1).2009-05-18 12:23:57.67 spid3 Recovery is checkpointing database 'master' (1)2009-05-18 12:23:57.70 server Using 'SSNETLIB.DLL' version '8.0.2039'.2009-05-18 12:23:57.70 spid5 Starting up database 'model'.2009-05-18 12:23:57.72 spid3 Server name is 'CNSLI-SQL-01\QDB02'.2009-05-18 12:23:57.72 spid7 Starting up database 'msdb'.2009-05-18 12:23:57.72 spid9 Starting up database 'Northwind'.2009-05-18 12:23:57.72 spid8 Starting up database 'pubs'.2009-05-18 12:23:57.72 spid10 Starting up database 'QDB'.2009-05-18 12:23:57.73 server SQL server listening on 192.168.254.157: 2738.2009-05-18 12:23:57.76 spid5 Clearing tempdb database.2009-05-18 12:23:57.76 server SQL server listening on TCP, Shared Memory, Named Pipes.2009-05-18 12:23:57.78 server SQL Server is ready for client connections2009-05-18 12:23:57.89 spid5 Starting up database 'tempdb'.2009-05-18 12:23:57.92 spid5 Analysis of database 'tempdb' (2) is 100% complete (approximately 0 more seconds)2009-05-18 12:23:58.67 spid10 Analysis of database 'QDB' (7) is 2% complete (approximately 17 more seconds)2009-05-18 12:24:01.72 spid10 Analysis of database 'QDB' (7) is 30% complete(approximately 7 more seconds)2009-05-18 12:24:07.56 spid1 Warning: unable to allocate 'min server memory' of 6144MB.2009-05-18 12:24:07.87 spid10 Analysis of database 'QDB' (7) is 74% complete(approximately 3 more seconds)2009-05-18 12:24:11.59 spid10 Analysis of database 'QDB' (7) is 100% complete (approximately 0 more seconds)2009-05-18 12:24:11.78 spid10 Recovery of database 'QDB' (7) is 0% complete (approximately 6537 more seconds) (Phase 2 of 3).2009-05-18 12:24:31.79 spid10 Recovery of database 'QDB' (7) is 0% complete (approximately 5774 more seconds) (Phase 2 of 3).2009-05-18 12:24:59.64 spid10 Recovery of database 'QDB' (7) is 0% complete (approximately 5760 more seconds) (Phase 2 of 3).2009-05-18 12:25:14.77 spid10 Recovery of database 'QDB' (7) is 1% complete (approximately 5745 more seconds) (Phase 2 of 3).2009-05-18 12:25:26.33 spid10 ForwardLogBlockReadAheadAsync: Operating system error 21(The device is not ready.) encountered.2009-05-18 12:25:26.53 spid10 Error: 3313, Severity: 21, State: 22009-05-18 12:25:26.53 spid10 Error while redoing logged operation in database 'QDB'. Error at log record ID (428542:311395:1)..2009-05-18 12:25:26.55 spid2 LogWriter: Operating system error 21(The device is not ready.) encountered.2009-05-18 12:25:26.55 spid2 Write error during log flush. Shutting down server2009-05-18 12:25:26.55 spid10 Error: 3449, Severity: 21, State: 12009-05-18 12:25:26.55 spid10 An error has occurred that requires SQL Serverto shut down so that recovery can be performed on database ID 1..Mon, 18 May 2009 13:11:10 GMTmkoprowski@computerns.com