November 17, 2009 at 3:38 am
These have been running fine until a couple of weeks ago, when I started receiving the following error message
Check Database Integrity (wavy-fin02)
Check Database integrity on Local server connection Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All user databases
Include indexes
Task start: 2009-11-17T08:28:26.
Task end: 2009-11-17T08:28:47.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS " failed with the following error: "A database snapshot cannot be created because it failed to start.
CREATE FILE encountered operating system error 1450(error not found) while attempting to open or create the physical file 'D:\\SQL\\dbarchive.mdf:MSSQL_DBCC10'.
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.
The database could not be exclusively locked to perform the operation.
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. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I cannot seem to find a resolution - can anybody help please
From what I can see, nothing is preventing exclusive access to the Db, and there is plenty of space on the disk drives
Any assistance to resolve greatly appreciated
Many thanks
November 17, 2009 at 3:55 am
just a quick question should the \\ be in the physical path or should it be \
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 17, 2009 at 4:19 am
That can happen if a previous snapshot wasn't dropped successfully. Don't know why, just have heard about it. Can you schedule a restart of SQL soon?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 17, 2009 at 4:52 am
Apologies; the \\ in the paths should actually be \
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply