|
Posted by pardhi a via SQLMonster.com on 09/08/05 15:03
Yes there is a prob in the DB.i copied the backup file in testing server and
run checkdb dbcc checkdb fix that error but this is a long process.
looks like need to give some more space in tempdb.[81GB] but my collegue (dba)
is not accepting that way is there any other way.
Thanks simon
Simon Hayes wrote:
>You could use NOINDEX or PHYSICAL_ONLY to do a more 'lightweight' check
>- that might reduce the required space, and unless you suspect you have
>a problem that might be good enough for you.
>
>In the worst case, you could run DBCC CHECKALLOC and then write a loop
>to run DBCC CHECKTABLE for each table - that's equivalent (as far as I
>know, but I have to admit I'm not entirely sure) to running DBCC
>CHECKDB.
>
>Simon
--
Message posted via http://www.sqlmonster.com
Navigation:
[Reply to this message]
|