SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 database snapshot
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SQL_UI
Starting Member

Canada
4 Posts

Posted - 10/01/2013 :  13:17:14  Show Profile  Reply with Quote
we have SQL 2008 R2 standard edition. one of our databases has issue to run DBCC CHECKDB. the other databases don't have this DBCC CHECKDB error. the database doesn't have this error for 2 weeks after database restore from backup. it fails again after two weeks. we ran the DBCC CHECKDB against the same database after restore into different name without this errors.

any advise will be appreciated.

thanks

"CREATE FILE encountered operating system error 1393(The disk structure is corrupted and unreadable.) while attempting to open or create the physical file *.mdf:MSSQL_DBCC13"

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 10/01/2013 :  13:29:15  Show Profile  Reply with Quote
You need to follow up with your server/storage team. The problem is the drive where that database resides where the system is having an issue created the database snapshot for the CHECKDB process.
Go to Top of Page

SQL_UI
Starting Member

Canada
4 Posts

Posted - 10/01/2013 :  13:38:23  Show Profile  Reply with Quote
we did. the DBCC CHECKDB run fine for a couple of weeks after database backup/restore. we use Melio file format. more details

"[SQLSTATE 42000] (Error 1823) CREATE FILE encountered operating system error 1393
(The disk structure is corrupted and unreadable.) while attempting to open or create the physical file
'*.mdf:MSSQL_DBCC13'. [SQLSTATE 42000] (Error 5123)
The database snapshot for online checks could not be created. Either the reason is given in a previous
error or one of the underlying volumes does not support sparse files or alternate streams.
Attempting to get exclusive access to run checks offline. [SQLSTATE 42000] (Error 7928)
DBCC results for 'ArchiveBatchDetail'. [SQLSTATE 01000] (Error 2536) There are 4864 rows in 94 pages
for object "ArchiveBatchDetail". [SQLSTATE 01000] (Error 2593) DBCC execution completed.
If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Error 2528).
The step failed."
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 10/02/2013 :  14:40:40  Show Profile  Reply with Quote
The answer is in the error message...the volume where you have the database does not support sparse files.

You have to configure the file system to allow for NTFS sparse files. I would review the configuration and verify that the volume you are using does in fact have sparse files enabled. If not, it needs to be enabled - if it is enabled and you are still having problems you need to follow up with the vendor.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000