September 27, 2007 at 6:44 am
Hi,
I got this error while running the dbcc checkdb on one of our large databases.Could anyone tell me how to interpret this and is this fixable and how.
here are 3727 rows in 23 pages for object "sys.sysrowsetcolumns". [SQLSTATE 01000] (Message 2593) DBCC results for 'sys.sysrowsets'. [SQLSTATE 01000] (Message 2536) There are 309 rows in 3 pages for object "sys.sysrowsets". [SQLSTATE 01000] (Message 2593) DBCC results for 'sysallocunits'. [SQLSTATE 01000] (Message 2536) There are 321 rows in 4 pages for object "sysallocunits". [SQLSTATE 01000] (Message 2593) DBCC results for 'sys.sysfiles1'. [SQLSTATE 01000] (Message 2536) There are 17 rows in 3 pages for object "sys.sysfiles1". [SQLSTATE 01000] (Message 2593) DBCC results for 'sys.syshobtcolumns'. [SQLSTATE 01000] (Message 2536) There are 3727 rows in 26 pages for object "sys.syshobtcolumns". [SQLSTATE 01000] (Message 2593) DBCC results for 'sys.syshobts'. [SQLSTATE 01000] (Message 2536) There are 309 rows in 2 pages for object "sys.syshobts". [SQLSTATE 01... The step failed.
thanks
September 27, 2007 at 9:43 am
There aren't any errors in the output you posted. Can you post the complete output from your DBCC CHECKDB job?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 27, 2007 at 2:05 pm
Run checkdb with the no_infomsgs option. That way all you'll see are any errors, not the detailed breakdown of how many rows are in how many pages of each table, interesting though that information may be.
DBCC CHECKDB ('MyDB') WITH NO_INFOMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply