DBCC CHECKDB with FAT32 file-system?


DBCC CHECKDB is working fine on NTFS file-system and with FAT32 file-system also it is working fine on single database connection but in multiple database connection it through given error-

“Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. “

Things which is know that DBCC CHECKDB is successful on NTFS file system with multiple connection it is because DBCC CHECKDB (by default) uses a hidden database snapshot which it stores in NTFS alternate streams on the existing database data files, and FAT32 by default doesn't support alternate streams.

By changing the file system to NTFS and by disconnect the other connection on database able to run DBCC check db but mine question is that is there any other short alternate to work DBCC check db with FAT32 as it works on NTFS with multiple client.

OS- Windows XP Service pack 3 SQL- SQL Server 2005 Express Edition
more ▼

asked Jan 25 '12 at 12:33 AM in Default

Amardeep gravatar image

1.3k 84 88 89

What do you mean with "Multiple connections"?
Jan 25 '12 at 01:38 AM Magnus Ahlkvist
Multiple connections mean database is connected with two users.
Jan 25 '12 at 02:12 AM Amardeep
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
I converted file-system to NTFS for resolving the issue.
more ▼

answered Feb 02 '12 at 04:57 AM

Amardeep gravatar image

1.3k 84 88 89

(comments are locked)
10|1200 characters needed characters left
I think by using DBBC WITH TABLOCK option it could be possible for FAT32 as this would mean no database snapshot is needed
more ▼

answered Jan 25 '12 at 02:01 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

DBCC WITH TABLOCK option will have same error if database have more then one connection.
Jan 25 '12 at 02:12 AM Amardeep
@Amardeep you are talking about short alternative approach, you can take the database into SINGLE_USER mode and then immediately can run DBCC CHECKDB WITH TABLOCK.
Jan 25 '12 at 02:37 AM Usman Butt
@Usman, I know about this but thing is that I can not put database in single user mode. I am looking any solution on database level settings through that it work like with NTFS system.
Jan 25 '12 at 02:47 AM Amardeep
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 25 '12 at 12:33 AM

Seen: 1351 times

Last Updated: Feb 02 '12 at 04:57 AM