I do transaction logs every 4 hour.What happends after I run my optimization job at 5:00. My transaction logs at 8:00 get really big almost the same size as reg.bakup...

Thank you,

Paul, one more question,you said

Our I/O subsystem isn't reading pages correctly. All the information I posted shows that page (1:38), which SQL Server complained was corrupt,...

I don't understand what kind of I/O it is. Is it disk, cpu.. and What kind of subsystem diagnostics I need to check. Thank you

Thank you fo ryour help, but By what errors you go by knowing there is a problem.

I need to explain at work, that this is not SQl, it is I/O, Paul can you please help me. Thank you

By looking at my results by DBCC page how do you see there is a problem????

Another question:

I ran:

DBCC TRACEON (3604)

DBCC PAGE (yourdb, 1, 38, 2)

Please explain 1, 38, 2 what these numbers mean. Thank you

Thank you very much, why did I need to check for it if my db got corrupted?

Also,

What is this mean? I know that is Shows all pages in use by...

I am sorry to ask a a stuped question,but I want to know is id good that is contains 31 rows in a page?

What is this mean:

DBCC results for 'sysusers'.

There are 31 rows in 1 pages for object 'sysusers'.

Should I turn that TF on ?

why do I need to - put DBCC undocumented command output to the console instead of the errorlog?

Can you explain more how you...

Also, when our db got corrupted we rebooted sql server and db came back,db got corrupted,but could be memory of db got corrupted and didn't repair on it own? Would...

I had to do it DBCC TRACEoff (3604) 2 minutes later this is production server.

I did it like this:

DBCC TRACEoff (3604) is this correct?

DBCC CHECKTABLE (sysusers)

DBCC results for 'sysusers'.

There are 31 rows in 1 pages for object 'sysusers'.

DBCC IND (dbname, sysusers, -1)

PageFIDPagePIDIAMFIDIAMPIDObjectIDIndexIDPageTypeIndexLevelNextPageFID

139NULLNULL1011000

138139101200

140139100100

142NULLNULL1021000

141142102200

144NULLNULL1031000

143144103200

NextPagePIDPrevPageFIDPrevPagePID

000

000

000

000

000

000

000

DBCC TRACEON (3604)

DBCC PAGE (dbname, 1, 38, 2)

results:

PAGE: (1:38)

------------

BUFFER:

-------

BUF @0x00FBB280

---------------

bpage = 0x43104000...

Command(s) completed successfully.