Solved

How can I run consistency checks on this DB?

Posted on 2008-10-20
6
461 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
Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

 

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 500 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

705 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