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
asked Jan 25, 2012 at 12:33 AM in Default
I converted file-system to NTFS for resolving the issue.
answered Feb 02, 2012 at 04:57 AM
I think by using DBBC
answered Jan 25, 2012 at 02:01 AM