regarding dbcc checkdb

  • " failed with the following error: "Database 0 cannot be autostarted during server shutdown or startup.

    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.

    please reply asap

  • What are you trying to run against the database? any integrity checks, rebuilding etc..??

    It means the process you are running is not able to get an exclusive access on the resources that its wanting to. Probably its used by some other process.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply