Solved

How can I run consistency checks on this DB?

Posted on 2008-10-20
6
458 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

856 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