Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server resource failing on SQL 2000 cluster Expand / Collapse
Author
Message
Posted Monday, May 18, 2009 1:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 18, 2009 2:06 PM
Points: 1, Visits: 10
My environment:
2 node Active/Active MS Cluster running Windows 2003 Enterprise SP2 and SQL 2000 with SP4

I'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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Error
Event Source: MSSQL$QDB02
Event Category: (3)
Event ID: 19019
Date: 5/18/2009
Time: 1:21:44 PM
User: N/A
Computer: CNSLI-SQL-01
Description:
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: Information
Event Source: SQLAgent$QDB02
Event Category: Service Control
Event ID: 102
Date: 5/18/2009
Time: 1:21:47 PM
User: N/A
Computer: V-AM2-01
Description:
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 0
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB872.tmp, status 0
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1
000008c4.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.CPT
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsCreateDirectory Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55, status 183
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB872.tmp => 3, e2c status 0
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsOpenFile Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55\00000004.CPT => 2, 1384 status 0
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] ReadFile e2c (regf) 32768 12288, (0=>0) 0 status 0
000008c4.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 0
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsFlushBuffers 1384, status 0
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.000005c8::2009/05/18-17:29:37.626 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB872.tmp, status 0
000008c4.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 timer
000008c4.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 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp, status 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp, status 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1
000008c4.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.CPT
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsCreateDirectory Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430, status 183
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp => 3, 1384 status 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsOpenFile Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430\00000004.CPT => 2, e2c status 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] ReadFile 1384 (regf) 32768 12288, (0=>0) 0 status 0
000008c4.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 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsFlushBuffers e2c, status 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.0000037c::2009/05/18-17:29:41.501 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB873.tmp, status 0
000008c4.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 timer
000008c4.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 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp, status 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp, status 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1
000008c4.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.CPT
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsCreateDirectory Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd, status 183
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp => 3, e2c status 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsOpenFile Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd\00000004.CPT => 2, 1384 status 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] ReadFile e2c (regf) 32768 16384, (0=>0) 0 status 0
000008c4.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 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsFlushBuffers 1384, status 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.000005c8::2009/05/18-17:29:42.517 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB874.tmp, status 0
000008c4.00002d94::2009/05/18-17:30:05.596 INFO [CP] CppDepositCheckpoint checkpointing data to file Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae\00000002.CPT
000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] QfsCreateDirectory Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae, status 183
000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] QfsOpenFile Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae\00000002.CPT => 2, 1384 status 0
000008c4.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 0
000008c4.00002d94::2009/05/18-17:30:05.596 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.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 timer
000008c4.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 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp, status 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp, status 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1
000008c4.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.CPT
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsCreateDirectory Q:\MSCS\dc8246cc-33b4-4654-9aff-22fdc6889bbe, status 183
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp => 3, 1384 status 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsOpenFile Q:\MSCS\dc8246cc-33b4-4654-9aff-22fdc6889bbe\00000004.CPT => 2, e2c status 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] ReadFile 1384 (regf) 32768 12288, (0=>0) 0 status 0
000008c4.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 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsFlushBuffers e2c, status 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.0000037c::2009/05/18-17:30:23.253 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB875.tmp, status 0
000008c4.00002d94::2009/05/18-17:30:35.675 INFO [CP] CppDepositCheckpoint checkpointing data to file Q:\MSCS\9e4b58d0-8d24-4f6b-a37d-aad9a170fd8c\00000002.CPT
000008c4.00002d94::2009/05/18-17:30:35.675 INFO [Qfs] QfsCreateDirectory Q:\MSCS\9e4b58d0-8d24-4f6b-a37d-aad9a170fd8c, status 183
000008c4.00002d94::2009/05/18-17:30:35.675 INFO [Qfs] QfsOpenFile Q:\MSCS\9e4b58d0-8d24-4f6b-a37d-aad9a170fd8c\00000002.CPT => 2, e2c status 0
000008c4.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 0
000008c4.00002d94::2009/05/18-17:30:35.690 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.00002d94::2009/05/18-17:30:37.097 INFO [CP] CppDepositCheckpoint checkpointing data to file Q:\MSCS\b74f4b6e-fc94-43b5-a818-a0a106f39a4c\00000002.CPT
000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] QfsCreateDirectory Q:\MSCS\b74f4b6e-fc94-43b5-a818-a0a106f39a4c, status 183
000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] QfsOpenFile Q:\MSCS\b74f4b6e-fc94-43b5-a818-a0a106f39a4c\00000002.CPT => 2, e2c status 0
000008c4.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 0
000008c4.00002d94::2009/05/18-17:30:37.097 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.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 timer
000008c4.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 0
000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp, status 0
000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp, status 0
000008c4.000005c8::2009/05/18-17:30:37.628 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1
000008c4.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.CPT
000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsCreateDirectory Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55, status 183
000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp => 3, e2c status 0
000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] QfsOpenFile Q:\MSCS\d9fb84ce-53eb-4af8-a79a-7828032d6a55\00000004.CPT => 2, 1384 status 0
000008c4.000005c8::2009/05/18-17:30:37.628 INFO [Qfs] ReadFile e2c (regf) 32768 12288, (0=>0) 0 status 0
000008c4.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 0
000008c4.000005c8::2009/05/18-17:30:37.644 INFO [Qfs] QfsFlushBuffers 1384, status 0
000008c4.000005c8::2009/05/18-17:30:37.644 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.000005c8::2009/05/18-17:30:37.644 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.000005c8::2009/05/18-17:30:37.644 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB876.tmp, status 0
000008c4.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 timer
000008c4.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 0
000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp, status 0
000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp, status 0
000008c4.0000037c::2009/05/18-17:30:41.503 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1
000008c4.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.CPT
000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsCreateDirectory Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430, status 183
000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp => 3, 1384 status 0
000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] QfsOpenFile Q:\MSCS\802ca791-4879-446f-b198-9518ea6e5430\00000004.CPT => 2, e2c status 0
000008c4.0000037c::2009/05/18-17:30:41.503 INFO [Qfs] ReadFile 1384 (regf) 32768 12288, (0=>0) 0 status 0
000008c4.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 0
000008c4.0000037c::2009/05/18-17:30:41.519 INFO [Qfs] QfsFlushBuffers e2c, status 0
000008c4.0000037c::2009/05/18-17:30:41.519 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.0000037c::2009/05/18-17:30:41.519 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.0000037c::2009/05/18-17:30:41.519 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB877.tmp, status 0
000008c4.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 timer
000008c4.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 0
000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp, status 0
000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsRegSaveKey C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp, status 0
000008c4.000005c8::2009/05/18-17:30:42.519 INFO [CP] CpSaveData: checkpointing data id 4 to quorum node 1
000008c4.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.CPT
000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsCreateDirectory Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd, status 183
000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsOpenFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp => 3, e2c status 0
000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] QfsOpenFile Q:\MSCS\18555d04-b14d-4078-9dce-bdda7cbb7dfd\00000004.CPT => 2, 1384 status 0
000008c4.000005c8::2009/05/18-17:30:42.519 INFO [Qfs] ReadFile e2c (regf) 32768 16384, (0=>0) 0 status 0
000008c4.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 0
000008c4.000005c8::2009/05/18-17:30:42.534 INFO [Qfs] QfsFlushBuffers 1384, status 0
000008c4.000005c8::2009/05/18-17:30:42.534 INFO [Qfs] QfsCloseHandle e2c, status 0
000008c4.000005c8::2009/05/18-17:30:42.534 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.000005c8::2009/05/18-17:30:42.534 INFO [Qfs] QfsDeleteFile C:\DOCUME~1\SVCCLU~1\LOCALS~1\Temp\CLSB878.tmp, status 0
000008c4.00002d94::2009/05/18-17:31:05.597 INFO [CP] CppDepositCheckpoint checkpointing data to file Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae\00000002.CPT
000008c4.00002d94::2009/05/18-17:31:05.597 INFO [Qfs] QfsCreateDirectory Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae, status 183
000008c4.00002d94::2009/05/18-17:31:05.597 INFO [Qfs] QfsOpenFile Q:\MSCS\f416537d-4a46-43b4-be9f-2e252e99d6ae\00000002.CPT => 2, 1384 status 0
000008c4.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 0
000008c4.00002d94::2009/05/18-17:31:05.613 INFO [Qfs] QfsCloseHandle 1384, status 0
000008c4.00000ddc::2009/05/18-17:31:09.894 INFO [Qfs] GetDiskFreeSpaceEx Q:\MSCS\, status 0


Output 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 QDB02
2009-05-18 12:23:55.86 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X
86)
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\MS
SQL$QDB02\log\ERRORLOG'.
2009-05-18 12:23:55.87 server SQL Server is starting at priority class 'norma
l'(8 CPUs detected).
2009-05-18 12:23:55.95 server SQL Server configured for thread mode processin
g.
2009-05-18 12:23:55.97 server Using dynamic lock allocation. [2500] Lock Bloc
ks, [5000] Lock Owner Blocks.
2009-05-18 12:23:56.09 server Attempting to initialize Distributed Transactio
n 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, Nam
ed Pipes.
2009-05-18 12:23:57.78 server SQL Server is ready for client connections
2009-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% compl
ete (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: 2
2009-05-18 12:25:26.53 spid10 Error while redoing logged operation in databas
e '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 ser
ver
2009-05-18 12:25:26.55 spid10 Error: 3449, Severity: 21, State: 1
2009-05-18 12:25:26.55 spid10 An error has occurred that requires SQL Server
to shut down so that recovery can be performed on database ID 1..



Post #719355
Posted Friday, October 23, 2009 6:10 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, March 21, 2014 3:24 PM
Points: 53, Visits: 233
What ever happened to thsi thread ? to end results , resolutions ? Just curious.


Post #808215
Posted Friday, October 23, 2009 6:11 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, March 21, 2014 3:24 PM
Points: 53, Visits: 233
What ever happened to this thread ? no end results , resolutions ? Just curious.


Post #808216
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse