|
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
(comments are locked)
|
|
I converted file-system to NTFS for resolving the issue.
(comments are locked)
|
|
I think by using DBBC 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
(comments are locked)
|
What do you mean with "Multiple connections"?
Multiple connections mean database is connected with two users.