would it make any complication if I need to add new partition(split last partition) and already millions of records exist on last partition? exp. I have Jan, Feb partition and...

I have the same problem in one of our user database, same corruption error message, memory dump, etc.. but checkdb is clean.

I am going to try checkdb with REPAIR_REBUILD to...

WOW, this is interesting I though would be good to share it since it is related.

SQL 2005 SP3, Server A has link server to Server B (be made using current...

well , I did not run checkcatalog in SQL2000 (I though checkdb will ran that too) well, luckily sql2005 is not in production yet so I fix the problem...

having the same issue when detach/attach databases from 2000 to 2005,

error:

Msg 8992, Level 16, State 1, Line 1

Check Catalog Msg 3853, State 1: Attribute

(referenced_major_id=498569310,referenced_minor_id=1) of row (class=0,object_id=235304048,column_id=0,referenced_major_id=498569310,referenced_minor_id=1) in...

sorry forgot to say:

yes, I disconnect users for restore process also logship history does not show any clues.

the restore job only hangs but not the restore process it self so it will cause the logship go out of sysnc. I stop the job(and sometime I have to...