Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Urgent Issue Reg Checkdb issue please respond Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 6:21 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 7:41 AM
Points: 29, Visits: 353
Hi guys ,

I am trying to run checkdb in my prod its failing from last 2 months because of tempdb space issue ,
but on another server with same db size and tempdb size its executed successfully.
my question the one which is failing that is not properly oragnized i mean no proper indexes
but the other one has all relational properties do checkdb operates depending on how critical of database(i mean indexes and type of data)


will it operate differently on heap and index tables
Post #1469806
Posted Tuesday, July 2, 2013 8:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 14, 2013 8:05 AM
Points: 101, Visits: 108
Please send the error message.
Post #1469822
Posted Tuesday, July 2, 2013 10:27 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
if it is temp db space issues why are you worrying about other stuff.

can you post the complete errror and tempdb size and drive details with free space).


Regards
Durai Nagarajan
Post #1469841
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse