Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 checkdb fails

Author  Topic 

kumarasj
Starting Member

4 Posts

Posted - 2010-08-03 : 05:30:38
why checkdb fails on system databases? it's run fine on snapshot of the system database


kumar

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-03 : 06:09:42
Dunno, what's the error?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

kumarasj
Starting Member

4 Posts

Posted - 2010-08-03 : 06:45:27
exclusive lock


kumar
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-03 : 08:26:22
Be specific. I can't see your screen, I can't read your mind.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

kumarasj
Starting Member

4 Posts

Posted - 2010-08-04 : 01:49:15
It's not logged any erros on job history. The checkdb failed on 2009, now iam analyzing the thing why it's failed, after that we didn't run the checkdb on the particular server

kumar
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-04 : 04:15:27
The checkDB failed last year and you haven't run one since?

If it's giving errors and you want help, you'll need to post the full text of the error, the command run, any unusual circumstances, etc.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-04 : 10:42:19
Oh my!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-04 : 14:16:51
quote:
Originally posted by tkizer

Oh my!

Tara Kizer


Your reaction just made my day. :-)

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -