x

DBCC CHECKDB with FAT32 file-system?

Hi,

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, 2012 at 12:33 AM in Default

Amardeep gravatar image

Amardeep
1.3k 87 88 89

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

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

answered Feb 02, 2012 at 04:57 AM

Amardeep gravatar image

Amardeep
1.3k 87 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, 2012 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, 2012 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, 2012 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, 2012 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x47
x12

asked: Jan 25, 2012 at 12:33 AM

Seen: 1516 times

Last Updated: Feb 02, 2012 at 04:57 AM