Microsoft KB Archive/926905

= After you run a database consistency check of a SQL Server database, you may receive an error message when you run the chkdsk command in Windows Server 2003 =

Article ID: 926905

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
 * Microsoft Windows Server 2003, Standard Edition (32-bit x86)

-



SYMPTOMS
In Microsoft Windows Server 2003, you run a database consistency check (DBCC) of a Microsoft SQL Server 2005 database on an NTFS file system partition. If you then run the chkdsk command on this NTFS partition, you may receive the following error message:

Errors found. CHKDSK cannot continue in read-only mode.

Note You receive this error message after you run the following commands against the database:

dbcc checkdb

dbcc checkalloc

Note This only happens when NTFS sparse files are used and when SQL Server implements sparse files in database snapshots. For more information about sparse files and database snapshots, visit the following Microsoft Web site to download an updated version of Books Online for Microsoft SQL Server 2005:

http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx



RESOLUTION
This error message that is reported by the chkdsk command may safely be ignored. This error message is typically a reporting error and not a functional error. However, to verify that this error message is only a reporting error, you must run the chkdsk command together with the /v (verbose) switch and then examine the output. To do this, follow these steps:  At a command prompt, type chkdsk /v.

Note  is the drive on which the chkdsk command reported the error. Verify that you receive the following output:

The type of the file system is NTFS.

Volume label is SPARSE.

WARNING! F parameter not specified.

Running CHKDSK in read-only mode.

CHKDSK is verifying files (stage 1 of 3)...

File verification completed.

CHKDSK is verifying indexes (stage 2 of 3)...

Correcting sparse file record segment 29.

Index verification completed.

Errors found. CHKDSK cannot continue in read-only mode.



In this output, the &quot;Correcting sparse file record segment 29&quot; message confirms that this is a reporting error. In this case, you may safely ignore the error message that is mentioned in the 'Symptoms' section.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbscandisk kbtshoot kbprb KB926905

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.