?
Solved

How can I run consistency checks on this DB?

Posted on 2008-10-20
6
Medium Priority
?
462 Views
Last Modified: 2012-05-05
My backup software is reporting consistency check errors on this DB, and I'd like to confirm this myself by running the consistency checks directly.  Is there any way I can do this?
0
Comment
Question by:tballin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 6

Expert Comment

by:tchamtieh
ID: 22762565
DBCC CHECKCATALOG - Check for catalog consistency

Syntax
     DBCC CHECKCATALOG
        [('database_name' | database_id | 0 )]
           [WITH NO_INFOMSGS]

 Key:
   WITH NO_INFOMSGS - Suppresses all informational messages.
0
 

Author Comment

by:tballin
ID: 22772460
How exactly do I run those commands?
0
 
LVL 6

Expert Comment

by:tchamtieh
ID: 22793936
From SQL Management Studio, open a new query window and type the command.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:tballin
ID: 22821371
I ran this:

DBCC CHECKCATALOG - Check for catalog consistency

Syntax
     DBCC CHECKCATALOG
        [('STS_Config_11939' | database_id | 0 )]
           [WITH NO_INFOMSGS]

 Key:
   WITH NO_INFOMSGS - Suppresses all informational messages

and I get this:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '-'.
Msg 319, Level 15, State 1, Line 9
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
0
 
LVL 6

Accepted Solution

by:
tchamtieh earned 1500 total points
ID: 22826610
It should be like this, the second line I put for you for informational purposes only:

DBCC CHECKCATALOG (STS_Config_11939)
GO
0
 

Author Comment

by:tballin
ID: 22832455
That command worked, but now I'm getting another message.  

However, since you answered my first question I'll give you full credit on that.

Thanks!


Msg 1837, Level 16, State 1, Line 1
The file name "C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_Config_11939.mdf                                                                                                                                                                          " is too long to create an alternate stream name.
Msg 7928, Level 16, State 1, Line 1
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.
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
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.

Open in new window

0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question